The latest version of Microsoft Office is 2019/O365 but the earlier formats - 2016, 2013 are 2010 - are still very much to be found in offices and homes throughout the UK and abroad.  Microsoft, however, has now ceased to provide support for Office 2007, 2003 and Windows XP.  The table below displays the icons that represent the different applications available in Microsoft Office.  Click on an icon to see more details, such as course outlines and main features.

 

For the everyday user, each version provides all of the basics for that particular Office application but you will see the new releases add a little more functionality to its predecessor.  All course outlines can be download as a PDF file; simply click on the appropriate logo to open up a new window, read about the course and download the outlines.

Word with text.jpg

Microsoft Access Level 2

Microsoft Access training throughout the UK, including Manchester, Leeds, Birmingham, York, Carlisle, Newcastle, Sheffield, Glasgow, Edinburgh, Aberdeen, Derby, Norwich, Portsmouth, Swansea, Cardiff, Chester.  For overseas training and contracts, please call to discuss your requirements.

Microsoft Access Level 3 – Course Outline

 

About This Course

To understand the next level of Access’ features such as: database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access.

 

Target Audience

Preferably, you have attended Access Levels 1 and 2 or have relevant experience of working with the following features of Access:

 

  • Understand the steps required to properly design a database

  • Create a database

  • Create tables and table relationships

  • Control data entry with field properties

  • Create queries and understand query joins

  • Create reports and subreports

  • Add and format controls on forms and reports

  • Import and export data

 

Course Content

 

Unit 1 - Implementing Advanced Form Design

  • Add Controls to Forms

  • Create Subforms

  • Organise Information with Tab Pages

  • Enhance Navigation of Forms

  • Apply Conditional Formatting

 

Unit 2 - Using Data Validation

  • Field and Record Validation

  • Form Validation

 

Unit 3 - Using Macros to Improve User Interface Design

  • Create a Macro

  • Restrict Records Using a Condition

  • Validate Data Using a Macro

  • Automate Data Entry Using a Macro

  • Convert a Macro to VBA

 

Unit 4 - Using Advanced Database Management

  • Link Tables to External Data Sources

  • Manage a Database

  • Determine Object Dependency

  • Document a Database

  • Analyse the Performance of a Database

 

Unit 5 - Distributing and Securing a Database

  • Splitting a Database for Multiple User Access

  • Implement Security

  • Set Passwords

  • Convert an Access Database to an ACCDE File

  • Package a Database with a Digital Signature

 

Unit 6 - Managing Switchboards

  • Create a Database Switchboard

  • Modify a Database Switchboard

  • Set Startup Options

 

 

Course duration: one day.

 

Word with text.jpg
Visio with text.jpg
Excel with text.jpg
Publisher with text.jpg
PowerPoint with text.jpg
OneNote with text.jpg
Outlook with text.jpg
Access with text.jpg
SharePoint with text.jpg
Project with text.jpg

Contact Us

128A Albert Road West, Heaton, Bolton, BL1 5EB, UK

Tel: 07931 388426

©2019 Easy PC Training Ltd