Access 2013: Beginning

Audience	This course is designed for individuals interested in learning the skills necessary to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data in Microsoft® Office Access® 2013. This course helps individuals prepare for the Access 2013 Microsoft Office Specialist (MOS) Certification exam.
Description	Upon successful completion of this course, participants will be able to: Navigate within the Microsoft Access application environment and create a simple database. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Create advanced queries, including action queries and parameter queries. Create and format custom reports. Customize Access configuration options.
Prerequisites	To ensure success, participants will need to be familiar with using personal computers, should have experience using a keyboard and mouse, and be familiar with Microsoft® Office Windows® user interface.
Suggested Class Size	Minimum 3 Maximum 12
Course Length	Full day
Table of Contents	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

A lack of English language skills will not be a barrier to admission to and participation in career and technical education programs. Brazosport College shall not discriminate on the basis of race, creed, color, national origin, citizenship status, age, disability, pregnancy, religion, gender, gender identity, genetic information, marital status, veteran status or any other protected class in accordance with applicable federal and state laws. The following person has been designated to handle inquiries regarding the non-discrimination policies: Vice President of Human Resources, 500 College Drive, Lake Jackson, TX, 77566; 979-230-3459; Marshall.Campbell@brazosport.edu