Microsoft Access is a popular, commonly used database program. It is a powerful database management system that functions in the Windows environment. It is a necessary tool for obtaining employment in many occupations, as well as a software package for organizing personal records. Indexes Security, Privacy, Crime, and Laws Relating to Databases Integrating Excel Worksheet Data into an Access Database Creating an Access Database Converting an Excel Worksheet to an Access Database Using the Access Table Reports, Forms, and Publishing Reports to the Web Report Creation Grouping in a Report Reviewing the Report Design Creating and Using Custom Forms Publishing to the Web Enhancing Forms with OLE Fields, Hyperlinks, and Subforms Date, OLE, and Hyperlink Fields Adding and Updating Fields Advanced Form Techniques Creating an Application System Using Macros, VBA, and the Switchboard Manager Creating and Using Macros Creating and Using a Command Button, Combo Boxes, and a Switchboard Linking Excel Worksheets to an Access Database Creating the Database Linking and Using the Linked Worksheets Course Requirements Course Requirements 1. Class attendance is required.
All assignments are due as indicated on the schedule.
All assignments are to be submitted via e-mail. The address will be distributed in class. All assignments must be properly identified. It is imperative that the schedule is maintained in order to insure complete exposure to the material. The two exams cannot be made up without a written explanation.