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


"Our needs and expectations were surpassed."

FSL Aerospace

"Very clear instruction and presentation."

Hay Group

"The whole experience was great. Trainer and staff were extremely helpful and approachable."

Faithful & Gould



 

 

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