1 / 6

Maximizing Lookup Tables in Access: Understanding Regions

Explore Northwind database tables and fields to determine possible values of 'Region.' Learn to manage regions and expand your lookup table efficiently. Discover the 'Limit to List' property.

mcbrider
Télécharger la présentation

Maximizing Lookup Tables in Access: Understanding Regions

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. Access Chapter 5-Lookup Table Exercise

  2. Creating a Lookup Table • Use Northwind.mdb file • Notice the ‘Region’ field • How many tables use it? • Customers • Employees • Orders (but named ‘Ship Region’) • Suppliers PgP MIS 342 Access- Lookup Tables

  3. Lookup Tables • How do you determine all possible values of the field ‘Region’ in all of these tables? PgP MIS 342 Access- Lookup Tables

  4. Lookup Tables • How do you determine all possible values of the field ‘Region’ in all of these tables? • Create a query, but what type…? PgP MIS 342 Access- Lookup Tables

  5. Lookup Tables • Once you know all current ‘region’ values, what else might you need to know? PgP MIS 342 Access- Lookup Tables

  6. Lookup Tables • Once you know all current ‘region’ values, what else might you need to know? • How about whether you will ever add more ‘regions’ to your tables/database? • Research ‘Limit to List’ property PgP MIS 342 Access- Lookup Tables

More Related