Microsoft® Access 2013 Crash Course: Learn Access in Two Days!

Open Enrollment Course Dates:  TBA

Click here to pre-register for this course now!

Course Length: 2 days
Delivery: Instructor Led/Group Live
PDUs: 14
PMI Activity ID# 000357
Prerequisites: Familiarity with the Windows operating system.
Course Level: Introductory through advanced
Course Fee: $595

Course Hours: 8:30 a.m. -4:15 p.m.

Course Description: This course combines Levels I and II for those participants who need to go beyond the basics and get started with a current or upcoming database project.

Course Objectives:

  • Identify the basic components of an Access database.
  • Build the structure of a database.
  • Manage data in tables.
  • Query a database.
  • Design forms.
  • Generate reports.
  • Streamline data entry and maintain data integrity
  • Join tables to retrieve data from unrelated tables
  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
  • Improve forms.
  • Customize reports to organize the displayed information and produce specific print layouts.
  • Share data between Access and other applications

Course Content:
Day One
Lesson 1: Getting Started with Access Databases

Identify the Elements of the Access 2010 Interface
Identify the Components of a Database
Examine the Relational Database Design Process

Lesson 2: Building the Structure of a Database
Create a New Database
Create a Table Using the Design View
Manage Tables
Establish Table Relationships

Lesson 3: Managing Data in a Table
Modify Table Data
Sort and Filter Records
Work with Subdatasheets

Lesson 4: Querying a Database
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping

Lesson 5: Designing Forms
Create a Form
Modify the Design of a Form
View and Edit Data Using an Access Form

Lesson 6: Generating Reports
Create a Report
Add a Control to a Report
Format the Controls in a Report
Enhance the Appearance of a Report
Prepare a Report for Print

Day Two
Lesson 1: Controlling Data Entry

Constrain Data Entry Using Field Properties
Establish Data Entry Formats for Entering Field Values
Create a List of Values for a Field

Lesson 2: Joining Tables
Create Query Joins
Join Tables with No Common Fields
Relate Data Within a Table

Lesson 3: Creating Flexible Queries
Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries

Lesson 4: Improving Forms
Restrict Data Entry in Forms
Organize Information with Tab Pages
Add a Command Button to a Form
Create a Subform
Display a Summary of Data in a Form
Change the Display of Data Conditionally

Lesson 5: Customizing Reports
Organize Report Information
Format Reports
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge

 

Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.

For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Concerns regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.