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


"Very enjoyable, well-paced tuition, tailored and relevant to my workplace demands."

RAF

"Really impressed! I enjoyed the training and would like to do more in the future."

Silk Pearce

"Trainer's knowledge was immense, clearly an experienced practitioner."

Joseph Chamberlain College



 

 

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