Course Details
Course Details
What You'll Learn
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
- Creating macros
- Embedding macros into buttons
- Attaching data macros to tables
- Launching macros at startup
Topic 11. Integrating Access with Office Suite
- Exporting tables to Excel
- Emailing with macros
- Linking to data in an Outlook database
- Setting up labels and mail merge documents in Word
Topic 12. Maintaining the Database
- Organizing the Navigation pane with custom groups
- Compacting and repairing the database
- Examining database object dependencies
- Documenting your work
- Printing the blueprint of your database with the Database Documenter
- Splitting a database into front and back ends
- Protecting the database with a password
- Creating custom Ribbon tabs
- Setting startup options and custom icons
Course Info
HRDF Funding
Please refer to this video https://youtu.be/Kzpd-V1F9Xs
1- HRD Corp Grant Helper
How to submit grant applications for HRD Corp Claimable Courses
2- Employers are required to apply for the grant at least one week before training commences.
Employers must submit their applications with supporting documents, including invoices/quotations, trainer profiles, training schedule and course content.
3- First, Login to Employer’s e-TRIS account -https://etris.hrdcorp.gov.my
Second, Click Application
4- Click Grant on the left side under Applications
5- Click Apply Grant on the left side under Applications
6- Click Apply
7- Choose a Scheme Code and select HRD Corp Claimable Courses: Skim Bantuan Latihan Khas. Then, click Apply
8- Scheme Code represents all types of training that suit the requirements provided by HRD Corp. Below are the list of schemes offered by HRD Corp:
9- Select your Immediate Officer and click Next
10- Select a Training Provider, then click Next
11- Please select a training programme from the list, then key in all the required details and click Next
Select your desired training programme.
Give an explanation on why the participant is required to attend the training. E.g., related to their tasks/ career development, etc.
Explain the background and objective of this training.
Select a relevant focus area. For Employer-Specific Courses, select ‘Not Applicable’.
12- If the training programme is a micro-credential programme, you are required to complete these 3 fields. Save and click Next
Insert MiCAS Application number
13- Based on the nine (9) pillars listed below, HRD Corp Focus Area Courses are closely tied to support government initiatives towards nation building. As such, courses offered through the HRD Corp Focus Areas are designed to provide the workforce with skills required for current and future demands. Details of the focus areas are as follows:
14- Please select a Course Title and Type of Training
15- Select the correct type of training according to the actual type of training, or as mentioned in the training brochure:
16- Please key in the Training Location and click Next
17- Please select the Level of Certification and click Next
18- Please follow the instructions and key in trainee details
19- Click Add Batch, then click Save
20- Click Add Trainee Details
21- Please key in all the required details, then click Add
22- Click Add if there are more participants. Once done, click Save
23- Click Next
24- Please key in the course fees and allowance details, then click Save
25- Estimated cost includes the course fees/external trainer fees, allowances, and consumable training materials. Please comply with the HRD Corp Allowable Cost Matrix.
26- Select Upfront Payment to Training Provider and key in the percentage from 0% to 30%. Then, click Save and Next
27- Complete the declaration form and select a desired officer
28- Add all the required documents, then click Add Attachment. Then, click Save and Submit Application
29- Once the New Grant Application is successfully submitted, the Grant Officer will evaluate the application accordingly. The application may be queried if additional information is required.
The application status will be updated via the employer’s dashboard, email, and the e-TRiS inbox.
Job Roles
Job Roles
- Those who want to learn Microsoft Access
Trainers
Trainers
Review
Write Your Own Review
- Recommended Courses




