Access 2013: Part 2
COURSE OUTLINE:
Audience
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.
Lesson 1: Designing a Relational Database
- Topic A: Relational Database Design
- Topic B: Create a Table
- Topic C: Create Table Relationships
- 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
- Topic A: Data Normalization
- Topic B: Create a Junction Table
- Topic C: Improve Table Structure
- 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
- 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