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