Course Abstract Details

XOFFC-165, Introduction to Access

Credits: 3

Course Description

OFFC-165, Introduction to Access, develops students' ability to create, edit, manage, and search databases, produce reports, and learn basic concepts of database programming using the Microsoft Access software package. Upon successful completion of this course students will be prepared to complete the Microsoft Access 2010 certification exam. It is suggested that students possess basic technology skills to be successful in this course. Prerequisite: exemption/completion of READ-091. Three lecture hours each week. Three credits. Three billable hours.

Course Objectives and Grading Information

OBJECTIVES: Upon successful completion of this course, students will be able to:

1.Understand informational databases using Microsoft Access software. Specific skills include: identify database design, organize objects, use templates, create and define fields in tables, import data from other applications, understand primary key fields, print tables, create queries, forms and reports, and close and save database files. (General Education Goal #4, Program Goal # 6)
2.Sort and query databases using Microsoft Access software. Specific skills include: create table relationships, sort table records, create, run, sort, save and print queries, specify numeric criteria in queries, use wildcards, create calculated fields, and calculate statistics in queries. (General Education Goal #4, Program Goal #6)
3.Understand forms, filters, and reports using Microsoft Access software. Specific skills include: create, modify, and use forms, filter records, and create, modify, and format reports. (General Education Goal #4, Program Goal #6)
4.Enhance tables using advanced features in Microsoft Access software. Specific skills include: manage existing tables and relationships, edit data types, create lookup fields, set field properties, and create validation rules. (General Education Goal #4, Program Goal #6)
5.Create and edit advanced queries using Microsoft Access software. Specific skills include: create calculated fields in queries, use aggregate functions, create crosstab and parameter queries, and create append, delete and update queries. (General Education Goal #4, Program Goal #6)
6.Customize forms and reports using Microsoft Access software. Specific skills include: create and format forms in design view, add controls, add messages, revise tab order, create and edit reports in design view, add controls and sort and group reports.

Learning Goals

The abbreviations in parentheses represent Learning Goals which have been identified for this course and program of study:

Bookmark, Share, or Email this page Get Help