Microsoft® Access 2013 Crash Course: Learn Access in Two Days!
Open Enrollment Course Dates: TBA
Course Length: 2 days
Delivery: Instructor Led/Group Live
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.
- 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
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
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
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
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.