Duration: 2 days
Time: 9am to 5.30pm

What Will Be Taught For This Microsoft Access Course?

The course empowers the trainee to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. The course is divided in two sections; the first section introduces the skills required to design and plan a simple database using a standard database package; the second section introduces the skills required to retrieve information from an existing database by using the query, select and sort tools available in the data-base. The trainee shall also be able to create and modify reports.

Module 1. Exploring Access 2010
  • Working with Access
  • Starting Access
  • Using the Interface
  • Using the File Tab
  • Opening an Existing Database
  • Using the Ribbon
  • Using the Contextual Tabs
  • Using the Quick Access Toolbar
  • Using the Mini Toolbar
  • Using Database Objects
  • Using the Navigation Pane
  • Opening a Database Object
  • Using Tabbed Documents
  • Closing a Tabbed Document
  • Closing All Tabbed Documents
  • Using the Status Bar
  • Using the Options Dialog Box
  • Closing a Database
  • Exiting Access
  • Practice - Exploring Access 2010
Module 2. Creating Tables
  • Using Database Templates
  • Creating a New Database
  • Designing Tables
  • Creating a Table in Datasheet View
  • Creating a Table in Design View
  • Adding Field Names
  • Assigning Data Types
  • Saving a New Table
  • Adding a Field Description
  • Setting a Primary Key
  • Using Multi-valued Fields
  • Practice - Creating Tables
Module 3. Field Properties
  • Using Field Properties
  • Limiting Field Size
  • Setting Number Formats
  • Setting Date/Time Formats
  • Setting Yes/No Formats
  • Setting Default Values
  • Setting Validation Rules
  • Creating an Input Mask -Wizard
  • Creating an Input Mask Manually
  • Creating a Custom Input Mask
  • Typing a Lookup List
  • Modifying Lookup Properties
  • Practice - Field Properties
Module 4. Working with Tables
  • Using Datasheet View
  • Navigating Fields in Tables
  • Using Field Templates
  • Adding Records
  • Moving through Records
  • Selecting Records
  • Editing Records
  • Saving Records
  • Deleting Records
  • Displaying a Totals Row in a Table
  • Practice - Working with Tables
Module 5. Editing Tables
  • Changing the Row Height
  • Changing the Column Width
  • Changing a Font Attribute
  • Changing a Cell Effect
  • Using Alternate Background Colors
  • Selecting a Column
  • Moving a Column
  • Hiding a Column
  • Unhiding a Column
  • Freezing a Column
  • Practice - Editing Tables
Module 6. Finding, Replacing and Filtering Data
  • Sorting Records
  • Finding Specific Records
  • Finding Records using Wildcards
  • Using Replace
  • Using Filter By Selection
  • Applying/Removing a Filter
  • Using Filter Excluding Selection
  • Using the Search Box
  • Using Quick Filter
  • Using AutoFilter
  • Practice - Finding and Filtering Data
Module 7. Using Simple Queries
  • Using Queries and Record sets
  • Using the Simple Query Wizard
  • Creating a Query in Design View
  • Opening a Query
  • Adding a Table to a Query
  • Joining Tables in a Query
  • Running a Query
  • Practice - Using Simple Queries
Module 8. Modifying Query Results
  • Sorting a Query
  • Adding Criteria to a Query
  • Hiding a Field in a Query
  • Displaying Totals Row in a Query
  • Adding a Record using a Query
  • Printing a Query
  • Practice - Modifying Query Results
Module 9. Using Operators in Queries
  • Using Comparison Operators
  • Using an And Condition
  • Using an Or Condition
  • Using the Between And Operator
  • Using the Expression Builder
  • Using a Wildcard Character
  • Practice - Using Operators in Queries
Module 10. Relating Tables
  • Using Related Tables
  • Creating a Relationship between Tables
  • Setting Referential Integrity
  • Viewing Subdatasheets
  • Deleting a Join Line
  • Practice - Creating Relationships
Module 11. Creating Basic Forms
  • Using Forms
  • Using the Form Button
  • Adding a Record using a Form
  • Using the Calendar for Date Picking
  • Using the Form Wizard
  • Viewing Records in a Form
  • Printing Records in a Form
  • Basing a Form on a Query
  • Practice - Creating Basic Forms
Module 12. Using Design View
  • Adding a Label
  • Adding an Image
  • Adding a Rectangle
  • Adding a Line
  • Editing an Unbound Control
  • Using Multiple Undo/Redo in Design View
  • Practice - Using Design View
Module 13. Creating Basic Reports
  • Using Reports
  • Using the Report Button
  • Using Print Preview -Reports
  • Printing Pages of a Report
  • Using the Report Wizard
  • Changing Views in a Report
  • Grouping and Summarizing Report Data
  • Basing a Report on a Query
  • Practice - Creating Basic Reports
Module 14. Using Advanced Report Design
  • Adding Report Sections in Design View
  • Creating a Calculated Control
  • Creating a Running Summary
  • Inserting a Date/Time Control
  • Inserting a Page Break
  • Changing the Report Margins
  • Using the Label Wizard
  • Creating a Report without Using a Wizard
  • Practice - Using Advanced Report Design

Who Should Attend This Microsoft Access Training?

  • For individuals with none or little knowledge in Microsoft Access 2010 looking to kick-start a career as PA, EA, VA, Administrator, Secretary, Customer Services Executives and much more.
  • Anyone seeking to use Microsoft Access 2010 for advanced data management, analysis and report creation in home and small businesses.


An understanding of Windows / MS Access 2000 to MS Access 2007 will be an added advantage.

  w/o GST w GST
Course Fee $550 $588.50


  1. 2 to 4 weeks’ written notice from start date of training - 50% of course fee for cancellation

  2. Less than 2 weeks’ written notice from start date of training - 100% of course fees for postponement or cancellation

  3. ST Electronics (e-Services) Pte Ltd reserves the right to cancel or postpone any course or change the venue due to unforeseen circumstances.