By the end of the course you will be able to :

• Create relationships between different tables
• Use the range of advanced queries
• Work with Advanced Form and Report features

Relationships

• Rules of normalisation
• Introducing relating tables
• Referential integrity
• Cascade Update
• Cascade Delete
• Working with Subdatasheets

Working with related tables

• The lookup wizard
• Changing lookup fields
• Inputting data to related tables

Defining Data Entry Rules

• Using input masks and wizard
• Setting a property
• Setting a validation rule

Advanced Query Features

• How to join a table in queries
• Creating a calculated field
• Creating and using action query
• Summarise and group values
• Create a crosstab query
• Using a parameter query
• Using a Concatenation query

Creating Advanced Form Design

• Working with graphics
• Working with calculations
• Working with combo boxes
• Working with unbound controls

Using Advanced Report Features

• Create customized headers and footers
• Working with grouping options
• Add a calculated value
• Working with sub-reports
• The Keep Together property