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

Simnet access independent project 1 5

04/01/2021 Client: saad24vbs 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:

University Coursework Help
Helping Hand
Top Essay Tutor
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

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

$112 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.

$110 Chat With Writer
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.

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

Gen 201 week 2 homework answer key - Rockin the blue jumpsuit jasper fl 32052 - Face to face sales script examples pdf - Rachel mcdowall street dance - When a merchandising company sells inventory it will - Differential wbc count tally grid - Http www learner org courses envsci interactives carbon - Debate the efficacies of public versus private based quality initiatives - Split half method of reliability testing - Module 04 Project – Ethical Considerations - Market Demand and Pro-forma Income Statement - The beauty myth quote - Legislative worksheet (sbar format) – how a bill becomes a law - A social change model of leadership development guidebook - In alphabetical order below are balance sheet items - Ap grading scale percentage - Baddeley and hitch 1974 citation - Azure cloud adoption framework ppt - Personal jurisdiction in cyberspace - Week 06: Money Markets - Home depot debt to equity ratio - Barriers to entering global markets for consumer services - Standardized Terminology and Language in Informatics (Nursing) - Functions of bursary department - Updated for week 7 and 8 - From novice to expert transitioning graduate nurses - Article notes - Chicago speakeasies in the 1920's - Paper - Is copper sulfate ionic or covalent - Strategic plan part 1 new product or service - Salts confidence be convex - St vincent's southside birthing center - Linux implementation proposal - What does the outsiders mean - Fruit fly genetics lab answers - Summary 350words (use simple words) - Convert ng/l to pmol/l - Need a discussion answer for 750 words with 2 responses 300 words each - Four potential roles of human resources representatives - A circuit contains two resistors and two capacitors - Auditing - Firestone w01 358 7001 - Discussion question - Tcs domino server name - Write an essay that defines the topic of your research for this course and synthesizes different perspectives on the issue from sources you have read critically. Mental illness in athletes or high school athletes. - How to do hess's law calculations - 100 hannah circuit manly west - Thorlabs lens cleaning tissue - Geology - Goal for university admission (essay type) - Philosophy 347-Critcal thinking reasoning - Generalized estimating equations interpretation spss - Wireshark filter probe request - Math - NURSING: EVIDENCED-BASED PRACTICE PROJECT - Queens own highlanders association - Rogerian speech example - Credit suisse holt lens - Civil war study guide answer key - Tay sachs disease results from the malfuncion of - MODULE 3 - CASE STUDY - International Accounting 2 Page Essay - Dr pepper snapple mission statement - Miles to kilometers conversions - Does uniqlo use child labour - North norfolk coastal fitness - Express your answer numerically as an integer - Osha form 300 excel - People or penguins the case for optimal pollution - Rite aid pharmacy mission statement - How do you find circumcenter - Managerial Accounting - Security architecture - Create a new product that will serve two business (organizational) markets 750-1000 word paper - School of golf chapter 18 - Spelling test for job interview - Find the line parallel to given equation - Ecgc premium rates country wise - Asco solenoid valve 8327 catalogue - Case study on planning in management with solution - How does gymnema tea change taste - Porters five forces groupon - Compsis at a crossroads case study - Ebonite optyx skull bowling ball - Order 2584122: Shaping School Culture - Experiment a5 evidence for chemical change answer key - Volleyball terminology for beginners - Information systems for business and beyond - Write a 350- to 525-word article about your evaluation and proposed changes to the facility or service that can help mitigate negative effects. - Key success factors in newshoes - Tales from dimwood forest - Tall ship productions pasadena - Key concepts of confucian ethics - I am the messenger discussion questions - Change assignment - International business competing in the global marketplace - Pandora jewelry competitive advantage - How are microorganisms destroyed by moist heat by dry heat - Tjx corporate social responsibility