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:
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

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

Client Address

Client City, Client Province