Introduction to Microsoft Access

We essentially use Microsoft Access as a database program to organise and store large quantities of data. If you are new to the concepts of a database our Introduction to Microsoft Access training course will give you the skills to create a database from scratch.

On this course you will build a database from scratch, enter data onto your database, work with forms, create reports and create simple queries.

The course will give you hands on experience via structured exercises during the session and will give you the opportunity to practice the skills you have learned. This course is the ideal stepping stone towards our Intermediate Microsoft Access course.
To get the most out of this course no previous experience of using a database is required but ideally you should be comfortable with the Microsoft Windows environment.

Course Duration

1 Day

Course Content

Download Course Content PDF

  • Introduction
    • Tour of the Screen
    • The Ribbon
    • Quick Access Toolbar
    • Setting Options
  • Database Creation
    • Database Terminology Explained
    • Designing a Table
    • The Table Design Window
    • Field Properties and Data Types
    • Setting a Primary Key
    • Saving the Table Design
  • Adding and Editing Data
    • Working in a Datasheet
    • Adding new records
    • Deleting existing records
    • How the application saves data
    • Explanation of the Undo feature
  • Altering the Table Design
    • Rearranging Fields
    • Inserting & Deleting Fields
    • Changing Field length
    • Changing Field type
  • Working in a Datasheet
    • Font and Cell effects
    • Column Width & Row Height
    • Hiding & Freezing Columns
  • Introduction
    • Tour of the Screen
    • The Ribbon
    • Quick Access Toolbar
    • Setting Options
  • Database Creation
    • Database Terminology Explained
    • Designing a Table
    • The Table Design Window
    • Field Properties and Data Types
    • Setting a Primary Key
    • Saving the Table Design
  • Adding and Editing Data
    • Working in a Datasheet
    • Adding new records
    • Deleting existing records
    • How the application saves data
    • Explanation of the Undo feature
  • Altering the Table Design
    • Rearranging Fields
    • Inserting & Deleting Fields
    • Changing Field length
    • Changing Field type
  • Working in a Datasheet
    • Font and Cell effects
    • Column Width & Row Height
    • Hiding & Freezing Columns

Download Full Course Schedule PDF

Ask a question

I consent to having this website store my submitted information so they can respond to my inquiry. See our privacy policy to learn more how we use data.
 

Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact info@base2.co.uk