Length:
Course 1: 24 hours (8 weeks). Course 2: 27 hours (9 weeks). Course 3: 27 hours (9 weeks).
Location:
Various approved locations throughout the United States.
Dates:
Courses 1, 2, and 3: April 2005 - December 2005.
Instructional delivery format:
Traditional classroom model
Learner Outcomes:
Course 1: Define database software and terminology; start and exit Access; open a database and view the database window; navigate, enter, and edit records; preview and print a datasheet; get Help; plan a database; create and modify a table; format a datasheet; sort and filter records and find data; create and modify a query; plan and create a form; move and resize controls; modify labels, text boxes, tab order; enter and edit records; insert an image to a form; plan and create a report; group records and change the sort order; add a calculation on the report; align and format controls to improve readability of the report; create mailing labels using Label Wizard; plan and create related tables and lookups; define text fields, number and currency fields, date/time and yes/no fields, and field validation properties; create one-to-many relationships. Course 2: Create select queries in Query Design View and sort a query on multiple fields; develop AND, OR, and crosstab queries; use a query object to create calculated fields; build summary queries; create PivotTables and PivotCharts; understand the form/subform relationship; create subforms using the Form Wizard and queries; modify subforms; add combo boxes, option groups, command buttons, ActiveX controls; use the Database Wizard; import data from an external file and bring it into an Access database; use conditional formatting and grouping controls to apply formatting; add lines and use the Format Painter and AutoFormats to enhance reports; use Access to create Web pages; export data from Access to another file format; compact and repair a database; discuss the seven Access objects and Access relationship types; import XML text files and export data to XML; link data to an Access database; publish and merge data with Word; analyze data with Excel; use SQL server to upsize an Access database; create and add hyperlink fields to interact with an Access database; create pages for interactive reporting, data entry, and data analysis; work in Page Design View to modify the structure of the Web page; publish Web pages to Web servers. Course 3: Add check boxes and toggle buttons controls to improve forms and reports; use conditional formatting in a form; create custom Help; add tab controls and subreport controls; add and modify charts; modify section properties; work with objects; use the Documenter feature; place objects in groups to easily organize objects; modify shortcuts and groups; create a dialog box and pop-up form; create and modify a switchboard form; create, edit, troubleshoot, and run macros; modify actions and arguments contained in macros; create a macro group; set conditional expressions; work with events; customize toolbars; compare macros and modules; create functions; use If statements; document procedures; examine class modules; create sub procedures; troubleshoot modules; convert databases to another version of Access; set passwords to secure information; change startup options; encrypt a database; use the Performance Analyzer tool; split a database using the Database Splitter feature; replicate and synchronize using the Briefcase.
Instruction:
Course 1: Navigating Access 2002; using tables and queries; using forms; using reports; modifying a database structure. Course 2: Creating multiple table queries; developing forms and subforms; sharing information and improving reports; sharing Access information with other office programs; creating data access pages; creating advanced queries. Course 3: Creating advanced forms and reports; managing database objects; creating macros, creating modules; managing the database.
Credit recommendation:
Courses 1, 2, and 3: In the lower division baccalaureate/associate degree category, 2 semester hours as Computer Software Applications (4/05). NOTE: Courses 1, 2, and 3 must all be completed to receive credit. NOTE: These courses are also components of the Introductory or Advanced Microsoft courses listed in this section and, thus, there is overlap in content. Care should be taken, therefore, in the awarding of credit for these courses, if the Introductory or Advanced Microsoft courses have also been completed. Further, a total of 6 semester hours of credit is recommended for the Introductory or Advanced courses or any combination of its component courses.
