Access 2013: Intermediate

Audience	This course is designed for individuals interested in learning the skills necessary to implement the relational database design process, write advanced queries, structure existing data, share data across applications, and customizes reports 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: Design a relational database. Join tables to retrieve data from unrelated tables. Organize a database for efficiency and performance, and to maintain data integrity. Share data among Access and other applications. Customize reports to organize the displayed information and produce specific print layouts.
Prerequisites	To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft® Windows® experience Microsoft® Office Access® 2013 Beginning
Suggested Class Size	Minimum 3 Maximum 12
Course Length	Full day
Table of Contents	Lesson 1: Designing a Relational Database Topic A: Relational Database Design Topic B: Create a Table Topic C: Create Table Relationships Lesson 2: Joining Tables Topic A: Create Query Joins Topic B: Join Tables That Have No Common Fields Topic C: Relate Data within a Table Topic D: Work with Subdatasheets Topic E: Create Subqueries Lesson 3: Organizing a Database for Efficiency Topic A: Data Normalization Topic B: Create a Junction Table Topic C: Improve Table Structure Lesson 4: Sharing Data Across Applications Topic A: Import Data into Access Topic B: Export Data to Text File Formats Topic C: Export Access Data to Excel Topic D: Create a Mail Merge Lesson 5: Advanced Reporting Topic A: Organize Report Information Topic B: Format Reports Topic C: Include Control Formatting in a Report Topic D: Add a Calculated Field to a Report Topic E: Add a Subreport to an Existing Report

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