MS Office Access (Online Session (Zoom))

This course starts at the basics. The modules progress to teach the participants about tables, reports, queries, how to manage a database, ways to customize the interface, and more.


 Module 1: The Basics

  •  Getting Started
  •  Signing In
  •  Creating a Database
  •  Database Terminology
  •  Saving a Database
  •  Opening a Database
  •  Review Questions

 Module 2: Your First Database

  •  About Security Warnings
  •  About Relationships
  •  Searching for Objects
  •  Opening Database Objects
  •  Changing the Object View
  •  Understanding the Types of Views Available
  •  Managing Objects
  •  Review Questions

 Module 3: Working with Tables and Records

  •  Creating a Table
  •  Understanding Table Views
  •  Adding and Editing Records
  •  Searching and Browsing Records
  •  Deleting Records
  •  Printing Records
  •  Review Questions

 Module 4: Formatting Tables

  •  Selecting Data
  •  Changing Column and Row Width and Height
  •  Applying Text Formatting
  •  Applying Gridlines
  •  Changing Fill Colors
  •  Checking Your Spelling
  •  Review Questions

 Module 5: Creating Forms

  •  Creating a Form from an Object
  •  Creating a Form with the Wizard
  •  Creating a Form from Scratch
  •  Understanding Form Views
  •  Using a Form
  •  Review Questions

 Module 6: Formatting Forms

  •  Understanding Bound and Unbound Controls
  •  Changing the Theme
  •  Using the Format Painter
  •  Adding Fields
  •  Adding Controls
  •  Adding Images and Logos
  •  Review Questions

 Module 7: Creating Reports

  •  Creating a Report from an Object
  •  Creating a Report with the Wizard
  •  Creating a Report from Scratch
  •  Understanding Report Views
  •  Printing Reports
  •  Review Questions

 Module 8: Formatting Reports

  •  Changing the Theme
  •  Using the Format Painter
  •  Grouping and Sorting Data
  •  Adding Controls
  •  Adding Images and Logos
  •  Adding Page Numbers, Headers, and Footers
  •  Review Questions

 Module 9: Creating Basic Queries

  •  Types of Queries
  •  Creating a Query with the Wizard
  •  Running a Query
  •  Understanding Query Views
  •  Sorting and Filtering a Query
  •  Review Questions

 Module 10: Creating Advanced Queries

  •  Creating and Using Parameter Queries
  •  Creating and Using Crosstab Queries
  •  Creating and Using Make-Table Queries
  •  Creating and Using Multiple Table Queries
  •  Creating and Using Append Queries
  •  Creating and Using Delete Queries
  •  Creating and Using Update Queries
  •  Review Questions

 Module 11: Managing Your Database

  •  Compacting and Repairing a Database
  •  Encrypting a Database with a Password
  •  Backing Up Your Database
  •  Exporting a Database and Database Objects
  •  Printing Database Objects
  •  Review Questions

 Module 12: Customizing the Interface

  •  Collapsing and Pinning the Ribbon
  •  Customizing the Quick Access Toolbar
  •  Hiding and Showing Ribbon Tabs
  •  Creating Custom Ribbon Tabs
  •  Resetting Interface Changes
  •  Review Questions
  •  Keyboard Shortcut Quick Reference Sheet

Find A Course


"The empathy and know your customer behind the design of the training is great!"

HR Manager, Strategic Thinking & Planning Course


"I am amazed by the quality of course"

Mr Michael, Supervisory Essentials Course


"Thank you for arranging for me to have this one-on-one class.  I think it was really the best option.  I was very happy with the day."

Ms Helen Redekopp, King Faisal Specialist Hospital & Research Centre - Business Succession Planning Course


Special Offers

SPECIAL OFFER: Book today for Customer Care for Customers With Special Needs Programme and save 30% for in-house programme.

click here

SPECIAL OFFERBook two places and get the third booking on the same course free of charge.

Whoops, looks like something went wrong.

1/1 ErrorException in Filesystem.php line 81: file_put_contents(): Only 0 of 456 bytes written, possibly out of free disk space

  1. in Filesystem.php line 81
  2. at HandleExceptions->handleError('2', 'file_put_contents(): Only 0 of 456 bytes written, possibly out of free disk space', '/home/smarttra/public_html/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php', '81', array('path' => '/home/smarttra/public_html/storage/framework/sessions/6e305b4757bd4894c54f3f90dba6c1db043d2587', 'contents' => 'a:5:{s:6:"_token";s:40:"VRzL7pZCp2qiXcHj5RtHR077NisiNKAHQYqirfRq";s:8:"laracart";a:2:{s:8:"instance";s:4:"cart";s:9:"instances";a:2:{i:0;s:7:"default";i:1;s:4:"cart";}}s:9:"_previous";a:1:{s:3:"url";s:116:"";}s:9:"_sf2_meta";a:3:{s:1:"u";i:1664556789;s:1:"c";i:1664556789;s:1:"l";s:1:"0";}s:5:"flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}', 'lock' => true))
  3. at file_put_contents('/home/smarttra/public_html/storage/framework/sessions/6e305b4757bd4894c54f3f90dba6c1db043d2587', 'a:5:{s:6:"_token";s:40:"VRzL7pZCp2qiXcHj5RtHR077NisiNKAHQYqirfRq";s:8:"laracart";a:2:{s:8:"instance";s:4:"cart";s:9:"instances";a:2:{i:0;s:7:"default";i:1;s:4:"cart";}}s:9:"_previous";a:1:{s:3:"url";s:116:"";}s:9:"_sf2_meta";a:3:{s:1:"u";i:1664556789;s:1:"c";i:1664556789;s:1:"l";s:1:"0";}s:5:"flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}', '2') in Filesystem.php line 81
  4. at Filesystem->put('/home/smarttra/public_html/storage/framework/sessions/6e305b4757bd4894c54f3f90dba6c1db043d2587', 'a:5:{s:6:"_token";s:40:"VRzL7pZCp2qiXcHj5RtHR077NisiNKAHQYqirfRq";s:8:"laracart";a:2:{s:8:"instance";s:4:"cart";s:9:"instances";a:2:{i:0;s:7:"default";i:1;s:4:"cart";}}s:9:"_previous";a:1:{s:3:"url";s:116:"";}s:9:"_sf2_meta";a:3:{s:1:"u";i:1664556789;s:1:"c";i:1664556789;s:1:"l";s:1:"0";}s:5:"flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}', true) in FileSessionHandler.php line 71
  5. at FileSessionHandler->write('6e305b4757bd4894c54f3f90dba6c1db043d2587', 'a:5:{s:6:"_token";s:40:"VRzL7pZCp2qiXcHj5RtHR077NisiNKAHQYqirfRq";s:8:"laracart";a:2:{s:8:"instance";s:4:"cart";s:9:"instances";a:2:{i:0;s:7:"default";i:1;s:4:"cart";}}s:9:"_previous";a:1:{s:3:"url";s:116:"";}s:9:"_sf2_meta";a:3:{s:1:"u";i:1664556789;s:1:"c";i:1664556789;s:1:"l";s:1:"0";}s:5:"flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}') in Store.php line 262
  6. at Store->save() in StartSession.php line 88
  7. at StartSession->terminate(object(Request), object(Response)) in Kernel.php line 155
  8. at Kernel->terminate(object(Request), object(Response)) in index.php line 58
  9. at require_once('/home/smarttra/public_html/public/index.php') in index.php line 20