Access Intermediate

This course will help delegates to build on their basic understanding of Microsoft Access, covering the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and reports.

Course Topics

Querying Information in a Database

Select, crosstab, parameter queries • specifying criteria • adding calculated fields • calculating totals in queries • make table query • delete/update/append query

Creating Multiple Table Queries

creating relationships • outer & inner joins • query properties

Creating Grouped Reports

sorting and grouping data • creating/modifying a grouped report • group headers & footers • range and interval grouping • printing properties • calculating totals

Working with Sub-Reports

combining two or more reports • linking a main and subreport

Form Design

editing controls •calculated controls • properties of controls • sizing and aligning controls • setting form properties

Customising Forms

adding combo and list boxes • options for displaying yes or no values • creating option groups • adding command buttons

Main and Sub-Forms

creating a menu & sub-form • linking the main & sub-form together

Creating Dialog Box Forms

creating a menu form • using a form as a dialog box

General Topics

compacting & repairing a database • creating an auto-lookup query

 

Follow on Courses

• Access Advanced