Need help?

+44 20 7248 8987

Microsoft Access Diploma – CPD Accredited

£149.00

500 in stock

SKU: EXBEG-2-2 Category:

This is an Accredited Microsoft Access Diploma that is delivered online. When it comes to holding down so many jobs, there is going to be the need to use Microsoft Access.

If you need to work on your Access skills, then we have the right diploma for you.

Diploma Objective

Our training centre is a Certified Microsoft Office Academy, which enables students to gain all the skills that you need for everyday tasks. The Access Diploma that we provide is a CPD Accredited course, meaning that this certification is issued to participants after the course has finished, if completed successfully.

Diploma Format

The training is delivered online, using a virtual tutor. The virtual tutor instructs, corrects and provides examples, to simulate having a personal IT trainer. This is a very effective and up to date method of delivering interactive online training.

Access Diploma Content

Beginner Module

  • Database basics
  • Database management system
  • The ribbon and the Quick Access toolbar Opening a database
  • Database objects
  • Entering records
  • Finding records
  • Replacing the value in a field Deleting records
  • Sorting records
  • Print Preview
  • Margins and orientation for printing any object
  • Running a query

Intermediate Module

  • 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
  • Creating a database
  • Converting a database
  • Protecting a database
  • 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
  • Creating a Select query
  • Using the query design grid
  • Setting a selection criterion in a query
  • Setting criteria on multiple fields
  • Setting multiple criteria on the same field
  • Sorting the records in a query
  • Delete query
  • Make Table query
  • Update query

Advanced Module

  • Restructuring a table in Datasheet view
  • Restructuring a table in Design view
  • Restricting what can be entered in a field
  • Input masks
  • Lookup lists Indexing a table
  • Relationships between tables
  • Forms for entering data
  • You have a well-designed table and a lot of data to put in it.
  • You will find it easier to inter the data via a form
  • Form properties
  • Preventing access to form fields
  • Changing the order of access to fields
  • Sub forms
  • Using a form to inter data in several tables at once
  • Collecting and sharing data
  • Controls: positioning, organising
  • Think of controls as containers for your data. If you are creating a form, position them to simplify typing.
  • Creating a text box to represent a field
  • Selecting and deleting controls
  • Creating a check box/button
  • Creating an option group
  • Creating 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
  • Some simple techniques for the presentation of controls, to insure that your forms and reports are attractive
  • Moving and copying controls
  • Aligning and spacing controls
  • Changing the height of a section
  • Creating a rectangle/line control
  • Resizing controls
  • Formatting text in a control
  • Aligning text in a control
  • Formatting controls
  • 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
  • The better your reports look; the more impact your data will have.
  • Sorting information in a report
  • Grouping records in a report
  • Printing groups on separate pages of a report
  • Mailing labels
  • Find out more
  • Calculations, statistics, all sorts of queries… get to know some of Access’ less known functions.
  • Calculated fields in a query
  • Statistics without grouping
  • Statistics on groups
  • Statistics on groups of pre-selected records
  • Parameter queries
  • Find unmatched query
  • Find duplicates query
  • Crosstab query
  • Creating a pivot table
  • Grouping records in a pivot table
  • Adding a totals
  • Pivot charts

Dates and Duration

There is a maximum duration of 3 months. It can be completed far before this time. The course can be started and taken at any time.

Course Requirements

There are no entry requirements for this course. It is aimed at beginners.

Benefits

  • Training written by senior Microsoft Trainers in a Microsoft Certified Academy
  • Live help with your own virtual tutor
  • CPD Accredited Microsoft Access Diploma issued on completion
  • A practical course that includes a number of exercises
  • Outcome is after completion a CPD Accredited Diploma will be issued by the Microsoft Academy, which will build your CV and career options.

Related Courses