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

25/12/2020 Client: saad24vbs Deadline: 7 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


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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 Essay Tutor
Homework Guru
University Coursework Help
Helping Hand
Best Coursework Help
Calculation Guru
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$105 Chat With Writer
Homework Guru

ONLINE

Homework Guru

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

$102 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$102 Chat With Writer
Helping Hand

ONLINE

Helping Hand

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.

$100 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

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.

$100 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

I see that your standard of work is to get content for articles. Well, you are in the right place because I am a professional content writer holding a PhD. in English, as well as having immense experience in writing articles for a vast variety of niches and category such as newest trends, health issues, entertainment, technology, etc and I will make sure your article has all the key pointers and relevant information, Pros, Cons and basically all the information that a perfect article needs with good research. Your article is guaranteed to be appealing, attractive, engaging, original and passed through Copyscape for the audience so once they start reading they keep asking for more and stay interested.

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

Buffalo wild wings strengths and weaknesses - David jone american express login - How to increase your writing speed during exams - Tewkesbury c of e - Temple university writing center - Summary of this blessed house - Magic of science essay in english - Rsa securid self service portal - Essay - Example of ground state - PMO Assessment for Advancement Essay - Projection Management - 5 Pages - No Extension - Dinner plain resort entry - Mcgraw hill connect sociology test answers - 3d systems corporation investor relations - Banning cellphones in school statistics - No nonsense extra class study guide - Application specific integrated circuit - 2x 100 WORD POSITIVE FEEDBACK RESPONSE DUE 10/24 - Floating aimlessly crossword clue - Commercial cookery course in perth - Bus1 - Intercept vor radial g1000 - Sample nursing family case study - Rosemount 644 ordering information - Social psychology by elliot aronson pdf - Griffin v gipson case brief - HR - How fast is the pacific plate moving - Non linear models in r - They say i say chapter 4 - C06 Week 3 Threaded Discussion - Phantom profit - Gre practice test with answers - 3 short essays - AirBnB Case Study Outline - Biotic factors in the desert - Sample persuasive speech on donating blood - Chlorsig eye ointment side effects - Viscosity of water in kg - Stepwise approach to asthma treatment - Blanka dobrynin - Oracle purchase of sun microsystems - 1938 dymaxion car for sale - Different types of sensors used in robots ppt - Assignment 8/6 - MBA work 8 - Annie proulx 55 miles to the gas pump - Watch a video - Epidemiology SLP 4 - Garvin enterprises bonds currently sell - Me talk pretty one day - Meritor wabco spn 1070 fmi 10 - Discussion 2 Info Tech in a global economy. - Mgmt - 700 Wk 1 DQ 2# - The lancaster corporation's income statement - Internal and external business environment - Fat leo restaurant brighton - 10 facts about the dewey decimal system - Venturi meter lab report conclusion - Why you should eat breakfast persuasive speech - Qualitative research study - Provide a 50-75 word discussion reply to the following post below. - Amazon positioning statement - Performance Management - Discussion - Safety commitment statement examples - Global studies - Political Processes - Organisational Behaviour - Jones electrical distribution solution - How to fill out a jsa sample - Annotated Bibliography - Child discipline methods - Continuous problem city of monroe - Retrenching to a narrower diversification base - Developmental Theory vs. Critical Criminology - Lincoln hall university of nottingham - Breakup//****//**91 9799046502 Girl & BoY love problem solution specialist molvi ji - Resene concrete seal 3 in 1 - ANY TYPE OF WRITTEN WORK - Compare Unions In Public Versus Private Organizations - Monopoly java - Dsa in network security - Dni worldwide threat assessment 2018 - What are two equivalent fractions for 3 8 - Bbc documentary overpopulated - Research paper - Langston hughes cafe 3 am - Aldridge & district dog training club - Profitable mobile catering by bob fox - 4 d's of mental disorder - Components of skill fitness - Organized crime abadinsky 11th edition - Final Project - Origin of life ppt - Precis writing and comprehension - Wk kellogg foundation evaluation handbook - Gender - Cheynes beach caravan park map - Passage analysis to kill a mockingbird