Microsoft Access Training Courses

Access Training Courses Options

Mouse offers a wide range of Access training courses, covering all levels from beginner to MOS ( Microsoft Office Specialist ) – browse our standard course outlines below.

Standard Access training courses can be tailored to best  suit your requirements, and can be provided in a variety of styles including groups or 1-2-1, at your location or our comfortable and fully equipped London Training Centre.

If you have any questions or wish to discuss options please don’t hesitate to contact us..

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 

Mouse Trainers

Microsoft Access trainers are experts in their field, Microsoft Certified ( 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 – Complimentary access to online training materials
  • Stationery – Pens and notebooks supplied
  • Certificates – Course attendance certificates.
  • Recognised Examinations – Microsoft Office specialist MOS examinations available for Access Core Specialist 77-730

Microsoft Access Training Courses delivered in London and Nationwide

Microsoft Access Training Courses, Microsoft Access Training Courses in London
Microsoft Access Training Courses, Microsoft Access Training Courses in London

Access Introduction Level – Advanced Level Key Training Topics.

Exploring the Access Environment, 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, Key topics, – You will understand the structure of tables, data types, primary keys, field and table properties, change table views, create tables in Design viewnand datasheet view, Quick Start fields.

Import data from external sources, work in Datasheet view, create relationships, create lookup fields, understand Access alert and error messages.

Retrieving the Data You Want, Key topics – you will use the Find and Replace feature, sort and filter rectods, create a query in design view, modify and formaat 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, Key topics – you will create, modify, and use forms, you will use, form wizard and controls, create subforms and make your forms user friendly. Other featurede topics, validate your form’s data entry, format your formas and inserting graphics and themes.

Designing Reports, you will work with database reports. Upon successful completion of this lesson, you should be able to, create a report from scratch, work with controls, report layouts, add controls from the ribbon, work with 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, 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. 

Why attend our Access Training Courses 

 

Our Microsoft Access training courses take you on a journey from being a complete beginner through to an advanced user, able to make full use of the application’s capabilities and beyond.

At Mouse our Access training courses are delivered by highly efficient, expert Microsoft Certified trainers.

 Full access to our extensive library of software help guides is included in the price. 

All of our courses are available for private groups, either held at your workplace or at our Access training London centre. 

Microsoft Access Training courses London

10 Time-Saving Tips for MS Access Users