Microsoft Office Access 2013: Level 1 Training Course

Home Training Microsoft Office Access 2013: Level 1

Microsoft Office Access 2013: Level 1 Training


We offer private customized training for groups of 3 or more attendees.
get pricing information
Course Description
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2013, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. Course Length: 1 Days Course Tuition: $250 (US)

Prerequisites
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Course Content

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Topic C: Create Lookups

Lesson 3: Querying a Database

Topic A: Join Data from Different Tables in a Query

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Create Action Queries

Topic C: Create Unmatched and Duplicate Queries

Topic D: Summarize Data

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Lesson 6: Customizing the Access Environment

Topic A: The Access Options Dialog Box

Appendix A: Microsoft Office Access 2013 Exam 77-424

Appendix B: Microsoft Access 2013 Common Keyboard Shortcuts

Technical Training Courses

Software engineer/architect, System Admin ... Welcome!

Business Training Courses

Project Managers, Business Analysts, Paralegals ... Welcome!

Upcoming Classes

Gain insight and ideas from students with different perspectives and experiences.