Introduction
Welcome 00m 45s
Using the exercise files 00m 35s
08m 20s
1. Database Design Concerns Understanding design concepts for setting up
large lists 05m 56s
Creating appropriate name, address, and time fields 02m 24s
14m 54s
2. Tables Using Excel tables for database data 03m 40s
Using the Ribbon Design tab to control table formatting 03m 53s
Expanding tables automatically and adding totals 04m 10s
Working with formulas in tables 03m 11s
18m 20s
3. Controlling the Creation of New Data Building and viewing data with
the Form tool 07m 21s
Restricting data entries with data validation 08m 42s
Using the data validation tools to check the validity of existing data
02m 17s
00m 33s
Conclusion Next steps 00m 33s
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=