Access 2010

$79

Want to start learning today?

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

Start Free Trial

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 would benefit?

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 video lessons, downloadable exercise files and real-world templates for you to use.

Simple interface
Video lessons
Downloadable content

Course Details 

Section 1: Introduction To Access

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

Section 2: Tables

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

Section 3: Table Relationships

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

Section 4: Queries

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

Section 5: Forms

  • Lesson 1: Introduction
  • Lesson 2: Creating A Form
  • Lesson 3: Editing A Forms Design
  • Lesson 4: Adding And Editing Data Using A Form
  • Lesson 5: Deleting A Form

Section 6: Reports

  • Lesson 1: Introduction
  • Lesson 2: Creating A Report
  • Lesson 3: Editing A Reports Design
  • Lesson 4: Printing Report
  • Lesson 5: Deleting A Report

Section 7: Preparing Output

  • Lesson 1: Introduction
  • Lesson 2: Printing A Table And Selected Records
  • Lesson 3: Printing A Query, Form And Report

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 recognized accreditation certificate like this:

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.