The advanced course focuses primarily on planning, designing and developing a database
Version 2007 and 2010
Duration
2 days (groups, 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
- What is the aim of the database?
- What must the database generate as output?
- What fields do I need?
- Which tables must I create from the fields?
- What data must be validated and which fields are you going to be compulsory to fill in. What other properties will be needed, e.g. formatting
- How will I input the information?
- How will I automate my database?
- Testing the Database
- Trust Centres
- Project
Module 2: Tables
- To create a table manually
- Using the Table Templates
- Primary Key
- Field Properties
- To set the field properties
- Breakdown of the Input Mask
- Symbols used for Input Mask Settings
- Validation Rules
- The Format Field Property
- Number Formats
- Examples of Custom Number Formats
- Text Formats
- Date Formats
- Validation of Data
- Default Value
- Lookup Property to insert a value from another Table
- To create a lookup table
- Limit the User to the Lookup List
Module 3: Relationships
- Normalisation
- Different types of Relationships
- One-to-many relationship
- Referential Integrity
- The Cascade Update Related Fields Option
- The Cascade Delete Related Records Option
- A one-to-one relationship
- Relationships between tables
- 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
- Using the Expression Builder to enter a formula for a calculated field in a Query
- Setting Formats for a field in a Query
- Action Queries
- Crosstab Queries
- Find Unmatched Query
Module 5: Forms
- To change the design of a form
- To select the Entire Form to set properties
- Activate the Properties dialogue box to change properties for a form:
- Change Font size, background colours and line colours
- Tips and Tricks when designing a Form
- To insert fields not displayed on a form
- Disable Fields on a Form
- To hide a Field on a Form
- Tab Indexes on a Form
- Using Controls in Forms
- Adding controls to a form that perform tasks
- Calculations on a Form
- Sort a Combo Box on a form to display information alphabetically
- Using the Expression builder
- Create a combo box that will find a specific record on a form
- Change a Search Combo Box on a form to always show the current record.
- Delete a Form
- Creating Forms with Sub Forms
- To create a Main From with a Subform
- The Switchboard
- Create and manage a switchboard form
- Create a Menu by using the Switchboard Manager
- Opening a Form in Edit Mode in the Switchboard Manager
- Opening a Form in Add Mode in the Switchboard Manager
- The Startup Menu Option
Module 6: Reports
- Designing reports
- Sort records in a report
- Using grouping in reports
- Group records in a report
- Create a report based on more than one table
- To create a report based on multiple tables
- Report Design without the Report Wizard
- Showing/Hiding Headers and Footers in a Report
- Resize Header or Footer areas
- The Report Grouping Window
- Section width greater than Page Width
- Grouping to display totals
- Saving A Form as A Report
- Creating a blank report to be printed and filled in manually
- Creating Mailing Labels
- Documenting the Design of a Database
- Using MS Word as a Publishing Tool
- Using MS Excel to Analyse Data
