| |
Oct 23, 2026
|
|
|
|
|
BUS 1119 - Database Management Using Microsoft Access
Credits: 3
Catalog Description
This comprehensive course focuses on the design and creation of databases. Students will learn how to create tables, queries, forms, and reports. Course topics also include macros, Visual Basic for Applications programming, creation of dialog boxes, database import and export procedures, and designing the user interface with navigation forms. After successfully completing this course, the student will have been introduced to the majority of the database procedures found in the Microsoft Office Specialist (MOS) Access certification exam.
Recommended Skills, Abilities, or Coursework: BUS 1112
Additional fee to student: No
Learner Outcomes
- Design and create a database and define table relationships.
- Create a variety of database queries.
- Create forms using form tools and custom form techniques.
- Create custom reports.
- Import, export, link, analyze, and secure data.
- Automate tasks with macros and use VBA code to modify existing Access objects.
Major Areas of Course Content
- Creating a Database
- Building a Database and Defining Table Relationships
- Maintaining and Querying a Database
- Creating Forms and Reports
- Creating Advanced Queries and Enhancing Table Design
- Using Form Tools and Creating Custom Forms
- Creating Custom Reports
- Sharing, Integrating, and Analyzing Data
- Using Action Queries and Advanced Table Relationships
- Automating Tasks with Macros
- Using and Writing Visual Basic for Applications Code
- Managing and Securing a Database
Credit for Prior Learning Options
Course-Specific Exam, Credit by Portfolio Review
Credit for Prior Learning Option Procedure(s)
Students will be responsible for reviewing the learner outcomes and will take all unit exams and performance reviews. Students will be responsible for reviewing the learner outcomes, complete projects, and submit a portfolio of work completed.
Add to Portfolio (opens a new window)
|
|
