IT Training
Microsoft Access
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.
Microsoft Access can be delivered to introductory, intermediate and advanced level.
Each level is scheduled into a 1-day programme
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.
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
Cost
£165 + VAT per day
Tailored:
As well as this course being open to any individual (open course) this course can be delivered (closed course): -

to meet individual company requirements

to company housestyles and templates

within company premises

specifically to a group or team of staff
Contact
To book a place or for further information, please contact Suzanne Thomson
t: 01383 559000
f: 01383 559001
e:
suzanne@theblcc.co.uk
IT Booking Page |
| "Without
continual growth and progress, such words as improvement, achievement,
and success have no meaning." |
| Benjamin Franklin |
| Expand your skills and
secure your success with the following related courses. |
|
| |