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 2019

  • Working with Access
  • Starting Access
  • Using the Interface
  • Using the File Tab
  • Opening an Existing Database
  • Using the Ribbon
  • Using the Quick Access 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

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 Recordsets
  • 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 a 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 2019 looking to kick-start a career as PA, EA, VA, Administrator, Secretary, Customer Services Executives and much more.
  • Anyone seeking to use Microsoft Access 2019 for advanced data management, analysis and report creation in home and small businesses.

Pre-requisite

An understanding of Windows / MS Access 2010/2013/2016 will be an added advantage.

  w/o GST w GST
Course Fee $430 $460.10

This course is applicable for Skills Development Fund (SDF).


Remarks:

COMAT is a business centre of e-Services, Electronics, ST Engineering.

Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.
  • This course is eligible for using PSEA funds.

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attain minimum 75% attendance in order to qualify for Funding.
  • Trainee undertakes to reimburse e-Services, Electronics, ST Engineering FULL course fees should he/she be ineligible for course fee grant. e-Services, Electronics, ST Engineering is not liable for any other funding not approved by WSG.
  • e-Services, Electronics, ST Engineering reserves the right to change the date or venue without prior notice.
  • e-Services, Electronics, ST Engineering reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.


Please click on the course date to enrol.