Microsoft Access for Advanced Users (2010/2013/2016) 2017-08-07T15:40:00+00:00

Project Description

Loading...
 Welkin Course Codes: DA0A, DD3A, DD6A

Course Features

In this course participants will learn how to enhance Access database operation with advanced and interactive functions. It will cover advanced techniques including:

  • Import and export data
  • Database relationships and validation rules
  • Select query and crosstab query techniques
  • Custom form and custom reports

At the end of the course, participants should have a more thorough understanding of Microsoft Access and be able make full use of each database object.

  • 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 Programming.

Course Fee

$2460

Course Duration

12 Hours

Course Prerequisites

Course participants should have basic knowledge of Microsoft Windows and Microsoft Access

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
DD6A-24C19C
 Central
 Cantonese / PC
19/12~2/1
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
DD6A-13C22K
 Mongkok
 Cantonese / PC
29/1~7/2
1900-220012 hrs/
4 sessions
MON, WED2,460.00
DD6A-35C21C
 Central
 Cantonese / PC
21/2~2/3
1900-220012 hrs/
4 sessions
WED, FRI2,460.00
DD6A-35C21K
 Mongkok
 Cantonese / PC
21/3~4/4
1900-220012 hrs/
4 sessions
WED, FRI2,460.00
DD6A-14C16C
 Central
 Cantonese / PC
16/4~26/4
1900-220012 hrs/
4 sessions
MON, THU2,460.00
DD6A-25C15K
 Mongkok
 Cantonese / PC
15/5~29/5
1900-220012 hrs/
4 sessions
TUE, FRI2,460.00
DD6A-6A16C
 Central
 Cantonese / PC
16/6~7/7
1000-130012 hrs/
4 sessions
SAT2,460.00
DD6A-24C17K
 Mongkok
 Cantonese / PC
17/7~26/7
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
DD6A-13C20C
 Central
 Cantonese / PC
20/8~29/8
1900-220012 hrs/
4 sessions
MON, WED2,460.00
DD6A-35C19K
 Mongkok
 Cantonese / PC
19/9~28/9
1900-220012 hrs/
4 sessions
WED, FRI2,460.00
Microsoft Access 2016 for Advanced Users
Complete your Enrol
How to enrol/pay online
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
DD3A-24C9C
 Central
 Cantonese / PC
9/1~18/1
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
DD3A-13C12K
 Mongkok
 Cantonese / PC
12/2~26/2
1900-220012 hrs/
4 sessions
MON, WED2,460.00
DD3A-18021C
 Central
 Cantonese / PC
26/2~27/2
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
DD3A-6D10C
 Central
 Cantonese / PC
10/3~17/3
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
DD3A-24C10K
 Mongkok
 Cantonese / PC
10/4~19/4
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
DD3A-18041K
 Mongkok
 Cantonese / PC
26/4~27/4
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,460.00
DD3A-35C16C
 Central
 Cantonese / PC
16/5~25/5
1900-220012 hrs/
4 sessions
WED, FRI2,460.00
DD3A-18061C
 Central
 Cantonese / PC
11/6~12/6
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
DD3A-6A16K
 Mongkok
 Cantonese / PC
16/6~7/7
1000-130012 hrs/
4 sessions
SAT2,460.00
DD3A-14C16C
 Central
 Cantonese / PC
16/7~26/7
1900-220012 hrs/
4 sessions
MON, THU2,460.00
DD3A-24C14K
 Mongkok
 Cantonese / PC
14/8~23/8
1900-220012 hrs/
4 sessions
TUE, THU2,460.00
DD3A-18081K
 Mongkok
 Cantonese / PC
29/8~30/8
0930-1230
1400-1700
12 hrs/
4 sessions
WED, THU2,460.00
DD3A-25C18C
 Central
 Cantonese / PC
18/9~2/10
1900-220012 hrs/
4 sessions
TUE, FRI2,460.00
DD3A-18101C
 Central
 Cantonese / PC
4/10~5/10
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,460.00
DD3A-18121K
 Mongkok
 Cantonese / PC
3/12~4/12
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
Microsoft Access 2013 for Advanced Users
Complete your Enrol
How to enrol/pay online
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
DA0A-17121K
 Mongkok
 Cantonese / PC
28/12~29/12
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,460.00
DA0A-6D30K
 Mongkok
 Cantonese / PC
30/12~6/1
1000-1300
1400-1700
12 hrs/
4 sessions
SAT2,460.00
DA0A-18011K
 Mongkok
 Cantonese / PC
8/1~9/1
0900-1230
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
DA0A-18031C
 Central
 Cantonese / PC
12/3~13/3
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
DA0A-18051K
 Mongkok
 Cantonese / PC
28/5~29/5
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
DA0A-18071C
 Central
 Cantonese / PC
23/7~24/7
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
DA0A-18091K
 Mongkok
 Cantonese / PC
17/9~18/9
0930-1230
1400-1700
12 hrs/
4 sessions
MON, TUE2,460.00
DA0A-18011C
 Central
 Cantonese / PC
22/11~23/11
0930-1230
1400-1700
12 hrs/
4 sessions
THU, FRI2,460.00
Microsoft Access 2010 for Advanced Users
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. Working in Access more efficiently
    • Changing default program options
    • Identifying new features of Access 2013
    • Upgrading from Access 2010
    • Enabling macros and other active content

     

  2. Import and Export Data
    • Import data into an Access database
    • External data operations available in apps and desktop databases
    • Importing into an Access app
    • Importing into a desktop database

     

  3. What is the Relationships window?
    • Types of table relationships
    • Why create table relationships?
    • Understanding referential integrity
    • Set the join type

     

  4. Restrict data input by using a validation rule
    • Overview
    • Types of validation rules
    • Where you can use validation rules
    • What you can put in a validation rule
    • Add a validation rule to a table

     

  5. Create a select query
    • Review data from select fields
    • Examples of criteria for Text fields
    • Examples of criteria for Number and Currency fields
    • Examples of criteria for a Yes/No field
    • Examples of using dates as criteria in Access queries
    • Examples that use the current date in their criteria
    • Examples that work with a date or range of dates other than the current date
    • Queries that filter for null (missing) or non-null dates

     

  6. Create a totals query
  7. Use parameters to ask for input when running a query
    • Add a parameter to a union query
    • Combine parameters with wildcards for more flexibility
    • Return items that don’t match the parameter
    • Specify parameter data types

     

  8. Crosstab query techniques
    • Overview
    • Create a crosstab query manually in Design view
    • A series of tips for crosstab queries.
    • Display row totals
    • Display zeros (not blanks)
    • Handle parameters
    • Specify column headings
    • Multiple sets of values
  1. Updating records by using queries
    • Create a make table query
    • Create an append query
    • Create an update query
    • Create a delete query

     

  2. Use a union query to combine multiple queries into a single result
    • Tips for using union queries

     

  3. Create PivotTable or PivotChart views in a desktop database
    • Learn about PivotTable views
    • View detail data
    • View individual items
    • Create a PivotTable view
    • Add row fields
    • Add column fields
    • Add detail fields
    • Add filter fields
    • Add calculated detail fields
    • Design a PivotChart view
    • Create a PivotChart view

     

  4. Create Custom Form
    • Modifying forms created by using a wizard
    • Create a Form using Form Wizard
    • Adding controls
    • Displaying subforms

     

  5. Create Custom Reports
    • Creating reports manually
    • Adding hyperlinks, charts, and buttons
    • Modifying report content
    • Layouts
    • Add Page Numbers
    • Adding Subreports

     

  6. Protect Databases
    • Assigning passwords to databases
    • Splitting databases
    • Securing databases for distribution

     

  7. Normalize your data using the Table Analyzer
  8. Create a macro that runs when you open a database
    • Create an AutoExec macro
  1. Working in Access more efficiently
    • Changing default program options
    • Identifying new features of Access 2013
    • Upgrading from Access 2010
    • Enabling macros and other active content

     

  2. Import and Export Data
    • Import data into an Access database
    • External data operations available in apps and desktop databases
    • Importing into an Access app
    • Importing into a desktop database

     

  3. What is the Relationships window?
    • Types of table relationships
    • Why create table relationships?
    • Understanding referential integrity
    • Set the join type

     

  4. Restrict data input by using a validation rule
    • Overview
    • Types of validation rules
    • Where you can use validation rules
    • What you can put in a validation rule
    • Add a validation rule to a table

     

  5. Create a select query
    • Review data from select fields
    • Examples of criteria for Text fields
    • Examples of criteria for Number and Currency fields
    • Examples of criteria for a Yes/No field
    • Examples of using dates as criteria in Access queries
    • Examples that use the current date in their criteria
    • Examples that work with a date or range of dates other than the current date
    • Queries that filter for null (missing) or non-null dates

     

  6. Create a totals query
  7. Use parameters to ask for input when running a query
    • Add a parameter to a union query
    • Combine parameters with wildcards for more flexibility
    • Return items that don’t match the parameter
    • Specify parameter data types

     

  8. Crosstab query techniques
    • Overview
    • Create a crosstab query manually in Design view
    • A series of tips for crosstab queries.
    • Display row totals
    • Display zeros (not blanks)
    • Handle parameters
    • Specify column headings
    • Multiple sets of values
  1. Updating records by using queries
    • Create a make table query
    • Create an append query
    • Create an update query
    • Create a delete query

     

  2. Use a union query to combine multiple queries into a single result
    • Tips for using union queries

     

  3. Create PivotTable or PivotChart views in a desktop database
    • Learn about PivotTable views
    • View detail data
    • View individual items
    • Create a PivotTable view
    • Add row fields
    • Add column fields
    • Add detail fields
    • Add filter fields
    • Add calculated detail fields
    • Design a PivotChart view
    • Create a PivotChart view

     

  4. Create Custom Form
    • Modifying forms created by using a wizard
    • Create a Form using Form Wizard
    • Adding controls
    • Displaying subforms

     

  5. Create Custom Reports
    • Creating reports manually
    • Adding hyperlinks, charts, and buttons
    • Modifying report content
    • Layouts
    • Add Page Numbers
    • Adding Subreports

     

  6. Protect Databases
    • Assigning passwords to databases
    • Splitting databases
    • Securing databases for distribution

     

  7. Normalize your data using the Table Analyzer
  8. Create a macro that runs when you open a database
    • Create an AutoExec macro
  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