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