Project Description

Loading...

Welkin Course Codes: DA0I,DD3I,DD6I

Course Description

Microsoft Access is a software platform for building relational databases or web apps to store and retrieve information efficiently. Without needing to write any code, Microsoft Access can conveniently manage your data and organize it for display. The course begins 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 will be able to take advantage of Microsoft Access’ powerful features to manage and monitor data in a practical and efficient manner.
  • 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 mangement with the course Microsoft Access for Advanced Users.

Course Fee

$2400

Course Duration

12 Hours

Course Prerequisites

Course participants should have a 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
Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Microsoft Access 2016 for Beginners
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
DD6I-20121KCantonese / PC / MongKok17/1218/12THU,FRI0930-1230;1400-170012 hours / 4 sessions20201217

$2,400Enrol
Microsoft Access 2013 for Beginners
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名

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. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in