Microsoft Access Rapid Learn

We all tend to work at a faster pace these days, however we are still expected to put time aside to learn how to operate our software in a manner that saves us time and effort. If you work alone or as part of a small business, taking time out can be difficult. Our Rapid Learn Microsoft Access training course is a fast way to help you develop the skills necessary to perform your daily tasks and can be accomplished over two separate half day sessions.

On this course you will quickly build a database from scratch, through to working with and understanding relational databases and related tables. You will be able to create more advanced reports and forms, generate and action more complex queries and create simple macros.

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 for our Microsoft Access Developer 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

2 x 1/2 Days

Course Content

Download Course Content PDF

  • Database Creation
    • Designing a Table
    • Field Properties and Data Types
    • Setting a Primary Key
    • Saving the Table Design
  • Adding and Editing Data
    • Working in a Datasheet
    • Adding, Deleting, Saving and Undoing
  • Altering the Table Design
    • Altering the Design
  • Working in a Datasheet
    • Changing the layout of a Datasheet
  • Simple Queries
    • Designing a Query
    • The Query Design Window
    • Selecting Fields/Records to Show
  • More Query Features
    • Calculating Query during a Query
    • Sorting and Totalling in a Query
  • Forms Design
    • Creating Forms with a Wizard
    • The Forms Design Window
  • Report Design
    • Creating Reports with a Wizard
    • The Report Design Window
  • More about Datasheets
    • Finding Information in a Datasheet
    • Replacing Information
    • Sorting and Filtering in a Datasheet
  • Relationships between Tables
    • The Northwind Sample Database
    • Multi-Table Queries
    • Creating the Relationships
  • Custom Forms
    • Starting from Scratch
    • Control Properties
    • Using List / Combo Boxes
    • Check Boxes / Option Buttons
    • Calculations on a Form
  • Custom Reports
    • Starting from Scratch
    • Sorting and Grouping
    • The Control Types to be Used
  • Action Queries
    • Make Table Queries
    • Append Queries
    • Delete Queries
    • Update Queries
  • Macro Design
    • Creating a Macro
    • The Macro Design Window
    • Saving and Running the Macro

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

Many of our courses are available for on-line booking.

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