BSTEC 170 - Microsoft Access

5 Credits

This course introduces students to beginning and intermediate features of Microsoft Access. The student will learn how to plan and create relational databases, including: Create and validate tables, apply and enforce referential integrity between tables, create simple, filtered, and calculated queries, create forms with related subforms, create reports with group subreports with calculated field, import and export data from other databases and MS Office application, and managing and backing up databases.

Course Note Basic computer knowledge highly suggested.
FeesCF

Quarters Typically Offered
Winter Day
Designed to Serve Students who will create, update, or maintain Access databases in an office environment.
Active Date 20201208T18:00:08

Grading Basis Decimal Grade
Class Limit 30
Contact Hours: Lecture 55
Total Contact Hours 55
Degree Distributions:
ProfTech Course Yes
Restricted Elective Yes
PLA Eligible Yes

Course Outline

Creating a Database.
Building a Database and Defining Table Relationships.
Maintaining and Querying a Database.
Creating Forms and Reports.
Creating Advanced Queries and Enhancing Table Design
Using Form Tools and Creating Custom Forms.
Creating Custom Reports.
Sharing, Integrating, and Analyzing Data.

Student Learning Outcomes
Students will demonstrate mastery of skills required to create a new Access database.

Students will demonstrate ability to manage data in an Access database, including setting up relational tables, referential integrity, and data validation.

Students will demonstrate the ability to set up and execute queries using specific query criteria including calculated queries.

Students will demonstrate the ability to create database forms and reports from multiple tables, including aggregation functions.

Students will demonstrate the ability to import and export data to and from an Access database.