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

How to open the relationships window in access

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

Access 2013 Chapter 2 Using Design View, Data Validation, and Relationships Last Updated: 2/27/15 Page 1

USING MICROSOFT ACCESS 2013 Improve It Project 2-7

Improve It Project 2-7 Placer Hills Real Estate wants to expand the database created in the Improve It Project 1-7 in Chapter 1. To ensure consistency, the starting file is provided for you. In this project, you use Design view to edit properties in a table and integrate data integrity rules. You edit data records, create a relationship between the two tables, and enforce referential integrity constraints. Finally you view how the table records will print using Print Preview.

Skills Covered in This Project  Edit a table using Design view.

 Edit field properties in Design view.

 Create an input mask.

 Save a table.

 Create a foreign key.

 Create a 1:M relationship between tables.

 Enforce referential integrity.

 View a table in Datasheet view and expand related records.

 Preview table results for printing.

1. Open the PlacerHills-02.accdb database 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, and save it.

3. Enable the contents in the security warning.

4. Open the Agents table in Datasheet view (Figure 2-96).

2-96 Datasheet view of the Agents table

a. Look at the DateHired and Phone fields. The manager of the real estate office wants those to be

formatted differently.

b. Notice that both Jack Johnstone and Kallyn Duarte have the same value in the EmployeeNum

field. If the employee number is supposed to be unique, something must not be set correctly with

the primary key in this table.

c. Change Kallyn Duarte’s EmployeeNum to be 168, the correct value.

5. Change to Design view to make needed corrections to the Agents table.

a. Notice that the table does not have a primary key. Although Access recommends that you assign

a primary key in a table, Access lets you create a table without one.

b. Set the EmployeeNum as the primary key.

c. Set the Format property of the DateHired field to use Short Date.

d. Create an input mask for the Phone field. Select the Phone Number Input Mask. Don’t make any

changes to the mask or placeholder character and select the radio button for Without the

symbols in the mask, like this. Complete the Input Mask Wizard.

e. Make all fields Required.

f. Save the table.

g. Switch to Datasheet view to ensure that the formatting shows as desired.

Step 1

Download start file

Access 2013 Chapter 2 Using Design View, Data Validation, and Relationships Last Updated: 2/27/15 Page 2

USING MICROSOFT ACCESS 2013 Improve It Project 2-7

h. Adjust the field width of the DateHired field to 13. Remember that you can select the column,

right-click to open the context menu, and then select the Field Width button to change the width

to a specific size.

i. Adjust the field width of the Phone field to 16.

j. Save and close the Agents table.

6. Determine the type of relationship and the foreign key field.

a. There is a one-to-many relationship between the two tables since an agent can list many different

real estate properties, but a property is listed by only one agent.

b. 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. In this case, the EmployeeNum should also be added into the

Listings table.

c. Open the Listings table in Datasheet view. Notice that this table has a field that stores the agent’s

name. However, it doesn’t have the foreign key. To minimize redundant data, you will change the

Agent field so that it will now store the agent’s employee number instead of the agent’s name.

This requires changing the data values as well as field properties.

7. Edit the data values in the Agent field in the Listings table.

a. Click the arrow to the right of the Agent Field Name and select Sort A to Z. Because the employee

name values begin with the first name, the sort isn’t alphabetical by last name. However, the sort

makes it easier to change the data values since all the properties by the same agent are

grouped together.

b. Change each of the six records for Jack Johnstone to have the value of 160 for the Agent field.

After entering the first value, you can use copy and paste to enter the remaining values.

c. Continue changing the remaining records using the information in the following table.

d. Remove the sort from the Agent field.

e. Save the table.

8. Switch to Design view in the Listings table to edit the properties of the foreign key.

a. Click in the ListingAgent Field Name property box.

b. Change the field name to ListingAgentNumber.

c. Change the Description to read Must match an EmployeeNum in the Agents table.

d. Change the field size to 3.

e. Save and close the table. Access warns you that the field size has been changed and that you

may lose data. Your values meet this new size. Click Yes.

Access 2013 Chapter 2 Using Design View, Data Validation, and Relationships Last Updated: 2/27/15 Page 3

USING MICROSOFT ACCESS 2013 Improve It Project 2-7

9. Create a one-to-many relationship between the

Agents table and the Listings table.

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 EmployeeNum field from the Agents

table on top of the ListingAgentNumber field in

the Listings table as shown in Figure 2-97.

d. Make the correct choices to Enforce

Referential Integrity and Cascade Update

Related Fields.

e. Leave the Cascade Delete Related Records

check box not selected. You do not want to

delete property records just because an agent

may leave the company. This allows you to

keep a record of the listings.

f. Create the relationship.

g. Save the changes and close the Relationships window.

10. Open the Agents table in Datasheet view.

a. Click to expand the records for Kelly Weatherby. There should be eight properties listed.

b. Close the Agents table.

11. Preview the data records in the Listings table for printing.

a. Select the Listings table in the Navigation pane.

b. Use Print Preview to show a preview of how the table will print.

c. Change the page to Landscape orientation.

d. Close the Print Preview.

12. Close the database.

13. Upload and save your file.

14. 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:

A+GRADE HELPER
Study Master
Fatimah Syeda
Engineering Help
Peter O.
Top Class Results
Writer Writer Name Offer Chat
A+GRADE HELPER

ONLINE

A+GRADE HELPER

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

$21 Chat With Writer
Study Master

ONLINE

Study Master

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$49 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

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.

$44 Chat With Writer
Engineering Help

ONLINE

Engineering Help

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.

$22 Chat With Writer
Peter O.

ONLINE

Peter O.

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$31 Chat With Writer
Top Class Results

ONLINE

Top Class Results

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

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

Unit 8 discussion 1 - Coca cola employee perq points - Palm beach state college physical therapy - Asc 350 40 pwc - Chase bank albertsons highland and airline - Homeland Security - Technological factors affecting starbucks - Getta byte software resource allocation - How far is venus from the sun - What is science very short answer - Nick gereffi cause of death - Baking soda to vinegar ratio - Stand and proclaim by benita washington lyrics - How far from earth is the moon in miles - 26/56 whistler street manly - Us history research paper topics - CS week 13 discussion - It's not luck chapter summary - 1 stadan place hillside - PHI-413-107200 Ethical and spiritual decision Marking - James truslow adams american dream essay - Book of genesis paintings - Https statistics laerd com spss tutorials - King duncan character traits - List of licensed employment agencies in hong kong - Largest private companies in atlanta - Cirque du soleil strategy - Phetics - Global supply chain management v2 simulation answers - Kenwood ts 850s 11 meter - Homework - Reference architecture of distributed database - Characteristics of beowulf with quotes - The following information is available for aikman company - Assignment: Performance Appraisal Applications and Implementation (5pages) - Pyramid tv iptv login - Mapping innovation roles project - John maxwell 5 levels of leadership summary - Stefan ceramics is in the business of selling - Ansoff matrix reference harvard - Emerson network power surge protection - Cp 1 cp tester course manual - Muscle Contract - Working with children check qld - Harlequin enterprises the mira decision case study - Advertising experiments at restaurantgrades - Dunkin donuts duties and responsibilities - Which of the following best describes performance based logistics contracts - How many islands are in the philippines - Total Rewards Knowledge 9: Engaging Employees - English studies on the road - Wk 6 - Issues in Consumer Protection and Potential Ethical Issues in Marketing Strategies - The fifth discipline discussion questions - Pico questions for stroke patients - Discussion questions for behold the dreamers - Oregon earthquake hazard map - Sea shepherd volunteer experiences - Hp printer deskjet 2540 all in one series - 9780078024795 pdf - Grandstand occupants crossword clue - Journal 2 - War on people with low average intelligence - What energy system does a 100m sprinter use - Fremont high school norton reader - Report t test apa - Chapter 3 business law and ethics part 1 content review - MGT312T Week. 2 Apply Self-Assessment Reflection - Mole valley bin collection - Unit 2 working in the science industry - Color blind powerpoint slides - Ethical health promotion paper - How to start boeing 737 - Summery 2 - Week 3 MF - PRINCIPLES OF INDUSTRIAL AND ORGANIZATIONAL PSYCHOLOGY - Welch allyn ecg se pro 600 - A stateful inspection firewall ________ - 2.2 Evaluation of Conflict Assessment Instrument - Why do oligopolies exist - Math - Mona lisa smile college - Elearning kbs - Liu zhang operates lawson consulting - Aerodynamics for naval aviators pdf - Ferranti packard flip dot display - Senior lawyer interview questions - Roseman university school of pharmacy - Chapter 4 personal and professional qualities of a healthcare worker - The negro digs up his past - 3 3 dimethyl 2 butanone nmr - What is the divinity and humanity of jesus christ - The bluest eye ending - End of day checklist - The artificial silk girl sparknotes - Download webgoat for kali linux - Rd gateway ssl bridging - Global Healthcare Comparison Matrix and Narrative Statement * Need in 5 hours* - Sea cadet dress regulations - Security - Social Work Discussion 5: Cultural Competence