Microsoft Office Access Training | MS Access 2000, XP, 2003 to 2007

Courses

› Microsoft Office Word Training › Microsoft Office Excel Training › Microsoft Office Access Training › Microsoft Office PowerPoint Training › Microsoft Office Outlook Training › Microsoft Office Project Training › Microsoft Windows & PC Training

Business Support Services

› Administration, Bookkeeping, Invoicing, VAT Returns, Sage Accounts, Excel Accounts, Secretarial Services

Microsoft Office Access Training

All of our courses are instructor led & can be delivered at your site anywhere in the UK. Delegates receive a course workbook to keep as well as a certificate, which help our clients to keep their staff training records up to date.

Any version of Access can be covered from Access 2000, Access XP, Access 2003, Access 2007 to Access 2010. All Access courses are one day in length. Access 2007 & 2010 courses also show delegates how to use the new ‘Fluent’ Office interface & find their way around the Ribbon.

MS Access Introduction
This course introduces the delegate to the creation of an Access database and understanding how relational databases work. Delegates will learn how to organise data into tables and how to find data using queries and filters.

Open, save & close Access databases
Use the Access help system & the Office Assistant
Enter, edit & delete information using tables & forms
Create tables, forms & reports using wizards & Design View
Modify Access database objects using Design View
Sort & filter information held in an Access database
Create select queries to extract & sort information
Preview & print Access database objects

MS Access Intermediate
This course provides delegates with a brief review of Access basics and introduces them to more features within Access. Delegates will learn how to create relationships between tables and create forms and reports to capture, display and analyse data.

Work with Queries
Create Calculated Fields
Change Field Properties
Create AutoForms
Use Form Wizard
Create Reports
Modify Reports
Print Forms and Reports
Create a Data Access Page

MS Access Advanced
This course introduces delegates to the advanced features of Access. It is designed for the experienced Access user and helps delegates advance their skills in designing queries, forms and reports, making databases work more efficiently.

Create Relationships between tables
Create Queries based on multiple tables
Create Parameter Queries
Perform calculations in Queries
Find unmatched records using a query
Create & use Crosstab Queries
Use expressions & add totals to reports
Import data into Access from other data sources
Export data from Access into other programs

Email us now at andyhardy@f1rstit.co.uk or call us on 0115 926 2078 to discuss your Microsoft Access training needs.

All of our courses are one day in length and can be delivered on-site or off-site.

Courses can be provided for all versions of Office from Office 2000 to Office 2010.

Enter your name & email address to receive our course information PDF:

Office 2010
As businesses replace & upgrade their IT equipment, they will inevitably move over to Office 2010. The interface for most of the Office packages has been dramatically changed.
No more menus or toolbars! Instead Microsoft created the Ribbon. This has radically changed the way you use Office & it has made many features more easily accessible. But it has also made some features hard to find.

Your staff WILL need training as you move over to the latest version of Office. Why struggle when we can help?