Search form

Microsoft Access Introductory

Any part of an organisation that gathers data, which is then required to be manipulated to inform decision-making such as sales/purchasing strategies or stock control, would benefit from using Access.

What You Study

Microsoft Access can be delivered to introductory, intermediate and advanced level. Each level is scheduled into a 1-day programme which is trainer led.

This course will cover the following topics:

Introductory Level:

Define a database structure and templates

Create tables, enter and edit data, modify table design

Understand relationships between data

Create a form, enter and edit data in a form, customise the form design

Introduction to queries and reports

Intermediate Level:

Customise forms and create subforms

Create command buttons and link and embed data

Create and use queries

Create a report, using queries to select records

Build “expressions” and calculations in reports and queries

Advanced Level:

Create and use Action queries

Advanced field properties, data validation, lookup fields

Joins and relationships

Understand, create, edit and save a macro

Create menu bars, macros and custom toolbar buttons

Event-driven procedures

Database security including user-level security

As well as being open to any individual, this course can be delivered:

to meet individual company requirements

to company housestyles and templates

within company premises

specifically to a group or team of staff

Duration and Attendance

This one day short course is delivered at Carnegie Conference Centre.

Price

£175 (ex VAT)/level

Includes all course materials, refreshments and a 2 course lunch at our 1835 Restaurant.

Entry Requirements

As a working knowledge of the full range of ICT packages is becoming a core competence within any workforce, this programme would be suitable for anyone who works with or manipulates data at any level within an organisation.