This course is intended for users who have a good working knowledge of Access or who have attended the Introductory or Intermediate course. By the end of the course the delegate will feel confident to design and build relational databases that incorporate macro automation, manipulate data with advanced queries and produce advanced form and report design.
Course content is listed below, but can be customised to suit your requirements.
Delivered on site at your workplace. Public courses not available at this time.
• Multi-table forms
• The expression builder
• Switchboards
• Sub-reports
• Mailing labels
• Incorporating pictures
• Joining tables in a query
• Types of joins
• Calculating in queries
• Action queries
• Summarising data queries
• Cross tab queries
• Using parameters
• Import from Excel and Word
• Attach external data
• Using mail merge wizard
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use