Send to Friend

Access Advanced

 
Aims:

Upon completion, delegates will be able to design a database and enhance functionality with advanced queries and macros.

Prerequisites:

Must have attended the Microsoft Access Introduction course, or have a good working knowledge of the product.

Duration:

Two Days

Fees:

Training course fees for this particular course will depend on your chosen Training solution. Please click on the links below for corresponding course fees:

PDF Course Download

Download PDFYou can download a PDF version of the course.

Download Access Advanced course outline.

If you don't have Adobe Acrobat Reader, this can be downloaded from the www.adobe.com web site.

If you are interested in our Access Advanced course call us on
0113 243 2226
Enquire about
this course Now

 

Course Dates

Available dates
15th - 16th September 2010
20th - 22nd October 2010
17th - 18th November 2010
14th - 15th December 2010
28th - 31st January 2011
17th - 18th February 2011

Advanced Queries

  • Self-joins
  • Inner and Outer joins
  • Parameter queries
  • Derived field queries
  • Calculated fields
  • Combining fields
  • AutoLookup queries
  • Advanced query wizards
  • Query-by-Form queries

Action queries

  • Update queries
  • Make table and Append queries
  • Delete queries

Advanced Form Design

  • Form controls
  • Combo- and list boxes
  • Tab controls
  • Main and subforms
  • AutoLookup forms
  • Non-table based forms
  • Multiple table forms
  • Advanced form properties

Database Tools

  • Table Analyser
  • Database Documentor
  • Performance Analyser

Importing and exporting data

  • Text files
  • Spreadsheet files
  • Attaching tables

Database Security

  • Encrypting and decrypting
  • Database file security
  • Object-level security

Compacting and repairing databases

Macros

  • Command buttons
  • Creating macros
  • General macro functions
  • Using macros
  • Creating filter buttons on forms
  • AutoExec macros
  • Creating Switchboards
  • Database start-up properties
  • Custom menus and toolbars
 

If you are interested in our Access Advanced course call us on
0113 243 2226
Enquire about
this course Now