Microsoft Access for Beginners (2010/2013/2016) 2017-08-04T14:11:17+00:00

Project Description

Loading...
Welkin Course Codes: DA0I,DD3I,DD6I

Course Description

Microsoft Access is a platform for building database or web apps to store and retrieve information more efficiently. Without needing to write codes, Microsoft Access can conveniently manage your data, and organize it for display. The course will begin from the basics, covering topics including:

  • Database design basics
  • Tables and primary keys
  • Queries
  • Access forms and reports
  • Grouped or summary reports

By the end of the course, participants can take advantage of Microsoft Access to help manage and monitor data in a more practical and efficient manner.

  • Qualified and experienced instructors
  • Weeknights and weekend classes available

Learn from the Experts

Get Professional Recognition

mos-certificate

Certify your Access skills with Microsoft Office Specialist certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.

Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills with the course Microsoft Access for Advanced Users.

Course Fee

$2040

Course Duration

12 Hours

Course Prerequisites

Course participants should have basic knowledge of Microsoft Windows.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement.

Schedule & Online Enrolment
Enquiry/Booking
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
DD6I-14C18C
 Central
 Cantonese / PC
18/12~4/1
1900-220012 hrs/
4 sessions
MON, THU2,040.00
DD6I-35C17K
 Mongkok
 Cantonese / PC
17/1~26/1
1900-220012 hrs/
4 sessions
WED, FRI2,040.00
DD6I-24C20C
 Central
 Cantonese / PC
20/2~1/3
1900-220012 hrs/
4 sessions
TUE, THU2,040.00
DD6I-13C19K
 Mongkok
 Cantonese / PC
19/3~28/3
1900-220012 hrs/
4 sessions
MON, WED2,040.00
DD6I-24C17C
 Central
 Cantonese / PC
17/4~26/4
1900-220012 hrs/
4 sessions
TUE, THU2,040.00
DD6I-6A12K
 Mongkok
 Cantonese / PC
12/5~2/6
1000-130012 hrs/
4 sessions
SAT2,040.00
DD6I-35C20C
 Central
 Cantonese / PC
20/6~29/6
1900-220012 hrs/
4 sessions
WED, FRI2,040.00
DD6I-35C4K
 Mongkok
 Cantonese / PC
4/7~13/7
1900-220012 hrs/
4 sessions
WED, FRI2,040.00
DD6I-13C13C
 Central
 Cantonese / PC
13/8~22/8
1900-220012 hrs/
4 sessions
MON, WED2,040.00
DD6I-24C28K
 Mongkok
 Cantonese / PC
28/8~6/9
1900-220012 hrs/
4 sessions
TUE, THU2,040.00
Microsoft Access 2016 for Beginners
Complete your Enrol
How to enrol/pay online
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
DD3I-35C20C
 Central
 Cantonese / PC
20/12~28/12
1900-220012 hrs/
4 sessions
WED, THU2,040.00
DD3I-18011K
 Mongkok
 Cantonese / PC
24/1~25/1
0930-1230
1400-1700
12 hrs/
4 sessions
WED, THU2,040.00
DD3I-13C29C
 Central
 Cantonese / PC
29/1~7/2
1900-220012 hrs/
4 sessions
MON, WED2,040.00
DD3I-24C27K
 Mongkok
 Cantonese / PC
27/2~8/3
1900-220012 hrs/
4 sessions
TUE, THU2,040.00
DD3I-18031C
 Central
 Cantonese / PC
1/3~2/3
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,040.00
DD3I-35C28C
 Central
 Cantonese / PC
28/3~11/4
1900-220012 hrs/
4 sessions
WED, FRI2,040.00
DD3I-13C23K
 Mongkok
 Cantonese / PC
23/4~2/5
1900-220012 hrs/
4 sessions
MON, WED2,040.00
DD3I-18051K
 Mongkok
 Cantonese / PC
7/5~8/5
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,040.00
DD3I-6A19C
 Central
 Cantonese / PC
19/5~9/6
1000-130012 hrs/
4 sessions
SAT2,040.00
DD3I-14C25K
 Mongkok
 Cantonese / PC
25/6~9/7
1900-220012 hrs/
4 sessions
MON, THU2,040.00
DD3I-18071C
 Central
 Cantonese / PC
12/7~13/7
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,040.00
DD3I-13C16C
 Central
 Cantonese / PC
16/7~25/7
1900-220012 hrs/
4 sessions
MON, WED2,040.00
DD3I-35C32K
 Mongkok
 Cantonese / PC
15/8~24/8
1900-220012 hrs/
4 sessions
WED, FRI2,040.00
DD3I-18091K
 Mongkok
 Cantonese / PC
3/9~4/9
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,040.00
DD3I-24C4C
 Central
 Cantonese / PC
4/9~13/9
1900-220012 hrs/
4 sessions
TUE, THU2,040.00
DD3I-18111C
 Central
 Cantonese / PC
6/11~7/11
0930-1230
1400-1700
12 hrs/
4 sessions
TUE, WED2,040.00
Microsoft Access 2013 for Beginners
Complete your Enrol
How to enrol/pay online
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
DA0I-35C27K
 Mongkok
 Cantonese / PC
27/12~5/1
1900-220012 hrs/
4 sessions
WED, FRI2,040.00
DA0I-18021C
 Central
 Cantonese / PC
5/2~6/2
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,040.00
DA0I-18041K
 Mongkok
 Cantonese / PC
9/4~10/4
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,040.00
DA0I-18061C
 Central
 Cantonese / PC
28/6~29/6
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,040.00
DA0I-18081K
 Mongkok
 Cantonese / PC
14/8~15/8
0930-1230
1400-1700
12 hrs/
4 sessions
TUE, WED2,040.00
DA0I-18101C
 Central
 Cantonese / PC
25/10~26/10
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,040.00
DA0I-18121K
 Mongkok
 Cantonese / PC
18/12~19/12
0930-1230
1400-1700
12 hrs/
4 sessions
TUE, WED2,040.00
Microsoft Access 2010 for Beginners
Complete your Enrol
How to enrol/pay online

Microsoft Access is a powerful database software application used to build relational databases. Access is noted for its friendly user interface and ease of use. In this course, you will learn the essential features of Microsoft Access and the skills to create and use an Access database.

  1. Database Concepts
    • What is a database?
    • What is a relational database?
    • What is a table?
    • What is a record (row)?
    • What is a field (column)?
  2. Opening a Database & Security Issues
    • Opening a database within your samples folder
    • Closing the Access program
  3. Tables, Fields and Field Types
    • Creating a new blank database
    • Adding fields and setting the field type
    • About Access Data Types
    • Closing and naming a table
  4. Table Navigation & Modification
    • Opening a table within a database
    • Switching between ‘Datasheet View’ and ‘Design View’
    • Adding records to a table
  5. Field Properties
    • Field Properties
    • Input Masks
    • Validating Numbers
    • Field Properties – Reference Materials
    • Field Properties – General
    • Field Properties – Format
    • Field Properties – Input Mask Characters
    • Field Properties – Input Mask Examples
  6. Manipulating Tables & Records
    • Deleting a single record
    • Deleting multiple records
  7. Primary Keys and Indexing
    • Defining a Primary Key
    • Indexing – Reference Notes
    • Creating a single-field Index
    • Creating a multiple-field Index
    • Deleting multi-field indexes
  8. Filtering
    • Text Filters
    • Applying a single filter
    • Clearing a single filter
    • Creating multiple filters
    • Clearing multiple filters
  1. Sorting
    • Sorting Records A-Z
    • Removing a sort
    • Sorting on multiple fields
  2. Searching
    • Searching through records
  3. Relationships
    • Table relationships
    • One-to-many relationship
    • Many-to-many relationship
    • One-to-one relationships
    • Creating relationships between tables
    • About Referential integrity
    • Enabling Referential Integrity
    • Cascade options
    • Cascade update related fields
    • Cascade delete related records
  4. Forms
    • Forms overview
    • Creating forms
    • Modifying forms
    • Form View
    • Deleting records using a form
    • Adding records using a form
    • Filtering a form
    • Removing a filter from a form
    • Inserting and modifying a form header
  5. Queries
    • What are queries?
    • Creating a simple query
    • Adding (and removing) criteria to a query
    • Running a query
    • Creating a two table query and sorting the results
    • What are Wildcards?
  6. Reports
    • What are reports?
    • Creating a simple report
    • Using the Report Wizard
    • Modifying the layout of a report
    • Adding a logo to a report
    • Formatting a form using themes
    • Inserting and formatting the date & time
    • Adding existing fields to a report
    • Totals
  1. What’s new in Access 2013
    • Getting started with apps
    • Table templates
    • External data
    • Opening in a browser
    • Navigation included
    • The Action Bar
    • Views easier to modify
    • Callouts for
    • New controls for working with related data
    • New deployment options
    • Package and distribute apps
  2. Basic tasks for an Access 2013 desktop database
    • Choose a template
    • Create a database from scratch
    • Add a table
    • Copy and paste data
    • Import or link to data
    • Organize data with the Table Analyzer
  3. Introduction to tables
    • Overview
    • Table and field properties
    • Table relationships
    • Keys
    • Add or change a table’s primary key
    • What makes a good primary key?
    • Examples of poor primary keys
    • Change the primary key
    • Benefits of using relationships
    • Add a table to a desktop database
    • Set table properties in a desktop database
    • Add a field to a table in a desktop database
    • Add a field by entering data
    • Set a field’s properties
    • Set field properties in Datasheet view
    • Change a field’s data type
    • Change a field’s format
    • Set other field properties
    • Set field properties
    • Prepare sample data to follow along with some examples
  4. Introduction to data types and field properties
    • Overview
    • Data types
    • Field properties
    • Supported field properties
    • Control data entry formats with input masks
    • About input masks
    • The three parts of an input mask
    • Characters that define input masks
    • Create an input mask
    • Add input masks by using the Input Mask Wizard
    • Customize input masks from the field property setting
    • Examples of input masks
    • Add a validation rule to a table field or record
    • Enter a validation rule
    • Enter a validation message
    • Create a lookup field in a desktop database
  5. Guide to table relationships
    • Introduction
    • Types of table relationships
    • Create a table relationship by using the Relationships window
    • Edit a relationship
    • Open the Edit Relationships dialog box
    • Set the cascade options
    • Turn cascade update and/or cascade delete on or off
    • Delete a table relationship
  1. Filter data in a desktop database
    • Filters support different data types
    • Different ways to filter
    • Common filters
    • Filter by selection
    • Filter by Form
    • Advanced Filter/Sort
    • Switch between Filtered and Unfiltered views of your data
    • Clear a filter
    • Save a filter and apply it automatically
    • Save a filter as a query
  2. Sort records on text, numeric, or date values
  3. Find and Replace records in Tables
    • Use wildcard characters in find and find-and-replace operations
  4. Create Access Queries
    • Introduction to queries
    • Add tables to a new query
    • Queries help you find and work with your data
    • Create a select query
    • Examples of query criteria
    • Examples of criteria for Text fields
    • Examples of criteria for Number and Currency fields
    • Examples of criteria for a Yes/No field
    • Examples that work with a date or range of dates other than the current date
    • Make calculations based on your data
    • Make summary data easier to read by using a crosstab query
    • Overview
    • Benefits of using the Crosstab Query Wizard
    • Create a crosstab query
    • Create a totals query
  5. Create an Access form
    • Create a form from an existing table or query
    • Create a blank form
    • Create a split form
    • Creating a continuous form with the multiple items template
    • Creating a single record form with the Form Wizard
    • Working with form views
    • Controlling editing and data entry in a form
    • Changing the data source for a form
    • Organizing your database with navigation forms
    • Adding fields to a form in design view
  6. Preparing data to print using reports
    • Creating a tabular report with multiple tables
    • Altering the presentation of controls on a page
    • Working with controls and sections
    • Using the Can Grow and Can Shrink Properties
    • Adding a running sum
    • Managing data and page breaks
    • Keep results together on the same page
    • Adding sorting and grouping on reports
    • Avoiding blank pages
    • Adding conditional formatting
    • Using labels and managing columns and rows
    • Working with layout view, report view, and Print Preview
    • Inserting and formatting the date & time
    • Adding existing fields to a report
  1. Basic Tasks for an Access Desktop Database
    • Choose a template
    • Create a database from scratch
    • Import or link to data
  2. Database Design Basics
    • Some database terms to know
    • What is good database design?
    • The design process
    • Determining the purpose of your database
    • Finding and organizing the required information
    • Dividing the information into tables
    • Turning information items into columns
    • Specifying primary keys
    • Creating the table relationships
  3. Learn the structure of an Access database
    • Overview
    • See details about the objects in a database
    • Explore a table in Design view
    • See the relationships between tables
    • See how objects use other objects
  4. Introduction to Tables
    • Overview
    • Add a table to an Access desktop database
    • Set table properties in a desktop database
  5. Add or Change a Table’s Primary Key in Access
    • Overview of primary key in Access
    • Add an AutoNumber primary key in Access
    • Set the primary key using fields you already have in Access
    • Remove the primary key in Access
  6. Filter data in a desktop database
    • About filtering
    • Different ways to filter
    • Switch between Filtered and Unfiltered views of your data
    • Clear a filter
    • Save a filter and apply it automatically
  1. Introduction to Queries
    • Queries help you find and work with your data
    • Create a select query
    • Apply criteria to a query
    • Apply criteria to text values
    • Apply criteria to dates
    • Create a parameter query
    • Create a totals query
    • Sum or count values on a datasheet with a Total row
    • Create a crosstab query
    • Create a make table query
    • Create an append query
    • Create an update query
    • Create a delete query
  2. Create an Access Form
    • Create a form from an existing table or query in Access
    • Create a form by using the Form tool
    • Create a blank form in Access
    • Create a split form in Access
    • Create a form that displays multiple records in Access
    • Create a form that contains a subform in Access
  3. Introduction to Reports in Access
    • Overview of reports in Access
    • Create a report in Access
    • Add grouping, sorting, or totals
    • Highlight data with conditional formatting
    • Customizing color and fonts
    • Add a logo or background image
    • Preview and print a report
  4. Create a Grouped or Summary Report
    • Create a quick grouped or sorted report
    • Build a new grouped report by using the Report Wizard
    • Add or modify grouping and sorting in an existing report
  1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

 

You may also be interested in