Microsoft Access Training Courses
At Mouse Training we offer 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, public and 1-2-1, at your location or our comfortable and fully equipped London Training Centre.
All of our Access courses are hands-on, 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.
Access Versions
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 program, you can take your career to the next level. Read More
Continuing Professional Development – CPD is recognised as important because it derives benefits to the individual, their profession and their customers / public.
Courses are certified by the CPD` assessment organisation will help you revise these aims. Read More
Course Materials
All our training materials are published by two well know publishers CCL Learning and Velsoft
CCL Learning Manuals
CCL 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, seven titles to collect.
These manuals can be purchase from ourselves as part of the official study MOS 2016 kit or manual only – you do not need to attend our courses to purchase these fantastic manuals.
Manuals for other Office versions are available – Office 2010 and 2013, soon to be released Office 2019 and office 365
Velsoft Materials
Velsoft publish a vast range of manuals, these manuals are available to all attending our courses, for group booking requiring tailored course outlines we can provide a tailored course manual.
Latest release – Microsoft Teams
Read more about our publishers – click on their logos below
Mouse Trainers
Microsoft Access trainers are experts in their field, Microsoft Certified Trainer ( MCTs ), demonstrating their in depth and detailed knowledge and understanding of this subjects area. Each has years of experience providing effective training,
Why Attend Training at our Training Venue
When attending our centre we provide everything you need for your day (s) with us in a comfortable relaxed atmosphere for training.
- Refreshments available throughout the day
- Complimentary lunch, normally including sandwiches, cakes, fruit, biscuits– we aim you do not go hungry
- State of the art Computers – All matching, 23’’ touch screen, all Microsoft Word version are available.
- Laptops – Laptops are available for onsite courses.
- 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.
- 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 fileds and assign field data types, working with field and table properties and assigning table primary keys.
Change between table views, create and table in bioth 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 alert s 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 parameter, 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/subreport 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, and use techniques to protect, maintain, and manage database files. Topics include –
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 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 zero, 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