Training Courses For Microsoft Access

Access training

Storing large amounts of data? Wondering how to find what you need, and get the data into a presentable format? We'll show you how to create, administer and extract data from Microsoft Access databases. Along the way you will learn how to optimise the databases you might already be using, protect them, get clearly presented output, and link the databases with other applications such as Excel and Word.

All Microsoft Access training courses are instructor-led at your site or scheduled (contact us for more information) and include PC Hire, course notes and exercises PLUS six months' post-course support. All courses can be customised to your needs at no extra cost.

For further information, choose a level:

Introductory course

De-mystify the database world in the comfort of your own work place! Learn terminology and how to create a functioning database to store your information. Create simple, clean data input screens and find and display information in attractive on-screen and printed formats. Prevent incorrect or invalid data from being input, and to ensure consistency of data.

Course contents

  • Creating a database
  • Understanding database terminology
  • Tables and properties
  • Importing data from Excel and other formats
  • Creating Forms to input and view data
  • Creating and running queries
  • Designing reports for printing

Product: Microsoft Access

Level: Introductory

Duration: 1 day

 

Enquire now

Intermediate/Advanced course

Streamline databases by creating relationships between tables to cut down the amount of data required. Update or delete data in tables automatically. Automatically calculate other values in forms and reports. Make your database attractive, safe and easy to use by others, using a menu system. Prevent accidental deletion by others. Run powerful combined actions using menus.

Course contents

  • Creating table relationships
  • Viewing database relationships
  • Advanced queries
  • Action queries
  • Calculated fields
  • Creating a menu system
  • Protecting important database elements
  • Macros
  • Assigning macros to menus and form controls

Product: Microsoft Access

Level: Intermediate/Advanced

Duration: 1 day

 

Enquire now

Enquire About Access Courses

Make an enquiry