Course Descriptions & Syllabi



Find complete words only

Table of Contents | Areas of Study | Business Office Systems | BOFF235 syllabus

Printer Friendy Version


COURSE NUMBER: BOFF235
COURSE TITLE:Access II
DIVISION:Business
IAI CODE(S):
SEMESTER CREDIT HOURS:3.0
DELIVERY MODE:

COURSE DESCRIPTION:
An advanced course to further develop database skills.  Topics include useful features in forms and reports, macros, database utilities, and linking to other documents. Topics include creating a more user-friendly input form, managing and changing data, Access tools, analyzing and reporting data, flitering data in a linked table, and sharing a database with others.

PREREQUISITES:
BOFF226

NOTES:

COURSE OBJECTIVES / GOALS:
  • To acquaint students with the concepts of:
    •  Advanced Tables Structure
    • Relationships and lookup fields
    • Creating and Modifying Forms
    • Advanced Query Techniques
    •  Creating custom forms
    •  Creating custom reports
    • Access tools
    • Automating, Customizing, and Securing Access
    • Integrating Access Data.

    <\/li>

TOPICAL OUTLINE:
  •  Designing the Structure of Tables
    • Data Types
    • Field Size
    • Validation Rules and Text
    • Input Masks
  • Building Relationships and Lookup Fields
    • Understanding Join types
    • Creating indexes
    • Normalizing the database
  •  Advanced Filters
  • Queries
    •  Modifying Join Properties in a Query
    • Creating Subqueries
    • Parameter Queries
    • Action Queries
  • Reports
    •  Creating custom reports
    •  Formatting reports
    • Grouping
    • Adding Graphics
    • Calculating Totals and Averages
    • Embedding a Subreport
  • Using Access Tools
    • Using templates
    • Using Table analyzer
    • Performance analyzer
    •  Splitting a database
  • Customizing and securing Access
    • Creating, editing and deleting macros
    • Creating a navigation form
    • Customizing Access Environment and Ribbo
    • Creating ACCDE database file
  •  Integrating Access
    •  Importing Data
    • Linking Data
    • Exporting data
    • Publishing Objects as PDF or XPS files
    • Summarizing data in PivotTables and PivotCharts
  • Forms
    • Create custom forms
    • Adding calculations to forms
    • Adding graphics to forms
    • Creating subforms




TEXTBOOK / SPECIAL MATERIALS:
See bookstore website for current book at http://www.dacc.bkstr.com
Flash Drive


EVALUATION:
A point system will be used to determine student grades.  Point values will be assigned to all homework, tests, projects, and final exam.  The following percentages will be used in determining grades:

93%-100% = A
86%- 92% = B
77%- 76% = C
70%- 76% = D
69%-Below = F

BIBLIOGRAPHY:

REVISION:
Fall 2012

RECORD UPDATED:
2012-12-11 09:56:00