The introductory day explained the concepts and allowed you to create a rudimentory database. But everything you’ve seen so far can be achieved using a spreadheet. Today, you will learn about relational concepts, which are what databases are all about.
- The Primary key
- Databases versus Spreadsheets
- Setting a relationship
- Using a Form to fill in related Tables
- Main and Subforms
- Producing a Report using Related tables
- Querying Related tables
- Parameter Queries
- Using Wildcards
- Performing Calculations in Queries
- Performing Calculations in Reports
- Command Buttons
- Looking at the Properties pane in more detail