60 likes | 65 Views
Access. Chapter 5-Lookup Table Exercise. 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. Lookup Tables.
E N D
Access Chapter 5-Lookup Table Exercise
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
Lookup Tables • How do you determine all possible values of the field ‘Region’ in all of these tables? PgP MIS 342 Access- Lookup Tables
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
Lookup Tables • Once you know all current ‘region’ values, what else might you need to know? PgP MIS 342 Access- Lookup Tables
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