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

Using microsoft access 2016 independent project 1 5

15/10/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:

Smart Tutor
Ideas & Innovations
WRITING LAND
Financial Analyst
Helping Engineer
Accounting & Finance Mentor
Writer Writer Name Offer Chat
Smart Tutor

ONLINE

Smart Tutor

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$38 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

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

$26 Chat With Writer
WRITING LAND

ONLINE

WRITING LAND

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$34 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$42 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$40 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

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

1 paragraph 100 words Quote - Momentum energy smilepower flexi - Unholy trinity imf world bank wto - Agilent 5973 msd parts - Cisco packet tracer tutorial for beginners - Australian citizenship our common bond book order - Suzanne kelleher duckett - 4mat Review Mcminn - Needed in 4 hours - Assessing reliability of content analysis - Apollo shoes case study solution - 741 op amp circuits single supply - Chapter 7 deviance and social control test b answers - Medication Errors Led to Disastrous Outcomes - Reflective essay on business plan - Sale of common stock to investors account classification - Cisrs scaffolding labourer card - Porters five forces groupon - Discussion Question - Download adobe dynamic stamps - Case study on moral status - IT - Combined gas law problems worksheet - Swain v waverley municipal council - Bus from adelaide to mount gambier - Business Communication - Cjt202 assignment - Dynamics crm implementation plan - Selland pontiac gmc inc v king - Mathmatics computing - 1000 working credit centrelink - Nec graded project - How immigrants become other marcelo m suarez - Sdsu plagiarism quiz - 3sin 2x cos 2x 0 - Introduction to networks version 5.0 - Epq toolkit for aqa pdf - Gram staining microbiology lab report - Ap60 cruise control review - Kids day easter show - Simplex company has the following estimated costs for next year - Discussion - CASE STUDY - Accounting Case - How to do hess's law calculations - A horseman in the sky conflict - Article Analysis,please add references and follow the template that I uploaded by 10/21/2020 at 4: 00 pm - La momia desaparece in english - American shifter company instructions - Wk8 DQ1 Discussion Question 1 - CLO 4 - Prepare a business case for the global treps project - Indentity vs role confusion - Yamaha dirt bike history - (nosotros) (escribir) muchas composiciones en la clase de literatura. - Unfilled part of a wine cask crossword - Leab champ battery charger - The expected value for a binomial probability distribution is - British association of play therapists - Worksheet on percentage increase and decrease - Assignment - Frosti lodge baw baw - Week two discussion - Help with assignment - Wk 5, HCS 430: Law Requirements Worksheet - Delphi company has developed a new product - Sony inbound logistics - Cash book in excel - Millward brown digital google vehicle shopper path to purchase study - Consumer perception towards maruti suzuki project - Lump sum cash flow timeline - Radioactive dating game worksheet answers - Ecotourism case study kenya - Why is there a pop sound when hydrogen is burnt - Management samson and daft 6th edition pdf - Bac evaporative condenser catalogue - Alternative procedures in the confirmation of accounts receivable - Ais prism firearms simulator - Can you complete my assignment for me? - Order of operations dice game pdf - Health sciences north departments - Order 2269736: Service to others and helping those in need are dominant themes in African American history. We are a people who have consistently reached back to help others. Discuss how this has been a catalyst in your pursuit of a college education. - 08 bac to mg ml - Louder with crowder wage gap - Stakeholder management - Chem 121 predicting products of chemical reactions - Australian safeway stores v zaluzna - A landscaper has 125 tiles - E700 sp dcl pipe - 5 Sentece thesis Statement - Corporate social responsibility - Succession management at general electric - Fritz redl classroom management - An outline of the law of partnership - Bloom and lahey chart - Strengths and weaknesses of ethical egoism - How many eggs do echidnas lay - What is presentation expert target - Construct an amortization schedule for a $1 000 - Siemens training and development case study - Macbeth bloody hands quote