| Back |
CBA 134A Database Management in Access
|
Credit Hours: 3 Effective Term: Fall 2015 SUN#: None AGEC: None |
Credit Breakdown: 2 Lectures, 3 Labs Times for Credit: 1 Grading Option: A, B, C, D, F Cross-Listed: |
Description: Design and create relational databases. Produce the following database objects a query, report and form on the data and publish to the Web. Skills learned will cover the Core Level skills for Microsoft Office Specialist (MOS) Certification: Microsoft Office Access 2013.
Prerequisites: Basic Windows and file management knowledge.
Corequisites: None
Recommendations: None
Prerequisites: Basic Windows and file management knowledge.
Corequisites: None
Recommendations: None
| Measurable Student Learning Outcomes |
|---|
| 1. (Synthesis Level) Design and create relational databases.
2. (Synthesis Level) Modify a database design. 3. (Application Level) Implement- Define relationships between tables. 4. (Application Level) Use logical operators and arithmetic expressions in queries, filters, and reports. 5. (Application Level) Use multiple tables in a database for calculations and queries. 6. (Synthesis Level) Design a Customized form for efficient input of data using OLE Fields, Hyperlinks, and Sub forms. 7. (Application Level) Use printer to obtain hard copy output of database objects such as reports and file structures. 8. (Synthesis Level) Create formatted reports with controls. 9. (Synthesis Level) Integrate database with other applications. 10. (Synthesis Level) Manage-Maintain a database Using the Design and Update Features of Access. 11. (Knowledge Level) Duplicate - Visual Basic for Applications (VBA) code. |
| Internal/External Standards Accreditation |
|
Microsoft Office Specialist(MOS) 2013 Access Exam standards can be found at the following link:
Access Exam 77-424 -- MOS Cert https://www.microsoft.com/learning/en-us/exam-77-424.aspx |