The ability to input and manage database systems is key to many jobs. Microsoft Access is the most common database system and knowledge of this program is required in a wide range of industry.

This course will enable students to gain CPD Accreditation in Advanced Level Access, upon successful completion.

Microsoft Access Diploma

The course aims to develop Advanced skills in Access. This will enable learners to confidently build their careers using these new skills.

Course Content

Beginner Module

• Database Basics and Database Management
• What are Database object
• What is the Access ribbon
• Opening a database and maintaining Database records
• Entering, Replacing, Editing, Finding records in a Database
• Delete and Sorting records
• Margins and orientation when printing
• How to run a query
• Moving around in a datasheet/form
• How to use the database data and print preview

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

Database creation and protection

• Creating 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

From question to query

• 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 the Datasheet view / Design view
• What are Input masks
• Lookup lists Indexing a table
•  The relationships between tables
• Form properties / preventing access to form fields and changing the order of access to fields
• Subforms and using a form to enter data in several tables at once
• Collecting and sharing data
• Creating a text box to represent a field
• Selecting and deleting controls
• Creating a check box/button/option group/label / calculated control
• Calculating statistics in forms and reports
• Creating a setlist of values / list of values from an existing table/query
• Moving and copying controls
• Aligning and spacing controls
• Changing the height of a section
• Creating a rectangle/line control
• Resizing / Formatting text / Aligning text / 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
• Sorting information / Grouping records in a report
• Printing groups on separate pages of a report
• Mailing labels
• Calculated fields in a query
• Statistics without grouping / on groups/groups of pre-selected records
• Parameter queries
• Find unmatched / duplicates query
• Crosstab query
• Creating a pivot table / Grouping records in a pivot table
• Pivot charts

Course Format

The course is delivered using a virtual tutor on a live server. This is a state of the art learning system. The virtual tutor will instruct you and correct your exercises. This standard of interactive learning will enable you to gain from interactive learning. This is available to you on a flexible basis online.

Entry Requirements

There are none, as the Beginner level is included.

Dates and Duration

Training can commence on any date. The course has up to 12 months to complete. The majority complete the course far before 12 months. You can complete the course on flexi-time and online. The assessment at the end can be done online.

Benefits of the Course

• Training from a Microsoft Certified Academy, to ensure quality
• Virtual tutor on a live server enables interactive learning and guidance throughout the training program
• CPD Certification in Microsoft Access to build your CV
• Qualification is certified and can build your career
• Flexibility to train as intensely or otherwise as you prefer

Outcome

CPD Certificate in Microsoft Access Diploma on successful completion at Advanced Level.