Database Technologies Level 2: Multi-table Access Databases, Advanced Queries, Forms and Reports
| DIT 15548 | 18 hours |
Programs
Objectives
- To demonstrate how to enhance database design, create more advanced tables and use forms and reports
Outcomes
- Creating and running multiple table queries using both inner and outer joins
- Creation of relations between tables and enforcing referential integrity in those relations
- Using advanced data bound controls on forms and reports
- Inserting graphics into forms and reports
- Inserting calculated fields into queries, and calculated controls onto forms and reports
- Insertion of 'lookups' into table field definitions
- Creating and inserting subforms into forms
- Setting up groupings into reports
- Creating parameter queries
- Using multiple And/Or criteria in queries
- Setting up aggregate (summary) functions
