Back to All Events

Microsoft Access: Part 1


Microsoft Access: Part 1

February 7 - 8, 2018 (two days)
CHL Computer Lab No. 2
1103 Balch Blvd., Stennis Space Center, Room 1004

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Course Outline:

1.  Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database

2.   Working with Table Data
Modify Table Data Sort & Filter Records
Work with Subdatasheets
Create Lookups

3.  Querying a Database
Join Data from Different Tables in Query
Sort and Filter Data in a Query
Perform Calculations in a Query

4. Creating Flexible Queries
Create Parameter Queries
Create Action Queries

5.  Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print

6.  Customizing the Access Environment
The Access Options Dialog Box

7. Designing a Relational Database
Relational Database Design
Create and Import Tables
Create Table Relationships

8.  Joining Tables in Queries
Create Query Joins
Join Tables With No Common Fields
Relate Data within a Table

9.  Importing and Exporting Data
Import Data into Access
Export Data to Text File Formats

10. Advanced Reporting
Organize Report Information
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report

 

Earlier Event: February 6
Introduction to QGIS
Later Event: February 21
Excel 2013 Intermediate