Jul 18, 2024  
2018-2019 Course Catalog 
2018-2019 Course Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CAPL 1027 - Microsoft Access

Credits: 3
Hours/Week: Lecture 3 Lab None
Course Description: This course covers the newest version of database software that allows the student to create and build databases, define table structures, maintain and query databases, create and use forms and reports, enhance databases using advanced tools, integrate, analyze, and automate tasks, and secure a database. The students will apply critical thinking and problem-solving skills to real-life database projects.
MnTC Goals

Prerequisite(s): CAPL 1010  or CSCI 1020 
Corequisite(s): None
Recommendation: None

Major Content
  1. Database concepts and terminology
  2. Building a relational database
  3. Database and table modifications
  4. Query a database
  5. View/organize/locate information
  6. Calculated controls
  7. Calculations in a Query
  8. Cross tab query
  9. Find duplicates and unmatched queries
  10. Indexes
  11. Integrate information from other applications
  12. Join tables
  13. Look-up field in table
  14. Multi-table Query
  15. Mailing labels
  16. Action queries
  17. Advanced table relationships
  18. Automating tasks with macros
  19. Create custom forms and reports
  20. Create form and reports
  21. Sharing, integrating, and analyzing data

Learning Outcomes
At the end of this course students will be able to:

  1. Create and modify databases, forms, and reports
  2. Define table relationships
  3. Filter data in a table and form
  4. Plan and design custom forms and report
  5. Create simple and complex queries
  6. Enhance table design
  7. Automate tasks with macros
  8. Secure a database

Competency 1 (1-6)
Competency 2 (7-10)

Courses and Registration

Add to Portfolio (opens a new window)