Course Abstract Details

XOFFC-265, Advanced Access

Credits: 3

Course Description

OFFC-265, Advanced Access, allows students to perform advanced database operations to forms and reports, work with macros, pivottables and pivotcharts, integrate with other applications, administrate and secure databases, and write SQL statements using the Microsoft Access software package. Prerequisite: exemption/completion of OFFC-165. 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.Create advanced forms and reports using Microsoft Access software. Specific skills include: create, format, and convert split forms and subforms, create and modify subreports, and create a report based on parameter queries. (General Education Goal #4, Program Goal # 6)
2.Create macros, pivottables, and pivotcharts using Microsoft Access software. Specific skills include: create standalone, multiple action, embedded, and group macros, create and edit pivottables from a query, and create a pivotchart from a pivottable. (General Education Goal #4, Program Goal #6)

3.Integrate Access with other applications using Microsoft Access software. Specific skills include: import data from Word, Excel and other Access databases, insert an Excel chart into a report, export data to Word, Excel and HTML and XML files, and use mail merge to integrate Word and Access. (General Education Goal #4, Program Goal #6)

4.Administer databases using Microsoft Access software. Specific skills include: compact, repair, convert, replicate, and backup databases, use analysis tools, add action tags, and, modify views and behaviors. (General Education Goal #4, Program Goal #6)

5.Secure databases and write SQL statements using Microsoft Access software. Specific skills include: utilize the trust center, database splitter, encrypt and decrypt databases, create a locked database, create and modify queries in SQL view, and create union and calculated field queries using SWL aggregate functions. (General Education Goal #4, Program Goal #6)

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