Description

Our Microsoft Access Diploma for Data Entry has been created in partnership with Microsoft Learning Partners. Access is a vital programme for Data Entry Professionals. Microsoft Access provides the ability to store, manipulate, input, and present large amounts of data. Access is the main database program from Microsoft Office.

Microsoft Access Diploma for Data Entry

Our Diploma aims to build your speed and accuracy using Access. This will be done through the numerous queries, formulas, and shortcuts included in the program. Access training can also show you how to validate and prevent errors in data. Another important part of Access is integrating data with other parts of Microsoft Office.

Diploma Format

The training is delivered online. Training can be taken at any time. You have 24/7 access. Our Diploma is delivered on interactive online software that enables interactive learning. Microsoft Learning Partners wrote all of the training material. The learning system contains a virtual tutor who will instruct you in all lessons, provide exercises, and give corrections and feedback. This state-of-the-art system provides the personalised interaction needed to gain skills and transfer them back to your job.

Course Content

The Access Diploma includes Beginner, Intermediate and Advanced levels. Below, you can see the details of each module:

Beginner module

Database Basics and Database Management

  • Getting started with the Database Management System
  • Opening a database
  • Database objects
  • Overview of Access ribbon
  • Maintaining Database records

Entering, Replacing, Editing, Finding, Deleting and Sorting records

  • Moving around in a datasheet/form
  • How to use the data

Print Preview data

  • Margins and orientation for printing any object
  • Running a query in your database

Proficient (Intermediate) Level

Objects and their datasheets

  • Managing objects
  • Formatting/reorganising a datasheet
  • Filtering records by the value in a field
  • Filtering by a range of field values
  • Inserting a Total row into a datasheet
  • Database creation and protection

The creation of a database

  • Converting a database
  • Protecting a database
  • More Advanced Database Management

Creating a table

  • Primary key
  • Importing data from another application
  • Exporting data
  • Creating a form
  • Object dependencies
  • Selecting the records to print in a report
  • Building Queries and increasing the efficiency of data extraction for End Users

Creating a Select query

  • Using the query design grid
  • Setting a selection criterion in a query
  • Setting criteria on multiple fields
  • Multiple criteria in the same field
  • Sorting the records in a query
  • Delete query
  • Make Table query
  • Update query

Advanced Module

Tables: all about the design

  • Datasheet / Design view
  • Restricting what can be entered in a field
  • Input masks
  • Lookup lists  and Indexing a table
  • Relationships between tables
  • Forms for entering data

Form properties

  • Preventing access to form fields
  • Changing the order of access to fields
  • Subforms
  • Using a form to enter data in several tables at once
  • Collecting and sharing data
  • Controls: positioning, organising

Creating a text box to represent a field

  • Selecting and deleting controls
  • Creating a check box/button, an option group,  a label
  • Creating a calculated control
  • Calculating statistics in forms and reports
  • Creating a set list of values
  • Creating a list of values from an existing table/query
  • Controls: getting the presentation right

Moving and copying controls

  • Aligning and spacing controls
  • Changing the height of a section
  • Creating a rectangle/line control
  • Resizing and formatting controls
  • Formatting text in a control
  • Aligning text in a control
  • Conditional formatting
  • Copying a format from one control to another
  • Grouping/ungrouping controls
  • Numbering pages in a report or form
  • Inserting a picture
  • Themes
  • Reports for communicating data

Sorting information in a report

  • Grouping records in a report
  • Printing groups on separate pages of a report
  • Mailing labels
  • Find out more

Calculated fields in a query

  • Statistics without grouping
  • Statistics on groups and pre-selected records
  • Parameter queries
  • Find unmatched and duplicates query
  • Crosstab query
  • Creating a pivot table
  • Grouping records in a pivot table
  • Adding a totals
  • Pivot charts

Benefits

  • Training made by experts: senior Microsoft Trainers from a Microsoft Learning Partner
  • CPD Accredited Access Diploma
  • Receiving a CPD Certificate provides an internationally recognised qualification.
  • Virtual training with an expert, which enables you to do all the same just on personal training
  • Numerous practical exercises which provide you with all the needed skills
  • Professionally accredited qualification to help your CV

Other courses

Our Microsoft Excel Diploma for Data Entry is an ideal complement to this course. We additionally have a Microsoft Office Diploma for people looking to take all courses.