1 / 7

MS Access: Working with Related Tables

MS Access: Working with Related Tables. Instructor: Vicki Weidler Assistant: Joaquin Obieta. Overview. Create Lookup lists using the Lookup Wizard & Design View Modify Lookup field properties Learn how to change control types Add data to related tables utilizing a subdatasheet.

veliam
Download Presentation

MS Access: Working with Related Tables

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MS Access: Working with Related Tables Instructor: Vicki Weidler Assistant: Joaquin Obieta

  2. Overview • Create Lookup lists using the Lookup Wizard & Design View • Modify Lookup field properties • Learn how to change control types • Add data to related tables utilizing a subdatasheet

  3. Lookup Wizard The Lookup Wizard creates a field in one table that gets data from a field in another table. This is called a Lookup list field. The Lookup field uses the primary key from the related table to ensure referential integrity.

  4. Table Control Types Text Box used to enter data in a table; cell Combo Box drop-down list of values; you can either select a value from the list or enter a value not on the list List Box drop-down list of values; unlike the combo box, you can only select a value from the list, you cannot enter a value that is not on the list

  5. Adding Data to Related Tables Subdatasheet • Set of records extracted from a table based on a record in another table • Use to view and enter data in related tables

  6. Summary • Create Lookup lists using the Lookup Wizard & Design View • Modify Lookup field properties • Learn how to change control types • Add data to related tables utilizing a subdatasheet

  7. Conclusion • Resources • Questions & Answers • Evaluations • Thank You!!!

More Related