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 2016 in practice ch 3 independent project 3 5

07/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:

Assignment Hub
Calculation Guru
A+GRADE HELPER
Fatimah Syeda
ECFX Market
Study Master
Writer Writer Name Offer Chat
Assignment Hub

ONLINE

Assignment Hub

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

$30 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$41 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

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.

$40 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$25 Chat With Writer
ECFX Market

ONLINE

ECFX Market

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

$43 Chat With Writer
Study Master

ONLINE

Study Master

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

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

Westminster city council housing - 1014(1) - How to get to the alfred hospital by public transport - Sea ray v drive - Questions - Of mice and men narrator - Paper essay - Fat city how hard can this be - Examples of ads with weasel words - Supply chain network design decisions - Moda light las vegas - Nervous system word search printable - Where was i answers brian smith - An automobile manufacturer is conducting a product recall - A spiral staircase winds up to the top - Describe three of the cobit p09 control objectives - Organic vs inorganic biology - How many syllables in snail - Husband wife LOVe problem +91-9829644411 solution .molvi ji - What is the hpy on your investment - Discussion Board due Friday 10.31.2020 at 3PM EST - Cantilever snap fit design - Difference between primary audience and secondary audience - Archetypes in modern works worksheet answers - Linguistic Assignment - Biotic factors of an ecosystem - Barriers in career planning process - Types of research design exploratory descriptive causal - Life after life jill mccorkle summary - The adjusting entry required to record accrued expenses includes - Tanto - Bmw mini big decisions under the brexit cloud case study - Schuster institute for investigative journalism - Benzene burns in oxygen according to the following reaction - Global ethic vs national interest - Time warner inc investor relations - Doritos illuminati - Cultural variations in attachment - 1/258 quarry road ryde - Smith chart normalized impedance - Social Work Assignment: Project: Agency Visit Paper - Inspector de aduanas ¿tiene usted (1) que declarar? - (DQ) Biz News - Place! - Data analytics problem statement - North norfolk coastal fitness - Nice n easy commercial - The comparative balance sheet of yellow dog enterprises inc - Remington 1187 action spring removal - A net of a rectangular pyramid - Mardi received an inheritance of 40000 - Charlemagne had the most profound influence on which continent - Project data sheet template - 7 - Managerical accounting - Outpatient surgery encounters are coded as - Directional strategy - Price discrimination is indistinguishable from dumping - CASES CASE 35 CIRQUE DU SOLEIL* The founder of Cirque du Soleil, Guy Laliberté, after see- ing the firm’s growth prospects wane in recent years, was thinking about expanding his firm in new directions. For three decades, the firm had reinvented and revolutionized the circus. From its beginning in 1984, Cirque de Soleil had thrilled over 150 million spectators with a novel show concept that was as original as it was nontraditional: an astonishing theatrical blend of circus acts and street enter- tainment, wrapped up in spectacular costumes and fairy- land sets and staged to spellbinding music and magical lighting. Cirque du Soleil’s business triumphs mirrored its high- flying aerial stunts, and it became a case study for business school journal articles on carving out unique markets. But following a recent bleak outlook report from a consultant, a spate of poorly received shows over the last few years, and a decline in profits, executives at Cirque said they were now restructuring a - Example of a research critique apa format - Godrej chotukool a cooling solution for mass markets case analysis - Need help with attached. - Production process analysis ppt - Essays - Is business bluffing ethical pdf - What happened to vilimas and nikalojus lukoszaite - Celsius and fahrenheit graph - Draw both enolates formed when the ketone - Bricklaying method statement free download - Which of the following statements best describes scientific research - Excel chapter 1 grader project travel expenses - Adamant beetle persona 4 - Romeo and juliet timeline - 6.2 Reading Reflection Discussion - Accounting discussion - History 2A - Checking out me history copy of poem - Order 2189405: Social media use and its relationship with collaborative learning and students motivation IN ABUDHABI SCHOOLS, - 61mm top hat battens - Dandenong ranges walking tracks - Sjsu graduate acceptance rate - I don t wanna lose you jamestown story chords - Is longchamp a luxury brand - Fire and ice robert frost analysis - Recruitment request form doc - Love letters electric maker - Example of scope in research paper - The dynaco manufacturing company produces - Classification of amino acids ppt - Culture in international business - Greek theater evolved out of - Reflective journal on classroom management - Samsung service request status - Part part whole examples - Less than macbeth and greater - Cardiology doncaster royal infirmary - List the trip ids and trip names for each pair of trips that have the same start location - How does catme work - The crane wife by cj - 4 asset portfolio standard deviation calculator - Managed Care