Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Access 2016 in practice - ch 1 independent project 1-5

03/11/2020 Client: papadok01 Deadline: 3 days

Access 2016 Chapter 2 Using Design View, Data Validation, and Relationships Last Updated: 10/9/18 Page 1

USING MICROSOFT ACCESS 2016 Independent Project 2-5

Independent Project 2-5 Life’s Animal Shelter wants to expand the database created in the Independent Project 1-5 in Chapter 1. To ensure consistency, the starting file is provided for you. In this project, you use Design view to create a second table, edit field properties, integrate data integrity rules, and enter data. You also create a relationship between the two tables and enforce referential integrity constraints. Finally, you add data using the relationship between tables. This project has been modified for use in SIMnet®.

Skills Covered in This Project • Create a table using Design view. • Add fields into a table. • Edit field properties in Design view. • Create an input mask. • Create a validation rule and validation text. • Save a table.

• Enter records. • Create a foreign key. • Create a 1:M relationship between tables. • Enforce referential integrity. • View a table in Datasheet view and expand

related records.

1. Open the LifesAnimalShelter-02 database start file.

2. The file will be renamed automatically to include your name. Change the project file name if

directed to do so by your instructor.

3. Enable content in the security warning.

4. Create a new table using Table Design.

a. Add the following fields into the table and set field properties:

b.

c.

d.

e.

f.

g.

h.

i.

j. Set OwnerID as the primary key.

k. Save the table as Owners.

5. Create an input mask for the Phone field.

a. Select the Phone field.

b. Use the Phone Number Input Mask.

c. Don’t make any changes to the mask or placeholder character and select the Without the

symbols in the mask, like this radio button.

Step 1: Download start file

Access 2016 Chapter 2 Using Design View, Data Validation, and Relationships Last Updated: 10/9/18 Page 2

USING MICROSOFT ACCESS 2016 Independent Project 2-5

d. Finish the Input Mask Wizard.

e. Save the table.

6. Create and test a field validation rule.

a. Select the OwnerID field.

b. Type Like "####" in the Validation

Rule.

c. Type You must enter a 4-digit

Owner ID as Validation Text.

d. Save the table and switch to

Datasheet view.

e. Test the rule by typing 11 in the first

row of the OwnerID column.

f. Move to the OwnerLastName

field. The message box should

display the validation text message (Figure 2-92) since the OwnerID is not four digits long.

g. Delete the contents and type 1111 into the OwnerID field.

h. Verify that you successfully move to the OwnerLastName field since 1111 meets the

validation rule criteria.

i. Delete this test data record.

7. Enter the following records into the Owners table. Life’s Animal Shelter doesn’t have any data

about the owners stored electronically so you are unable to import any data.

a.

b.

c.

d.

e.

8. Save and close the table.

9. Determine the foreign key field. Currently there is not a field in common across the Owners and

Pets tables. There is a one-to-many relationship between the two tables since an owner could

adopt many pets, but each pet is only adopted by one owner. The foreign key comes by taking

the primary key field from the 1 table and adding it in as an additional field in the M table.

a. Open the Pets table in Design view.

b. Add the foreign key field below the Details field using the following information:

c. Save and close the Pets table.

Access 2016 Chapter 2 Using Design View, Data Validation, and Relationships Last Updated: 10/9/18 Page 3

USING MICROSOFT ACCESS 2016 Independent Project 2-5

10. Create a one-to-many relationship between the Owners and Pets tables.

a. Open the Relationships window and add the two tables.

b. Enlarge the table objects, if needed, to see all of the fields.

c. Drag the OwnerID field from the Owners table on top of the FKOwnerID field in the Pets table.

Release the pointer. The Edit Relationships dialog box displays.

d. Select the choices to Enforce Referential Integrity and Cascade Update Related Fields.

e. Leave the Cascade Delete Related Records check box not selected. The shelter does not

want to delete pet records when it deletes information about an owner.

f. Create the relationship.

g. Save the changes and close the Relationships window.

11. Enter the following data into the specified records in the Pets table to reflect which pets have

been adopted:

a. Open the Pets table in Datasheet view.

b. Type 0100 in the FKOwnerID field for PetID 1.

c. Type 0103 in the FKOwnerID field for PetID 3.

d. Type 0100 in the FKOwnerID field for PetID 12.

e. Type 0104 in the FKOwnerID field for PetID 14.

f. Close the Pets table.

12. View the related data records in the Owners table.

a. Open the Owners table in Datasheet view.

b. Click the plus sign to the left of the OwnerID field for Albert Smith, OwnerID 0100. You should

see the two pets adopted by Albert.

c. Close the Owners table.

13. Close the database.

14. Upload and save your project file.

15. Submit project for grading.

Step 2 Upload & Save

Step 3 Grade my Project

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quality Homework Helper
Buy Coursework Help
Online Assignment Help
Top Writing Guru
Essay Writing Help
Top Quality Assignments
Writer Writer Name Offer Chat
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

Hi dear, I am ready to do your homework in a reasonable price.

$55 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. I hold MBA (Strategic Management) (Finance and Marketing) & CPA.K (Accounting and Finance.)

$62 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$55 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Globalisation case study apple - 500-700 Argument Essay (Critical Thinking) - W7 Research Case - 3 7 dimethyl 4 nonyne - St martin's guide to writing 11th edition - Allegory of the cave essay - Daffodils poem by william wordsworth - Torsion of bars experiment report - Www ajot ajotpress net - Uncovering Your Rhetorical Self - Midsomer murders the fisher king susannah doyle - Sargent 7000 multipoint lock - Fred 3 camp fred loser song lyrics - Mens closet on lem turner - Human brain clay model - What is a vivid verb - Determination of the ka of a weak acid - 2 responses - Sharp bevel text effect word 2016 - How many millimeters are in 3 centimeters - Good sentence starters for persuasive writing - WK6 Discussion SOCW 6443: Treating Psychotic Disorders - Help - Reasons to study operations management include - Youth allowance rent assistance - Product count capsim - 70 486 exam questions pdf - Sacred heart church oakleigh mass times - Algebraic and geometric multiplicity - The three principles of economics include optimization, equilibrium, and empiricism. - The Cybersecurity Analyst's Toolbox - Which of the following is true of a sole proprietorship - Bill bayeh net worth - Steel structure staircase detail - Week 6 Assignment: Drafting the Abstract (Weekly Written Assignment Worksheet) - Ftse developed core infrastructure index - WK 3 DQ 1 - Effective communication skills course outline - Vision statements from fortune 500 companies - CCIS - Princ of Mngmnt Assignment 2 (twice) - Conveyor belt project report - Deliverable 4 - Visually Persuading Your Viewer - Optics letters page limit - This is what it means to say phoenix arizona theme - Earth day powerpoint template - Nimbus inc makes brooms and sells them - Overlord apartments seneca falls ny - Maryland board of cosmetology - Legislation that has occurred as a result of Nurse advocacy - Protons neutrons and electrons practice - Accounting rate of return calculator - Reindeer and human population lab answer key - Tenable sc system requirements - Wdia bobby o jay eye candy - Dog training waiver form - H2t pumpkin peel 30 instructions - Discussion 3 - When brothers share a wife reaction paper - Bonsoir ca va translate - Which communication method would score highest in channel richness - What does lord of the flies symbolize - Little giant pump model pmo 650 - Help - Milton model analogical marking example - Express the force f in cartesian vector form if it acts at the midpoint b of the rod. - Airasia menu pdf - Ode to tomatoes pablo neruda analysis - Are subheadings bolded in apa - Horton ramsay treatment centre - Teaching plan Sickle cell anemia 10 year old - Organ leader and decision making - Five importance of home economics to individual - Ethical dilemma powerpoint - Mitigating Risks - Clayton industries case study - Aimé césaire une tempête pdf - Solid mensuration formulas pdf - Vce psychology study design 2020 - Lab alkanes and alkenes datasheet answers - Identify two cultures and analyze the nurturing process within each culture - Unc student stores textbook lookup - Character description year 1 - SEX TRAFFICKING - Secret life of walter mitty quotes - Summarize alfred lord tennyson's poem in memoriam ahh 54 - Sonance outdoor speaker removal - Fin 370 week 1 - How does wind affect the flight of a baseball - Dissociative Identity Disorder and PTSD - 16 thurbro drive keysborough - An astrologer's day story in english - Nfpa 70e training powerpoint - Anti discriminatory practice social work examples - Project - Discussion 1 (Business Ethics) - Essay on nasa in english - Shady glade word ladder answers - Culture and norms - Experimental determination of absolute zero - Pilmer v duke group ltd summary