The intermediate course covers queries, forms and reports in particular.
Versions: 2003
Duration
1 day (minimum of 6 people)
Outcomes
To enable delegates to:
- Create queries
- Create forms
- Create reports
Unit Standards
There are no unit standards set for this course.
Prerequisites
Delegates should be familiar with those topics covered in the Beginners Level.
Course content
Module 1: Introduction
- Revision on table properties
- Compacting a database
- Making a backup of a database
Module 2: Queries
- Creating a query with a sorting order
- Working with fields in the design grid
- Adding a table in the query design
- Using or-and and based criteria in a query
- Using calculations in a query
- Using a concatenation operator in a query (combining two or more fields)
- Calculating totals in a query
- Creating a query from another query
- Creating a parameter query
Module 3: Forms
- Using the autoform
- Creating a form with the form wizard
- Different views for a form
Module 4: Reports
- Creating a report using the report wizard
- Customizing a report (introduction)
- Printing a report
