Advanced Microsoft Access

Duration: 2 Days

Objectives

This course is designed for existing users of Microsoft Access. By the end of the course, delegates will be able to: create tables, enter and change data; sort, and query data using criteria; create basic forms and reports; review and print data from queries, forms and reports.

Pre-requisites

Previous attendance on the Introduction to Access 2007 course, or equivalent knowledge acquired through experience.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Database design

  • Recap on relationships between tables
  • Data integrity issues

Tables

  • Field properties
  • Data validation
  • Input masks
  • Importing text files

Understanding and using Queries

  • Action queries
  • Update queries
  • Deleting queries
  • Appending queries
  • Mark table queries
  • Cross tab queries
  • Parameter queries

Forms

  • Form properties
  • Advanced properties
  • Control properties
  • Search combo boxes
  • Navigation buttons
  • Sub forms
  • Referring to controls on sub forms

Reports

  • Page breaks
  • Customised grouping and sorting
  • Keeping data together
  • “Can shrink” properties
  • “Can expand” properties
  • Sub reports
  • Referring to controls on sub reports

Macros

  • Actions and arguments
  • Macro names
  • Macro conditions
  • Assigning Macros to buttons
  • Assigning Macros to events

Modules

  • Introduction to functions and procedures
  • Viewing and editing VBA code

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now

Related Courses


"I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database and have managed to get my invoicing layouts to work perfectly. Thank you very much! I've also been able to use some of the other things you showed me to good effect too so the course has already helped enormously. Just thought you should know :-)"

Julian Support

"Fantastic! Everything was explained very clearly."

Sothebys

"The course was well structured, clear and in a comfortable setting. The tutoring was exceptional."

Dot2Dot



© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260