Access

Manage your data


Overview

What does the course cover?

This course guides new Access users through the powerful Microsoft Access program introducing them to the concepts and ideas behind relational databases. The course explains the structure, design and capabilities of databases and covers automation using the VBA programming language.

Aims

Why take this course?

To be able to design and build databases incorporating the use of forms, queries and reports. If you want to be able to import and export information from Windows based products and analyse that data. You’ll gain an advanced understanding of this application.

Audience

Who should attend?

New users of databases and users who have experience using applications like Excel and require the advanced facilities of Access. Also suitable for programmers not familiar with relational databases. Anyone wanting to master the advanced functionality of Access.


Course preview

Each course contains high quality, professional, Live demo’s, Downloadable exercise files and Real-world templates for you to use.


Live demo’s

Downloadable files

Real-world templates

Course detail and sample lessons

Section 1: Introduction To Access

Lesson 1: Introduction
View Demo
Lesson 2: Starting Access
View Demo
Lesson 3: Opening An Existing Database
Demo Not Available
Lesson 4: Exploring The Access Window
Demo Not Available
Lesson 5: Closing A Database And Exiting Access
Demo Not Available
Lesson 6: Creating A New Database
Demo Not Available

Section 2: Tables

Lesson 1: Introduction
View Demo
Lesson 2: Opening An Existing Tables
View Demo
Lesson 3: Changing, Adding And Deleting Records
Demo Not Available
Lesson 4: Sorting And Filtering Records
Demo Not Available
Lesson 5: Creating A New Table
Demo Not Available
Lesson 6: Primary Keys
Demo Not Available
Lesson 7: Field Types
Demo Not Available
Lesson 8: Field Properties
Demo Not Available
Lesson 9: Indexes
Demo Not Available
Lesson 10: Recap Of Definitions
Demo Not Available

Section 3: Table Relationships

Lesson 1: Introduction
View Demo
Lesson 2: What Is A Table Relationship?
View Demo
Lesson 3: Linking To Create A Relationship Between Tables
Demo Not Available
Lesson 4: Editing A Link
Demo Not Available
Lesson 5: Deleting A Link
Demo Not Available

Section 4: Queries

Lesson 1: Introduction
View Demo
Lesson 2: What Is A Query?
View Demo
Lesson 3: Creating A Query
Demo Not Available
Lesson 4: Sorting Records In A Query
Demo Not Available
Lesson 5: Specifying Criteria
Demo Not Available
Lesson 6: Finding Empty Cells
Demo Not Available
Lesson 7: Criteria For Numbers
Demo Not Available
Lesson 8: Entering Multiple Criteria
Demo Not Available
Lesson 9: Using More Than One Table In A Query
Demo Not Available
Lesson 10: Different Query Types
Demo Not Available

Section 5: Forms

Lesson 1: Introduction
View Demo
Lesson 2: Creating A Form
View Demo
Lesson 3: Editing A Forms Design
Demo Not Available
Lesson 4: Adding And Editing Data Using A Form
Demo Not Available
Lesson 5: Deleting A Form
Demo Not Available

Section 6: Reports

Lesson 1: Introduction
View Demo
Lesson 2: Creating A Report
View Demo
Lesson 3: Editing A Reports Design
Demo Not Available
Lesson 4: Printing Report
Demo Not Available
Lesson 5: Deleting A Report
Demo Not Available

Section 7: Preparing Output

Lesson 1: Introduction
View Demo
Lesson 2: Printing A Table And Selected Records
View Demo
Lesson 3: Printing A Query, Form And Report
Demo Not Available


Skills you’ll learn

What you’ll be able to do after the course

  • Create and understand simple relational database models
  • Query a database and create summary reports
  • Create simple forms and reports for data entry
  • Select cells, rows and columns
  • Create macros to automate reports and forms
  • Editing A Reports Design

How you can apply these skills

What you’ll be able to use these skills for

  • Design and build databases incorporating the use of forms, queries and reports
  • Design a query to extract information from the database and export that information into other windows based products
  • Manipulate expressions and to be able create and edit macros to help automate the use of the database
  • Build queries and understand basic SQL syntax

Certification

When you pass you will receive an internationally recognised accreditation certificate like this:

IACT Certificate


What’s next?

Upon completion, you can move onto our more advanced Excel courses such as Excel Macros or Excel VBA.


Careers that require these skills at this level?

Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any role that requires the management of databases will require you to be able to use Access.


Want to start learning today?

Joining is simple, easy and risk free with our 7 day money back guarantee.