Access - Part 1 (UT-MS-Acc-P1)

Course Description

Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

Course Objectives

In this course, you will create and manage an Access database. You will:

• Navigate within the Access application environment, create a simple database, and customize Access configuration options.
• Organize and manage data stored within Access tables.
• Use queries to join, sort, and filter data from different tables.
• Use forms to make it easier to view, access, and input data.
• Create and format custom reports.

Course Outline

1 - GETTING STARTED WITH ACCESS

• Topic A: Launch Access and Open a Database
• Topic B: Use Tables to Store Data
• Topic C: Use Queries to Combine, Find, Filter, and Sort Data
• Topic D: Use Forms to View, Add, and Update Data
• Topic E: Use Reports to Present Data
• Topic F: Get Help and Configure Options in Microsoft Access

2 - CREATING TABLES

• Topic A: Plan an Access Database
• Topic B: Start a New Access Database
• Topic C: Create a New Table
• Topic D: Establish Table Relationships

3 - CREATING QUERIES

• Topic A: Create Basic Queries
• Topic B: Perform Calculations in a Query
• Topic C: Sort and Filter Data in a Query

4 - CREATING FORMS

• Topic A: Start a New Form
• Topic B: Enhance a Form

5 - CREATING REPORTS

• Topic A: Start a New Report
• Topic B: Enhance Report Layout

6 - PROMOTING QUALITY DATA INPUT

• Topic A: Restrict Data Input Through Field Validation
• Topic B: Restrict Data Input Through Forms and Record Validation

7 - IMPROVING EFFICIENCY AND DATA INTEGRITY

• Topic A: Data Normalization
• Topic B: Associate Unrelated Tables
• Topic C: Enforce Referential Integrity

There are no prerequisites for this course.

Course Information

Length: 2 day

Format: Lecture and Lab

Delivery Method: n/a

Max. Capacity: 16