Theoretical Database Fundamentals
- Database models
- Key principles of a database
- Conventional data processing and databases
Database Design
- Steps in designing a database
- Tables
- Primary and secondary keys
- Normalisation
- Determining the relationships between tables
Linking Tables
- Main and detail table
- Creating relationships between tables
- Editing relationships
- Deleting relationships
- Referential integrity
- Subdatasheets
Formulas and Functions
- Useful facts about formulas and functions
- Functions
Queries
- Queries across multiple tables
- Calculations in queries
- Field properties in queries
- Action queries
- Parameter query
- Queries with special joins
Queries with SQL
- Basic structure of the SELECT statement
- Creating a query with an SQL statement
- Components of the SELECT statement
- The JOIN operation
- Predicates
Further Query Applications
- Query for finding duplicates
- Displaying top and bottom values in queries
- Grouping queries with aggregate functions
Forms
- Creating a new form
- Record source
- Controls
- Inserting controls
- Changing the size and position of bound fields
- Inserting an object
- Lines and rectangles
- Alignment aids
- Properties
- Setting the field order
- Split form
- Subforms
Data Analysis
- Crosstab queries
- Creating PivotTables in Excel
Reports
- Creating a new report
- Report sections
- Record source
- Grouping a report
- Multi-column report
- Inserting data fields
- Report views
- Properties in reports
- Inserting calculated fields and functions
Automation with Macros
- Creating macros
- Adding custom menu commands (macros) to a tab
- Creating a default start form
- Activating the default start form
Data Exchange
- Import – structure of a database
- Export
- Linking
- Linked Table Manager
Data Protection and Data Security
- Data security
- Data protection
