Microsoft Access 2016 – Basic and Intermediate

Course Code: ASKAB6

Microsoft Access 2016 – Basic and Intermediate

Upon completion of Microsoft Access 2016 – Basic and Intermediate training, participants will develop essential knowledge and skills in using Microsoft Access. It allows the participants to understand Database structure & concept with table relationships. You will learn how to create and modify database objects such as tables, forms, reports and queries, and subsequently apply intermediate skills to manage data entry, ensure data integrity, automate tasks and analyze data.

Some may feel that using Microsoft Excel is sufficient at work. In fact, Microsoft Access is preferred over Excel for people who deal with multiple reports and queries, especially for small business owners. Microsoft access is used for collecting and sorting of data. Access is used as part of the RDMS (Relational Database Management Systems). And you’ll find this application in the higher versions of Microsoft Office. Both Excel vs access are important applications. But their usage is suited for different sets of people. Excel only provides worksheets that are flat or non-relational. On the other hand, Access provides tables that are relational at multiple levels.

Microsoft Access 2016 - Basic and Intermediate

The training allow you to build a solid foundation of Access knowledge, and after you are familiar with the program, you will be focusing on database Design or administration.

If you are desired to get in depth knowledge, don’t miss the next level of training Microsoft Access 2016 – Advanced

  • Course Dates and Venue

    Course Duration: 2 day (16 hours), 9:00a.m. – 5:00p.m.

    Microsoft Access 2016 - Basic and IntermediateJTC Summit22-23-10-11-08-09-
    Mountbatten Square-19-20-07-08-11-12

    September 2015

  • Database Basics

    • Introduction to Databases
    • What’s New in Access 2016
    • Understanding the Access Program Screen
    • Working with Database Objects
    • Tour of a Table, Form, Query & Report
    • Adding, Editing and Deleting Records
    • Selecting Data & Using the Zoom Box

    Creating and Working with a Database

    • Planning a Database
    • Creating a New Database
    • Converting an Access Database

    Working with Tables and Fields

    • Modifying a Table
    • Understanding Field Properties
    • Indexing a Field
    • Adding a Primary Key to a Table
    • Inserting, Deleting, and Reordering Fields
    • Adding Field Descriptions and Captions
    • Changing the Field Size
    • Formatting Number, Currency & Date/Time Fields by Hand
    • Formatting Text Fields
    • Using Hyperlink Fields
    • Setting a Default Value
    • Requiring Data Entry
    • Validating Data
    • Creating an Input Mask
    • Creating a Lookup Field
    • Creating a Value List
    • Modifying a Lookup List

    Finding, Filtering, and Formatting Data

    • Finding and Replacing Data
    • Sorting Records
    • Using Common Filters
    • Filtering by Selection & by Form
    • Creating an Advanced Filter
    • Adjusting and Rearranging Rows and Columns
    • Changing Gridline and Cell Effects
    • Changing the Datasheet Font
    • Freezing & Hiding a Column

    Creating Relational Databases

    • Understanding Table Relationships
    • Creating Relationships Between Tables
    • Enforcing Referential Integrity
    • Printing and Deleting Relationships
    • Understanding Relationship Types

    Working with Queries

    • Creating & Sorting a Query
    • Using AND and OR Operators in a Query
    • Understanding Different Types of Queries
    • Creating a Multiple Table Query
    • Creating a Calculated Field
    • Summarizing Groups of Records
    • Display Top or Bottom Values

    Working with Forms

    • Creating a Form with the Form Wizard
    • Creating and Using a Form
    • Understanding Form Views
    • Modifying a Form in Layout View
    • Form Design View Basics
    • Creating a Subform
    • Modifying and Working with Subforms

    Working with Reports

    • Creating a Report with the Report Wizard
    • Creating a Report
    • Working in Layout View
    • Adding a Logo
    • Working in Design View
    • Adjusting Page Margins and Orientation
    • Adding Page Numbers and Dates
    • Creating Mailing Labels with the Label Wizard

    Formatting Forms and Reports

    • Formatting Fonts
    • Changing Text Alignment
    • Changing Colors
    • Using Conditional Formatting
    • Adding Pictures, Lines and Gridlines
    • Working with Number Formatting
    • Using Themes

  • Microsoft Access 2016 – Basic and Intermediate enables individuals that have no knowledge of coding or database to manage the database easily and efficiently.

    User: This course is recommended for Admin Executive and Data Analyst. This allows the individuals to be able to enter data, insert basic tables, forms queries, and reports.

  • “Sandra is very knowledgeable. And she is patient with us. Kudos Sandra!.. I will look out for another lesson from her.” – Zarina Taib; CID (16-17 Nov 2017)

    “Create and link data were useful, as this would fasten my work process” – Chew Swee Long; CNB (16-17 Nov 2017)

    “Tables & Queries creation was the most useful part of the course.” – (14-15 Sep 2017)

    “Trainer Sandra was patient and willing to teach.” – (14-15 Sep 2017)

    “Understanding how the database works and how we can extract the data we want were useful. The trainer, Sherie, was patient. Helpful in assisting us follow the pace of lesson.” – Norlina Binte Maksum; SPF (24-25 Jul 2017)

Fees and Grants

$406.60 per participant (Inc. GST)

Click here for UTAP Fundings

SDF subsidy: $2 per training hour. For more information on SDF, please refer to > Funding Mechanism.

Applicants may use SkillsFuture Credit for this course

Absentees will be charged the full course fee.


Click here to download registration form.

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Apply Online

Microsoft Access 2016 – Basic and Intermediate (ASKAB6)

All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name*

Company UEN*

Company Address*

Postal Code*

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

Fax Number

C. Billing Information

Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

Applicable to some select IT and Softskills Courses.

How did you get to hear about us?*

D. Participants

Participant 1

Course Start Date*

Course End Date*

Participant 2

Course Start Date*

Course End Date*

Participant 3

Course Start Date*

Course End Date*

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions

We do not sell or share your information with anyone else.

Share this course