|
Sep 07, 2024
|
|
|
|
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 None
Prerequisite(s): CAPL 1010 or instructor consent. Corequisite(s): None Recommendation: None
Major Content
- Database concepts and terminology
- Building a relational database
- Database and table modifications
- Query a database
- View/organize/locate information
- Calculated controls
- Calculations in a Query
- Cross tab query
- Find duplicates and unmatched queries
- Indexes
- Integrate information from other applications
- Join tables
- Look-up field in table
- Multi-table Query
- Mailing labels
- Action queries
- Advanced table relationships
- Automating tasks with macros
- Create custom forms and reports
- Create form and reports
- Sharing, integrating, and analyzing data
Learning Outcomes At the end of this course students will be able to:
- Create and modify databases, forms, and reports
- Define table relationships
- Filter data in a table and form
- Plan and design custom forms and report
- Create simple and complex queries
- Enhance table design
- Automate tasks with macros
- Secure a database
Competency 1 (1-6) None Competency 2 (7-10) None Courses and Registration
Add to Portfolio (opens a new window)
|
|