Access 2013 Level 1 (Basic)

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