Facebook-square
Instagram
Linkedin
Register Now

Course Description

This course, Microsoft Access 2019 – Basic and Intermediate, is designed to 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.

 

Some may feel that having knowledge of Microsoft Excel will suffice at work. In fact, Microsoft Access is preferred over Excel for people who deals with numerous reports and queries, especially for small business owners. Microsoft Access is used for collecting and sorting of data, and is part of the RDMS (Relational Database Management Systems). This application is found in the higher versions of Microsoft Office. While both Excel vs Access are important applications, their functions are useful for different purposes. Excel only provides worksheets that are flat or non-relational. On the other hand, Access provides tables that are relational at multiple levels.

 

Upon completion of training, participants will develop essential knowledge and skills in using Microsoft Access. It allows the participants to understand the Database structure & concept with table relationships. You will also 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.

 

The training allows 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 2019 – Advanced

Course Objectives

At the end of this course, you should be able to:

Use logical formulas to create conditions and return either TRUE or FALSE when their arguments are evaluated1

Create and work with Access Table and Fields. Understand field properties, indexing a field and adding a primary key to the table.

Create a Relationships between tables

Create a Relationships between tables.

Query data easily using join sort and filter data from different tables

Query data easily using join, sort, and filter data from different tables.

Create and Use forms to make it easier to view access and input data

Create and Use forms to make it easier to view, access, and input data.

Create and format custom reports

Create and format custom reports.

Use logical formulas to create conditions and return either TRUE or FALSE when their arguments are evaluated1

Create and work with Access Table and Fields. Understand field properties, indexing a field and adding a primary key to the table.

Create a Relationships between tables

Create a Relationships between tables.

Query data easily using join sort and filter data from different tables

Query data easily using join, sort, and filter data from different tables.

Create and Use forms to make it easier to view access and input data

Create and Use forms to make it easier to view, access, and input data.

Create and format custom reports

Create and format custom reports.

Course Outline

You will be learning the following:

  • Introduction to Databases
  • What’s New in Access 2019
  • 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
  • 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
  • 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
  • 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
  • Planning a Database
  • Creating a New Database
  • Converting an Access Database
  • Understanding Table Relationships
  • Creating Relationships Between Tables
  • Enforcing Referential Integrity
  • Printing and Deleting Relationships
  • Understanding Relationship Types
  • 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
  • Formatting Fonts
  • Changing Text Alignment
  • Changing Colors
  • Using Conditional Formatting
  • Adding Pictures, Lines, and Gridlines
  • Working with Number Formatting
  • Using Themes
pdf button download DOWNLOAD COURSE PDF

Course Fees And Grants

S$432.00 per participant (Incl. 8% GST)

SDF subsidy: $2 per training hour. please refer to Course Fee and Absentee Payroll Funding 

Click here for UTAP Fundings

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueMar-23Apr-23May-23Jun-23Jul-23Aug-23Sep-23
Microsoft Access 2019 - Basic and IntermediateTGS-2020503590JTC Summit-20-21-05-06-10-11-
TGS-2020503590Mountbatten Square23-24-02-03-03-04-11-12

Registration

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

DOWNLOAD REGISTRATION FORM
apply online button REGISTER ONLINE

Our Corporate Partners

Previous
Next

What Our Students Say

I attended a course with @ASK Training “Three Kingdoms' Leaderships In Today's context”. It's very interesting to learn about the past different leadership styles which are still applicable to Today's context. The focus on the different leadership qualities on the characters are useful and can be applied to my job. The trainer is also very knowledgeable in this topic.
Wong Kum San MalvemCNB Team Leader
Three Kingdoms' Leaderships In Today's context
This is the first time I attended home-based learning using zoom. Ms Zenn was attentive to my needs throughout those 2 days, making sure that I can see what the trainer was writing on the whiteboard and that I could hear the trainer clearly. When the instability of the hotel Wi-Fi led to connectivity issues throughout the course, Ms Zenn went the extra mile by using hotspot to stabilise the connections instead. Trainer, Kwan Liang was also attentive to my needs, making sure that I understood the topics. Even though I was the only participant doing home-based learning, they didn't let me feel that I'm being left out. I want to say a big thank you to ASK Training.
Heng Hui LingMHA Police Officer
Brainpower - Discovering and Developing Our Mental Skills
I attended this 2-day content marketing class over zoom, so it is hard enough to keep the lecture interesting, let alone the attention span of adults who have not studied in a long time. To my surprise, the class was engaging and fun with lots of activities to make you think on your toes and gives you great ideas for your own business. Highly recommended.
Amy Choo Wei LynnStudyGroup
Content Marketing Strategy
I have attended numerous training and seminars. I must say that @ASK Training is one of the few which really impressed me. Recently attended 2 ICDL courses with them. It’s team shows strong dedication towards bringing quality training and services to its learners. Quick response from admin staff and an exceptional trainer who went the extra mile to give me additional exercises & coaching in areas which I required further clarifications, all beyond the training hours. It is rare to find such a kind, patient, and passionate trainer.
Adrelina See TohICDL Perform Spreadsheet Functions (Excel Fundamentals) (Synchronous e-learning)
ICDL Perform Advanced Spreadsheet Functions (Excel Advanced) (Synchronous e-learning)
I attended a full day leadership workshop based on the romance of the three-kingdom, on how we could apply the leadership style of each character in today’s context. I was impressed by how the trainer, Anson, was able to impart his deep understanding of the story to us in English. I highly recommend this course to all English speaking business leaders. This is the only chance to catch a glimpse of the story fully translated and spoken live in front of you. I’d say that ASK Training is not a conventional training company, but one who is innovative and genuinely wanting to impart knowledge.
Zac NgDirector of HR Company
Three Kingdoms' Leaderships In Today's context
Previous
Next

Check Out Other Courses

pdf button download DOWNLOAD COURSE PDF

COURSE FEES AND GRANTS

S$432.00 per participant (Incl. 8% GST)

SDF subsidy: $2 per training hour. please refer to Course Fee and Absentee Payroll Funding 

Click here for UTAP Fundings

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

REGISTRATION

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

DOWNLOAD REGISTRATION FORM
apply online button REGISTER ONLINE
ASK Training