|
Description:
An introduction to application development using MS-Access. Includes development
of tables, forms, queries, reports, macros, and menus needed to support the
application.
Course Objectives:
Upon successful completion of this course, students will be able to:
- Explain the fundamental principles of application design [COMMUNICATE]
- Use MS Access to build a student designed application. [REASON]
- Describe how Access integrates with enterprise systems. [COMMUNICATE]
- Given a database design and a few pre-built entities, build the
following components of an Access application: [REASON]
- Tables to store data;
- Forms and sub-forms for data entry into tables;
- Reports that display data in appropriate groups and formatting;
- Queries that assemble data from several tables for use with forms
and reports;
- HTML Documents created from custom queries and exported to the Web;
- Modules and Event Procedures with VBA code to accomplish specific tasks;
- Menus for easy access to the various parts of the application.
Click this link to view the course syllabus:
CIS 253 Syllabus
Clicking on the icons/links to the right will allow you to download the selected database. You
will need Microsoft Access in order to open these files. If you don't have this software, you
may download a free trial by clicking the following link:
Microsoft Access 2010
My Reflection on this Classs:
I enjoyed this class immensely, as it went hand-in-hand with CIS 250. I learned to
use Microsoft Access in ways I never dreamed of before (as I had only been a "user").
It was also very awesome to see my newly learned theory and design knowledge so
readily applied to an actual application.
|
