The advanced course focuses primarily on planning, designing and developing a database
Version 2003
Duration
2 days (minimum of 6 people)
Outcomes
To enable delegates to:
- Plan and develop a database
- 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: Database design
- Automate a database
- The concept of testing
Module 2: Tables
- Primary key
- Field properties
- Input mask settings
- Validation rules
- Number, text and date formats
- Validation of data
- Default values
- To create a lookup table
- Limit the user to lookup list, edit a lookup list
Module 3: Relationships
- Normalisation
- Different types of relationships
- Master-child relationships
- Join properties
Module 4: Queries
- Types of queries
- Creating a query to search for a blank field
- Using the left, middle, right, str$ functions to create codes
- Specialised queries
- Creating a parameter query
- Using calculations in a query
- Action queries
- Crosstab queries
Module 5: Forms
- To change the design of a form
- Tips and tricks when designing a form
- To insert fields not displayed on a form
- Disable, lock fields on a form
- To hide a field on a form
- Tab indexes on a form
- Adding controls to a form
- Use a command button on a form
- Calculations in a form
- Creating forms with subforms
- Menus
- Opening a form in add/edit mode
- The startup menu option
Module 6: Reports
- Sort records in a report
- Using grouping in reports
- Saving a form as a report
- Creating mailing labels
- Documenting the design of a database
- Using Ms Word as a publishing tool
- Using Ms Excel to analyse data
