Access 2016 Level 1 (Basic)

Course Length: 12hrs (2 Days)

Access is Microsoft's flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user.

Course Objectives:
By the end of this 2-day course, you will be comfortable with navigating the Access 2016 interface, creating a new database from scratch, querying a database, performing calculations, generating reports, sharing data, and much more.
You will:
- Learn the Access interface
- Create an Access database
- Work with tables and records
- Sort and filter records, and create lookups
- Query a database and perform calculations in a query
- Create parameter queries and action queries
- Generate reports and add controls
- Design a relational database
- Organize report information, format reports, and include charts and calculated fields
- Import and export data to other applications

Target Student:
All computer users who would like to get up to speed quickly and become familiar with using Access 2016 to create and to query a database, perform calculations, organize information, generate reports, and share data with others effectively.

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