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

Price: $695.00

Guaranteed to Run

Time: 9:00 am - 4:00 pm
Duration: 2 Days
Language: English

Register Now

Cancellation Policy

What You Get:

Training includes 1 course manual, a Certificate of completion, and a voucher for 30 days of After Training Support

What You Need:

This Course is designed for participants who have little or no knowledge of MS Access.