Project Description

Loading...

Welkin Course Codes: DA0A, DD3A, DD6A

Course Features

In this course participants will learn how to enhance Access database operations with advanced and interactive functions. The course covers advanced Access database management skills and techniques including:

  • Import and export data
  • Database relationships and validation rules
  • Select query and crosstab query techniques
  • Custom forms and custom reports
By the end of the course, participants will have an in-depth understanding of Microsoft Access and be able to apply the advanced features of the software to database mangement tasks.
  • Qualified and experienced instructors
  • Easy-to-follow, step-by-step hands-on learning approach
  • Best practices explained and demonstrated
  • Weekday evening and weekend classes available

Learn from the Experts

Get Your Skills Certified

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 in Microsoft Access database management with the course Microsoft Access Programming.

Course Fee

$2800

Course Duration

12 Hours

Course Prerequisites

Course participants should have a basic knowledge of Microsoft Access.

Title of Award

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

Schedule & Online Enrolment
Enquiry/Booking
Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Microsoft Access 2016 for Advanced Users
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
DD6A-19111CCantonese / PC / Central21-Nov22-NovTHU,FRI0930-1230;1400-170012 hours / 4 sessions20191121

$2,800Enrol

DD6A-25C19CCantonese / PC / Central17/1231/12TUE,FRI1900-220012 hours / 4 sessions20191217

$2,800Enrol

DD6A-6D1KCantonese / PC / MongKok01/0208/02SAT1000-1300;1400-170012 hours / 4 sessions20200201

$2,800Enrol

DD6A-24C34CCantonese / PC / Central10/0319/03TUE,THU1900-220012 hours / 4 sessions20200310

$2,800Enrol

DD6A-35C22KCantonese / PC / MongKok01/0415/04WED,FRI1900-220012 hours / 4 sessions20200401

$2,800Enrol

DD6A-14C23CCantonese / PC / Central11/0521/05MON,THU1900-220012 hours / 4 sessions20200511

$2,800Enrol

DD6A-24C19KCantonese / PC / MongKok02/0611/06TUE,THU1900-220012 hours / 4 sessions20200602

$2,800Enrol

DD6A-20011KCantonese / PC / MongKok02/0103/01THU,FRI0930-1230;1400-170012 hours / 4 sessions20200102

$2,800Enrol

DD6A-20031CCantonese / PC / Central25/0326/03WED,THU0930-1230;1400-170012 hours / 4 sessions20200325

$2,800Enrol

DD6A-20051KCantonese / PC / MongKok21/0522/05THU,FRI0930-1230;1400-170012 hours / 4 sessions20200521

$2,800Enrol

DD6A-20071CCantonese / PC / Central13/0714/07MON,TUE0930-1230;1400-170012 hours / 4 sessions20200713

$2,800Enrol

DD6A-20091KCantonese / PC / MongKok10/0911/09THU,FRI0930-1230;1400-170012 hours / 4 sessions20200910

$2,800Enrol

DD6A-20111CCantonese / PC / Central25/1126/11WED,THU0930-1230;1400-170012 hours / 4 sessions20201125

$2,800Enrol

Microsoft Access 2013 for Advanced Users
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
DD3A-6A18CCantonese / PC / Central14/1204/01SAT1000-130012 hours / 4 sessions20191214

$2,800Enrol

DD3A-51C24KCantonese / PC / MongKok10/0120/01FRI,MON1900-220012 hours / 4 sessions20200110

$2,800Enrol

DD3A-13C1CCantonese / PC / Central09/0318/03MON,WED1900-220012 hours / 4 sessions20200309

$2,800Enrol

DD3A-24C34KCantonese / PC / MongKok17/0326/03TUE,THU1900-220012 hours / 4 sessions20200317

$2,800Enrol

DD3A-24C36KCantonese / PC / MongKok07/0423/04TUE,THU1900-220012 hours / 4 sessions20200407

$2,800Enrol

DD3A-6D11CCantonese / PC / Central09/0516/05SAT1000-1300;1400-170012 hours / 4 sessions20200509

$2,800Enrol

DD3A-24C35KCantonese / PC / MongKok26/0504/06TUE,THU1900-220012 hours / 4 sessions20200526

$2,800Enrol

DD3A-20021CCantonese / PC / Central18/0219/02TUE,WED0930-1230;1400-170012 hours / 4 sessions20200218

$2,800Enrol

DD3A-20041KCantonese / PC / MongKok08/0409/04WED,THU0930-1230;1400-170012 hours / 4 sessions20200408

$2,800Enrol

DD3A-20061CCantonese / PC / Central29/0630/06MON,TUE0930-1230;1400-170012 hours / 4 sessions20200629

$2,800Enrol

DD3A-20081KCantonese / PC / MongKok03/0804/08MON,TUE0930-1230;1400-170012 hours / 4 sessions20200803

$2,800Enrol

DD3A-20101CCantonese / PC / Central22/1023/10THU,FRI0930-1230;1400-170012 hours / 4 sessions20201022

$2,800Enrol

DD3A-20121KCantonese / PC / MongKok07/1208/12MON,TUE0930-1230;1400-170012 hours / 4 sessions20201207

$2,800Enrol

In this course, you will learn advanced skills and techniques for making the most of Microsoft Access’ functionality. Check out the course outline to have a better understanding of the advanced topics to be covered in the course.

  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.

You may also be interested in