CMAP 1815 Database Applications:

This course instructs students in the use of database programs on microcomputers. Business applications are included to prepare students to use database software in the business world. The topics covered include query and report generation, switchboards, access basics, and customized applications. (3 lect.)

Credits

3 credits

Major Topics

• Fundamental Database Operations
• The Database Concept
• The Access Environment
• Data File Creation
• Data File Queries
• Data File Order and Search
• Advanced Queries and OLE Objects
• Data File Changes
• Forms, Reports, and Labels
• Multiple files and Relations
• Macros
• Planning the User Interface
• Creating Control Tables
• Creating a Switchboard
• Creating Dialog Boxes

Outcomes

In order to successfully complete this course, the student will:

1. Create a simple database system.

2. Use the terminology associated with Database Management System use.

3. Create and modify the structure of a database table.

4. Perform multiple sorts on fields and locate records

5. Write expressions and conditions using the various operators and functions and enter conditions into a query.

6. Use summary statistics commands in conjunction with a database file.

7. Replace field contents on a selective basis, and delete, recall, and purge records.

8. Design and create forms, reports, and labels.

9. Use multiple files and create relationships between and among them.

10. Incorporate the use of macros and Visual Basic for Applications to customize a database by creating a switchboard.

11. Design appropriate dialog boxes within a switchboard

Other Information

Any information placed here must be adhered to by all instructors:

Contact on-campus instructor for suggested textbook for the course.