CA 118C Access Basics

Lecture Hours: 2
Credits: 2

Introduces and reinforces database basics for forms design; data entry; queries; tables; reports; multiple table and action queries; forms and sub-forms; and importing, exporting, and publishing data.

Prerequisite: BA 131, CA 100, or CIS 101; or consent of instructor. (All prerequisite courses must be completed with a grade of C or better).
Student Learning Outcomes:

Create basic tables and enter data in those tables.
Modify tables.
Generate queries and store data.
Create basic forms and auto-forms.
Produce basic reports.
Create basic multiple table and action queries.
Create and modify forms and sub-forms.
Import, export, and link data.
Modify report content and format.

Content Outline

Introducing the Database Software
Generating Basic Forms and Entering Data
Creating and Modifying Tables
Creating Basic Formulas
Producing Basic Reports
Sorting Data
Generating Queries
Creating Multiple Table Queries
- Creating and sorting queries
- Developing “AND” and “OR” queries
- Creating calculated fields, summary queries, and crosstab queries
- Creating action queries
Developing Forms and Sub-forms
- Understanding the form/sub-form relationship
- Creating and modifying sub-forms
- Using combo boxes, option groups, and command buttons
Importing Information and Improving Reports
- Using the database wizards, including labels
- Importing and exporting data
- Formatting reports
Sharing Database Information
- Importing, linking, merging, and exporting data
- Publishing