The focus of this class is the design of an Access database. You will learn how to create tables and basic forms, basic queries, and basic reports. We will cover planning a database, finding records, editing data, and using sorting and filters. Input masks and validation will be covered to help get correct information into your database.
Class Outline
Unit 1: Getting started
- Topic A: Orientation
- Topic B: Create a simple Access database
- Topic C: Get help and configure options
Unit 2: Working with Table Data
- Topic A: Modify table data
- Topic B: Sort and filter records
Unit 3: Querying a Database
- Topic A: Create basic queries
- Topic B: Sort and filter data in a query
- Topic C: Perform calculations in a query
Unit 4: Using Forms
- Topic A: Create basic Access forms
- Topic B: Work with data on Access forms
Unit 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
- Topic E: Organize report information
- Topic F: Format reports
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.