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

Excel independent project 1 6

13/11/2021 Client: muhammad11 Deadline: 2 Day

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:

Homework Guru
Smart Homework Helper
Top Grade Essay
Finance Homework Help
Accounting & Finance Master
George M.
Writer Writer Name Offer Chat
Homework Guru

ONLINE

Homework Guru

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$48 Chat With Writer
Smart Homework Helper

ONLINE

Smart Homework Helper

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$25 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$41 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$29 Chat With Writer
Accounting & Finance Master

ONLINE

Accounting & Finance Master

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$45 Chat With Writer
George M.

ONLINE

George M.

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$44 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

Nobunaga's ambition sphere of influence growth type - Governments often intervene in international trade and impose quotas to - +971561686603 Abortion pills in Dubai/Abu Dhabi-mifepristone & misoprostol in DUBAI - Daphnia heart rate lab answers - How to start a school captain speech - Business case versus business plan - Need help with answering a Business Law discussion question - Leadership Traits and Attributes - Comm 104 learning communities - Johnny partner aluminum expedition toilet - Excel chapter 9 grader project multiple sheet workbook management - Model railway computer control software - When is mid year exam - Cisco fmc virtual datasheet - John moores redmonds building - Joyce meyer healing prayers - 105 madsen street keperra - Cultivating customers the social way - Data is sent through the network in bundles called - Trireme labeled diagram - The venus of willendorf is a statue of - Refer to the following table for waxwania - Words that rhyme with wolfie - Dexter industries purchased packaging equipment - 10 22 cop code - Writing the equation of a rational function given its graph - Why study psychology worksheet answers - Toole - María sergio, ¿quieres hacer diligencias ahora o por la tarde? - It workshop lab manual - Sample apa position paper - Cak tanks fitting instructions - Prue acton billy snedden - Distinctive competencies of under armour - Frm coaching in chennai - Should a firm invest in projects with npv $0 - Mail hull ac uk - All of the following are characteristics of common stock except - Urdu marsiya ka irtiqa - Mario cantone liza minnelli impersonator - Attention catherine owen - Using Access Control Lists to Modify File System Permissions on Windows Systems - Scope of hotel management system project - Toll ipec road express - CCIS - Princ of Mngmnt - DROPBOX- (twice) - Information systems infrastructure evolution and trends - Sociology rodney stark 10th edition pdf - Schilders arm extension test - Which of the following is atypical of both physical stalkers and cyberstalkers? - DISC 3 Trans of N - Bd order of draw - Hotel rwanda film questions - Hdmi 2.1 cable jaycar - Expressed arguments in the media - What is the term for giving something human qualities - Youth soccer injuries have skyrocketed - What does the name christian mean - 68hc11 assembly language examples - Literature Review - Saint leo newport news campus - The pinewood furniture company produces - Submission Details: Please use PowerPoint for your presentation. Due in week thirteen. - High pitched blowing systolic murmur - How has the get tough movement influenced juvenile rights - Separation of mixtures lab chemistry - Tim hortons franchise fee - The rocking horse winner discussion questions - Essentials of business communication 11th edition chapter 1 - Name - Red willow buxton menu - Daniel bukvich symphony no 1 - How to find range of grouped data - As 1926.1-1993 free download - Weekly Journal week 37 - Focused exam cough danny rivera - Forum machine learning co ban - Accountant - The pearl john steinbeck sparknotes - Assignment 4 - Reaction journey men's hybrid bike - Diverger converger assimilator accommodator - Banana box corporation has sales of - Doing business with the japanese a guide to successful communication - What is the implication of moore's law for managers - Abiotic factors of amazon rainforest - Partnership for aflatoxin control in africa - Wjec level 3 criminology - Moreton bay map marine - Week5-Apply: Contingency Plan and Executive Presentation - Science vs religion in jekyll and hyde - Grammar translation method demonstration - Anxiety Assessment Tools - Conflict in rip van winkle - Rigging a block and tackle pulley system - Certificate iv in surveying - Top of the food chain by tc boyle summary - Identify a reform that took place during the Progressive era. This could include Constitutional amendments, movements among women or laborers, changes in technology, changes in family structure, and changes in laws. - Criminal justice motivational theories matrix - Imagine song lyrics meaning - How to protect your company from being salted by union