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 1

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 1 – Course Outline

 

About This Course

This course provides an introduction to database design concepts, offering a grounding in creating the core objects of a database and covers data manipulation and extraction.

 

Target Audience

People who intend to design a database from scratch or improve existing Access databases.

 

At Course Completion

After completing this course, students will be able to:

 

  • Understand the basics of a relational database

  • Cover the basic process of starting Access and creating a database

  • Create tables and add, edit or delete data

  • Add validation to prevent incorrect data from being entered

  • Sort and filter tables

  • Create queries to retrieve specific items from an Access database

  • Create forms to make it easier to view or get the items that you want

  • Create reports to view, format and summarise the information in your database

 

Course Content

 

Unit 1 - Getting Started with Access Databases

  • Identify the Elements of the Access Interface

  • Identify the Components of a Database

  • Examine the Relational Database Design Process

 

Unit 2 - Building the Structure of a Database

  • Create a New Database

  • Create a Table

  • Manage Tables

  • Establish Table Relationships

 

Unit 3 - Managing Data in a Table

  • Modify Table Data

  • Sort and Filter Records

  • Work with Subdatasheets

 

Unit 4 - Querying a Database

  • Create a Query

  • Add Criteria to a Query

  • Add a Calculated Field to a Query

  • Perform Calculations on a Record Grouping

 

Unit 5 - Designing Forms

  • Create a Form

  • Modify the Design of a Form

  • View and Edit Data Using an Access Form

 

Unit 6 - Generating Reports

  • Create a Report

  • Add a Control to a Report

  • Format the Controls in a Report

  • Enhance the Appearance of a Report

  • Prepare a Report for Print

 

 

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