You have no items in your shopping cart.
Course Details
Topic 1. Getting Started
- Key database concepts
- Launching Access and the backstage screen
- Creating the database file
- Understanding the Trust Center
- Digging into Ribbon tabs
- Using the Navigation pane
- Using the Tell Me feature
- Using the Quick Access Toolbar
- Signing in to a Microsoft account
- Making backups
- Accessing Access help
Topic 2. Creating Tables
- Understanding table structure and relationships
- Creating a table and setting data types
- Entering data
- Understanding primary and foreign keys
- Importing tables
Topic 3. Setting Field Properties
- Establishing relationships and maintaining referential integrity
- Editing table structure in Design view
- Controlling input with masks
- Setting the default value
- Establishing validation rules
- Creating lookup fields
- Setting additional field properties
Topic 4. Organizing Records
- Formatting columns
- Sorting table data
- Filtering table data
- Searching and replacing values
Topic 5. Using Queries
- Understanding queries
- Creating queries with the Simple Query Wizard
- Building queries in Design view
- Establishing constraints with criteria
- Specifying criteria with wildcards
- Leveraging multiple criteria with AND and OR statements
- Filtering with mathematical comparisons
- Creating flexible queries with parameter requests
- Building expressions
- Obtaining summary statistics
Topic 6. Working with Specialty Queries
- Using update queries
- Using make table queries
- Finding unmatched records
- Using delete queries
- Using append queries
- Creating a union query in SQL view
- Getting a different look with crosstab queries
Topic 7. Creating Forms
- Understanding the role of forms
- Generating forms from tables
- Adjusting form elements in Layout view
- Using the Form Wizard
Topic 8. Designing Forms
- Creating forms in Design view
- Exploring the form property sheet
- Setting data sources
- Adding components with form controls
- Understanding input boxes
- Record navigation
- Adding buttons
- Assigning a tab order
- Checking out the More Forms options
- Creating a navigation form
Topic 9. Creating Reports
- Introducing reports
- Using the Report Wizard
- Creating a report in Design view
- Editing a report in Layout view
- Grouping and sorting records
- Creating calculated totals
- Applying conditional formatting rules
- Creating labels
- Adjusting print settings
Topic 10. Working with Macros (Optional)
- Creating macros
- Embedding macros into buttons
- Attaching data macros to tables
- Launching macros at startup
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 21-65 years old
Minimum Software/Hardware Requirement
Software:
Sign up for free Microsoft Account
Hardware: Windows and Mac Laptops
SSG Training Grant
SSG TG is $15 per pax. Net fee after SSG TG is $309.82. Absentee Payroll is not eligible.
Steps to Apply Skills Future Claim
- The staff will send you an invoice with the fee breakdown.
- Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
- Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
- Upload your invoice and click ‘Submit’
Note
- SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
- All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
- An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
Job Roles
- Database Administrators
- Data Analysts/li>
- Project Managers
Trainers
Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.
Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.
Customer Reviews (12)
- will recommend Review by Course Participant/Trainee
-
Need to slow down a bit for beginner (Posted on 11/28/2023)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/10/2023)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
, (Posted on 2/26/2022)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Mr Ken is very approachable and provided clear deliver Review by Course Participant/Trainee
-
Warm Classroom1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Mr Ken is very approachable and provided clear delivery of the course material. I was able to design my own Access Database! (Posted on 2/26/2022) - will recommend Review by Course Participant/Trainee
-
. (Posted on 7/31/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - might recommend Review by Course Participant/Trainee
-
The notes provided was quite helpful to fall back on. Ken is a very knowledgeable trainer, but perhaps he can get feedback from his students after every module covered to check on their progress. I feel that his method of providing live demonstrations while expecting the student to follow whatever he is doing without checking for understanding, might not be effective in allowing the student to internalize what is being taught.1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Also, the time management should be more concise and shouldn't overrun the stipulated duration. (Posted on 8/12/2020) - might consider Review by Course Participant/Trainee
-
Trainer's laptop is fully operational. (Posted on 12/11/2019)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Do the examples together in class instea Review by Course Participant/Trainee
-
. (Posted on 5/16/2019)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Will Recommend Review by Course Participant/Trainee
-
Overall class is great just need some step by step guide. Cause 1day training would not remember so many some small details. But trainer offer to provide the steps so is awesome. (Posted on 7/22/2018)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Will Recommend Review by Course Participant/Trainee
-
The screenshots of the notes can be bigger. Those on the current notes are too small to read, thus rendering it useless (Posted on 10/30/2017)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Might Recommend Review by Course Participant/Trainee
-
Nil (Posted on 9/15/2017)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Might Recommend Review by Course Participant/Trainee
-
Standardise the version of access used and it would be nice to provide laptops with the same version as the tutor. But enjoyed the course overall (Posted on 8/9/2017)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
You May Be Interested In These Courses
Notion Masterclass: Project and Content Management Essentials
$300.00 (GST-exclusive)
$327.00
(GST-inclusive)
Effective Project Management with Generative AI (GenAI)
$600.00 (GST-exclusive)
$654.00
(GST-inclusive)
WSQ – Develop Intelligent Chatbots with Microsoft Copilot Studio and Generative AI
$750.00 (GST-exclusive)
$817.50
(GST-inclusive)
WSQ - Microsoft Cybersecurity Architect (SC-100) Training
$2,000.00 (GST-exclusive)
$2,180.00
(GST-inclusive)
Creating Business Applications with Microsoft Power Apps and Power Automate
$298.00 (GST-exclusive)
$324.82
(GST-inclusive)
WSQ - Microsoft Azure AI Engineer Associate (AI-102)
$900.00 (GST-exclusive)
$981.00
(GST-inclusive)
WSQ – Create Intelligent Power Apps and Automate Workflows with AI Builder and Copilot
$1,600.00 (GST-exclusive)
$1,744.00
(GST-inclusive)
WSQ - Microsoft Certified Azure Administrator Associate (AZ-104)
$2,500.00 (GST-exclusive)
$2,725.00
(GST-inclusive)
