Access 2013 Level 1 (Basic)

On completion of course, participants will be able to design and modify tables, create relationships, use queries, design and modify forms and reports.

Course Outline

Course Length: 12hrs (2 Days)

A relational database application such as Microsoft Access 2013 can help you collect and manage large amounts of data. You can use it as a personal data management tool or you can build easy to use applications for an entire organization.

Learning Objectives:
In this course, you will learn how to use Access 2013 to manage your data. You will:
- Create a new database
- Design and construct tables
- Design forms and reports
- Create queries to join, filter, and sort data

Target Student:
This course is designed for individuals who require the use of a powerful yet simple database program. Some concept of data organization is useful, although no previous experience is necessary. 

Course Outline:
DAY 1
Section 1: Getting Started
Creating, Opening and Saving a Database
Signing In
Learning Information on Database Terminology

Section 2: Your First Database
Searching for Objects
Opening Various Database Objects
Changing Object Views
Managing Objects
Learning Information on Security Warnings and Data Relationships

Section 3: Working with Tables and Records
Creating a Table
Adding and Editing Database Records
Searching and Browsing Records
Deleting and Printing Records
Different Table Views

Section 4: Formatting Tables
Selecting Data
Changing the Size of Rows and Columns
Applying Text Formatting and Fill Color
Applying Gridlines
Performing a Spell Check

Section 5: Creating Forms
Creating Forms from an Object
Creating Forms using the Wizard
Creating Forms from Scratch
Using Form Views 2

Section 6: Formatting Forms
Changing the Theme of a Form
Using the Format Painter
Adding Fields to a Form
Adding Controls and Images to a Form

DAY 2
Section 7: Creating Basic Queries
Creating a Query with the Wizard
Running, Sorting and Filtering a Query
Using and Applying Query Views
Different Types of Queries Available

Section 8: Creating Advanced Queries
Using Parameter Queries
Multiple Table Queries
Make-Table Queries
Appending, Deleting and Updating Queries

Section 9: Managing Data
Viewing Relationships
Viewing Object Dependencies
Enforcing Referential Integrity
Enforcing Cascade Update and Deletion
Types of Relationships and Referential Integrity

Section 10: Creating Reports
Creating a Report from an Object
Creating a Report using the Wizard
Creating a Report from Scratch
Using Report Views
Printing Reports

Section 11: Formatting Reports
Changing the Theme of Reports
Using the Format Painter
Grouping and Sorting Data in Reports
Adding Controls, Images, Logos, Page Numbers, Headers & Footers to Reports 3

Section 12: Managing Your Database
Compacting and Repairing a Database
Encrypting a Database Using a Password
Backing up a Database
Exporting a Database and Database Objects
Printing Database Objects

Section 13: Customizing the Interface
Collapsing and Pinning the Ribbon
Customizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Tabs
Resetting Changes made to the Interface

Training Location

On-site
Client Address

Client City, Client Province
Canada