Home
Flowerdew


Courses
Accelerated courses
T.N.A. (Training Needs Analysis)
Bespoke


Contact us
About

Backback

Intermediate Microsoft Access

This is a one-day course for people who have an understanding of the topics listed in the Overview course and who wish to increase their productivity through the use of additional features. The course can be run using Access 2010, 2007, XP and 2000, and will be adapted to make the most of the features available in the software used.

Outline:

  • Review of database design concepts and referential integrity
  • Designing select queries
  • Calculations in queries
  • Parameter queries
  • Crosstab queries
  • Make table queries
  • Delete queries
  • Append queries
  • Enhanced report design
  • Enhanced form design
  • Using OLE fields
  • Graphics in forms and reports
  • Creating and using subforms
  • Exporting and importing data