Microsoft Access Training Courses
Mouse Training offers a range of Microsoft Access training courses in London or at your office. We provide courses from beginner to advanced levels. Our Access courses can be tailored to best suit your requirements and can be provided in a variety of delivery styles, including group bookings, on-site training and 1-2-1 sessions, at your location or at our comfortable and fully equipped London Training Centre.
All of our Access courses are hands-on, so there is plenty of time for experimenting with what you are being taught, trying things out for yourself and asking questions, reinforcing the concepts that you are being taught.
We provide courses on most versions of Access including; Access 2007, Access 2010, Access 2013, Access 2016, Access 365 and Access 2019.
Access Certified Courses
As well as our standard courses we also provide Microsoft Office Specialist ( MOS ) and Continuing Professional Development ( CPD ) courses.
MOS – Microsoft Office Specialist – Get hired, demonstrate clear business impact, and advance your skills. With the Microsoft Office certification programme, you can take your career to the next level. Read More
Continuing Professional Development – CPD is recognised as crucial to your professional development as it delivers benefits to the individual, their profession and their customers. Courses are certified by the CPD assessment organisation. Read More
All our training materials are published by the two well known publishers, CCI Learning and Velsoft
CCI Learning Manuals
CCI Learning publish our Microsoft Office Specialist manuals. Titles include Access 2016, Word 2016 Core, Word 2016 Expert, Excel 2016 Core, Excel 2016 Expert, Outlook 2016 Core and PowerPoint 2016 Core.
These manuals can be purchased either from ourselves as part of the official study MOS 2016 exam kit or you can buy the manual separately – you do not need to attend our courses to purchase these fantastic manuals.
Manuals for other Office versions are available – Office 2010, Office 2013, Office 2019 and Office 365.
Velsoft publish a vast range of manuals, these manuals are available to all those attending our courses. For group bookings requiring a tailored course outline, we can provide a tailored course manual.
Latest release – Microsoft Teams
Our Microsoft Access trainers are experts in their field, Microsoft Certified Trainer ( MCTs ), demonstrating their in-depth and detailed knowledge and understanding of the subject area. Each has years of experience providing effective training,
Why Attend Training at our Training Venue
We provide everything you need for your time with us in a comfortable, relaxed atmosphere which is ideal for training.
- Refreshments are available throughout the day
- Complimentary lunch, normally including sandwiches, cakes, fruit, biscuits– we make sure that you do not go hungry!
- State of the art Computers – All matching, 23’’ touch screens. All Microsoft Access versions are available.
- High Speed, internet up to 500 meg.
- Air conditioned rooms.
- Course Materials – Full access to our extensive library of software manuals included in the price.
- Stationery – Pens and notebooks supplied
- Certificates – Course attendance certificates are available.
- Recognised Examinations – Microsoft Office specialist MOS examinations available for Access Core Specialist 77-730
If you have any questions or wish to discuss options please don’t hesitate to contact us..
Access Introduction Level – Advanced Level Key Training Topics.
Exploring the Access Environment, you will explore the Access interface and learn to create, open, and save database files. You will also work with the Navigation Pane and export database data.
Key topics – you will be able to describe the function of a database, identify database objects, start Access and create databases, import database objects, open and close databases, work with the Navigation Pane, export objects to alternate formats.
Building Tables, you will create database tables, you will also work with table records and change views. Upon successful completion of this lesson
Key topics – Understand the structure of tables, plan your table fields and assign field data types, working with field and table properties and assigning table primary keys.
Change between table views, create and table in both Design view and Datasheet view.
Using Quick Start fields and Application Parts.
import data from external sources and append records. Import data as linked tables.
Working in Datasheet view and modify the datasheet layout.
Printing records, constrain records input.
Creating relationships and foreign keys. Creating lookup fields and working with related records.
Understanding Access alerts and error messages.
Retrieving the Data You Want, you will explore methods for retrieving specific data from a database.
Key topics – you will use the Find and Replace feature, sort and filter records, create a query in design view, modify and format queries, adding a criteria and expressions.
Add calculated fields, totals to group and summarise data, create parameters, update, make table, append, delete and crosstab queries.
Working with Forms, you will create, modify, and use forms.
Key topics – you will create, modify, and use forms, you will use form wizard and form controls, create subforms and make your forms user friendly.
Validate form data entry.
Working with, headers, footers, fonts, themes, backgrounds and images.
Formatting your forms for printing and inserting a navigation form.
Designing Reports, you will work with database reports.
Key topics – Create a report from scratch using the Report Wizard. Work with controls, report layouts, add controls from the ribbon.
Insert subform/sub-report controls, add calculations to reports, group and sort data, add headers and footers, work with images and themes.
Protecting, Maintaining, and Managing Databases, you will encrypt and back up databases, and use techniques to protect, maintain, and manage database files.
Key topics – encrypt and back up databases, protect, maintain, and manage database files.
Open a database in exclusive mode, encrypt and password-protect databases, back up databases, compact and repair databases.
Set startup options, rename database objects, view object dependencies, delete database objects, split databases.
Why is Microsoft Access Popular?
With over a million users worldwide, Access is the tool of choice for storing and analysing data. Having a good understanding of Access is an essential key skill for any office worker today.
Microsoft Office Access 2016 (also known as Microsoft Access, or simply Access) is a database application. In this context, data refers to information that is usually in the form of text or numbers, and this information is stored in a table.
Information in one table may relate to information in one or many other tables. One or more tables of information, when grouped together in a logical way, are collectively referred to as a database.
Access is designed to enter, edit, and analyze the data in a database. Queries are used to extract information from the tables based on search criteria. You can use a form as a user-friendly method of viewing, entering, or modifying data.
Microsoft Access Training courses London.