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 ch 1 independent project 1 5

06/12/2021 Client: muhammad11 Deadline: 2 Day

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:

Top Grade Tutor
Buy Coursework Help
Supreme Essay Writer
Quick Mentor
Academic Master
Quick Finance Master
Writer Writer Name Offer Chat
Top Grade Tutor

ONLINE

Top Grade Tutor

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$49 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$28 Chat With Writer
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$32 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$34 Chat With Writer
Academic Master

ONLINE

Academic Master

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

$16 Chat With Writer
Quick Finance Master

ONLINE

Quick Finance Master

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

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

Given the rich and diverse skills and mindset of an ethical hacker (technical, administrative, and physical measures), which characteristics do you believe to be the most important in this role? Please explain your choice. - Bennigan's danny boy chicken nutrition - Analyzing A written rhetorical - 145 laurel ave chelmer - Impact of event scale - Contemporary hero's quest presentation hum 105 - Ielts ngoc bach speaking - Feast watson wood stain colour chart - Klu klux klan burning cross - 7 m mastery problem accounting answers - Lower back pain soap note example - Critical evaluation essay thesis statement and outline - Emerging Threats and Counter Measures on Cyber Security - Throughout this course, you have kept journal entries each week - Global Citizen Journal - An assignment - Morrisons swan valley 3 address - Accounts that would appear on a balance sheet - Coconut water marketing plan - Hot plate definition chemistry - Short essay - Cpa score release countdown 2018 - Optimal olefins m sdn bhd - Business - List of middle range nursing theories - What approaches could have yielded additional valuable information - The news apply to the product desgin process and development tradeoff - Cpt reflection 08/14 - Pharmacology final exam nursing - What mineral helps keep blood vessels unblocked - How to identify the reducing and oxidizing agent - Asean strategic action plan for sme development 2016 2025 - Ming wong chinese sunniside - Geography is destiny quote jack ryan - Law 8 dis - Jo koy mexican falling off cliff - Should doctors tell the truth collins - Week 13 - Celf 5 screener subtest descriptions - Apollo shoes audit case - ORGANIC CHEMISTRY LAB REPORT : RECRYSTALIZING IMPURE SOLIDS: MINISCALE PROCEDURES - Module 2 wellness plan flvs answers - The castle farouk quotes - New depth and complexity icons printable - Sap gui system requirements - Case Study - Draw the conjugate base for each of the following acids - Specific heat and heat capacity worksheet answers - Is a tattered flag tattoo disrespectful - Cuo + h2so4 net ionic equation - Thinking through the past volume 1 chapter summary - 4 phases of adlerian therapy - Option #2: Reflections on Resolving Work Conflict - The most handsomest drowned man in the world - Power transformer oil specification - Pertaining to our erp lecture the acronym cow stands for - Vroom leadership theory - Giving of notice identifier ppsr - Anatomy of wrist - Social harmony english language - Double rocker mechanism application - Hua xia chinese culture school - Chemistry of benzene electrophilic aromatic substitution - 7 how do heavy sediment deposits affect waterways - Church view surgery collingham - The form of the chant alleluia vidimus stellam is - R7 - Right carotid endarterectomy and patch angioplasty icd 10 pcs - Which line from the text states the main cause for roosevelt's speech? - World Civilization before 1650. wk 4 - 1/34 royal avenue essendon north - 4908 interboro ave pittsburgh pa 15207 - Questions to ask about pop art - Mildura senior college employment - Components of good health - A musician plans to perform 5 selections for a concert - Essay on do androids dream of electric sheep - American eagle public relations - Food ordering system data flow diagram - Paper certificate of title victoria - Traction definition drivers ed - Community Teaching Plan: Teaching Experience Paper - Hp authorized repair centre - Cultural identifiers - SWOT ANALYSIS - It service desk university birmingham - Isbn 978 0 13 214911 2 - 1000 meters is how many kilometers - Cerakote 4 oz coverage - 2009 methods exam 2 - An electronic component for a medical x ray - Introduction to java programming and data structures comprehensive version pdf - The financial staff of cairn communications has identified - Design of a kinematic device using fusion 360 - Self help schemes in rio - Jesus bead bracelet meaning - Business - Accurate 2520 load data - Www ewre com au hobart - Dope zebra piano sheet music