Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 More Now Playing The Opening Scene Click Here to Get Started Samples Beginning Access Lesson Objectives: Learn how to use and design Access Tables. This lesson will show how to navigate among records, create tables in Design Vew and define appropriate table field types. In this lesson you will: Investigate the Data Tables Page 5 Use the Home Ribbon to Find a Record Page 10 Practice how to Filter the Data Page 12 Investigate the Data Types in Design View Page 13 Identify Required Fields Page 17 Define the Primary Key Page 19 Learn how to modify Field Values Page 22 Practice creating Input Masks Page 23 Use the Field Properties to create Multi-Value Lists Page 27 Use Data Validation to improve data entry Page 28 Learn how to Normalize a Database Page 31 Practice how to create a table from a template Page 42
Click Here to Get Started
Samples
Beginning Access
Lesson Objectives: Learn how to use and design Access Tables. This lesson will show how to navigate among records, create tables in Design Vew and define appropriate table field types. In this lesson you will:
Investigate the Data Tables Page 5
Use the Home Ribbon to Find a Record Page 10
Practice how to Filter the Data Page 12
Investigate the Data Types in Design View Page 13
Identify Required Fields Page 17
Define the Primary Key Page 19
Learn how to modify Field Values Page 22
Practice creating Input Masks Page 23
Use the Field Properties to create Multi-Value Lists Page 27
Use Data Validation to improve data entry Page 28
Learn how to Normalize a Database Page 31
Practice how to create a table from a template Page 42