Define Database Relationships
Referential Integrity Access
Cascade Update Delete
Working With Web
Using hyperlinks Forms
Data Access Pages
Data Access Types
Create Grouping Style Page
Working With Web Conclusion
Microsoft Access Security
Working With Startup Dialog
Access Add In
Encrypting, Decrypting Database
Understanding Access Replication
Replicating Access Databases
Convert Microsoft Access
Access Tools Conclusion
Using Access Macros
Create Access Macro
Running Queries Macros
Available Access Macros
Creating Many to Many Relationships in Access - Exercise
Course Project: Creating many-to-many relationships
Practice creating many-to-many relationships.
You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, enter your response into the textbox below and click the
button to receive full credit.
Background and Overview
Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. You need to make sure that there has been the correct relationship created among the tables Clients, Projects, and Hours for one of your major clients.
As we stated in the first module, the Consulting407.mdb database is available as a compressed download file available on the Resources page. If you have already downloaded the database, continue to work in that version.
Open up the Edit Relationships dialog.
Add the one-to-many relationships between Clients and Projects, and Project and Hours, to make up a many-to-many relationship among the three tables.
If relationships exist and you want to recreate them, click the join line between the tables, then click Delete.