Designing a database
- Identifying the tables
- What are relationships?
- Setting a primary key
- Using multivalue fields
Creating tables
- Defining fields
- The types of field
- Entering data
Different field types
- Creating attachments
- Rich text format fields
- Date fields (using calendars)
- Calculated fields
Importing data
- Importing from Excel
- Making tables from Excel
Table rules (*)
- Record-level validation
- Basic triggers
Drawing relationships
- Creating relationships
- Referential integrity
Creating queries
- The query design grid
- Sorting
- Setting criteria
- Combining criteria
Advanced queries
- Grouping and totalling
- Creating expressions
- Parameter queries
Joins
- Creating ad hoc joins
- Types of join
Crosstab queries (*)
- Columns, rows and values
- Overriding column headings
Action queries (*)
- Making tables
- Updating records
- Appending records
- Deleting records
Creating forms
- Layout and design view
- Using the form wizard
- Split forms
-Creating controls
Advanced controls (*)
- Webbrowser controls
- Navigation bars
- Multitabs
Creating reports
- Using the report wizard
- The group, sort and total pane
- Report design
Creating subforms
- Multiple item forms
- Creating subforms
- Tidying up subforms
Basic VBA coding
- Creating modules
- Using Project Explorer
- Writing comments
- Indenting code
Uses of VBA
- Form validation
- Criteria forms
- A simple menu system
Usually 9.30am - 4.30pm. Course times will be confirmed in the joining instructions once the course has been booked.