Intermediate

Microsoft Access 2003/2007/2010

Intermediate Level

The course is designed for delegates who have attended the introductory course, or who have a sound working knowledge of Access, and relational database management.  By the end of the training session, delegates will have a comprehensive working knowledge of Access, where they will be able to produce efficient, well designed, automated applications.

Pre-Requisite:  Delegates attending this course should be already working with an Access database and wish to expand their knowledge, or should be converting from another computerised database management system.

This course does not cover programming in Microsoft Access.

Duration:           1 Day

Designing a Relational Database
  • Describe basic principles of relational database management systems
  • Split a database into relational tables using key fields
  • Understand the importance of referential integrity
  • Design a table for a relational database
  • Crosstab Queries
Creating Table Relationships
  • Create and edit table relationships
  • Arrange tables in the relationship window
  • Enforce referential integrity
  • Use the lookup wizard
  • Modify a lookup list
  • Display related records in a subdatasheet
Joining Tables with Queries
  • Create and modify a multi-table select query
  • Specify join properties for relationships
  • Understand the effect of join types in a query
  • Use self joins and cross joins
Enforcing Referential Integrity
  • Use the find unmatched and find duplicates query wizards
  • Set cascade update and cascade delete options
Summarising and Calculating Data
  • Create a query to summarise values
  • Add a calculated field to query output
  • Apply query properties
  • Add a calculated field to a form or report
  • Use the expression builder to create expressions
Creating a Summary Report
  • Create a summary report using the report wizard
  • Modify group properties
  • Add and remove group headers and footers
  • Modify group and detail section sort orders
  • Modify report section properties
Using Parameter and Crosstab Queries
  • Create a parameter query
  • Create a crosstab query
Designing Forms and Reports
  • Create a new form or report in design view
  • Understand the use of different sections
  • Display, hide and resize a section
  • Modify form/report, section and control properties
  • Add a bound control
  • Use the control wizard to add a control (list box)
  • Add a hyperlink control
Modifying Controls
  • Select a single control or multiple controls
  • Move, resize, align and distribute controls
  • Change the tab order of controls on a form
  • Identify and resolve errors
  • Modify control properties
  • Insert a graphic control
  • Set control defaults
  • Create a form / report template
Importing Data
  • Import data from different sources (text file)
  • Use drag and drop to copy and paste data
Exporting Data
  • Export a table or query to excel
  • Export data to word and complete a mail merge
  • Create a report snapshot
  • Save data in other file formats
  • Export data objects to a different database
  • Save a table, query or form as a web page
  • Export data to XML
Managing a Database File
  • Compact and repair a database
  • Apply password protection to a database file
  • Convert a database between different versions