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


"Extremely friendly and helpful. Excellent knowledge and presentation."

Just Digital

"I am writing to say thank you for organising my FileMaker training day; I learned so much with my trainer, Nick, and have come away with such a great database. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"

Lucie Mills

"Excellent. The best training I have ever had."

National Housing Federation



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team