CIT 606 - Database Management: Access
1 Lecture Hours
Prerequisites: Basic skills using a personal computer and operating system and some basic exposure to Microsoft Office.
This course is an introduction to Microsoft Access. Topics include basic database concepts, creating a simple database, navigation, sorting and searching, creating forms, queries, reports and labels. This course is graded on a pass/fail basis.
Upon successful completion of the course, the student will:
- Design a relational database using tables, fields, field properties, primary keys, foreign keys and relationships.
- Demonstrate the ability to navigate, sort, filter and add/edit/delete records.
- Construct queries using fields in one or more tables.
- Build queries for navigating, sorting, filtering and adding/editing/deleting field data.
- Construct forms for users to enter record data.
- Demonstrate the proper use of forms to navigate, sort, filter and add/edit/delete field data.
- Produce formatted reports and labels through the sorting and filtering of field data.
- Database structure definition and creation
- Data entry and editing
- Searching, sorting and filtering data
- Form design and use
- Report and label design
- Query construction
- Print options for tables, forms, reports and queries
Textbooks/materials, current and appropriate software, multimedia for lecture and demonstration as required by instructor; access to the Internet.
Students who successfully complete this course acquire general knowledge, skills and abilities that align with CCAC’s definition of an educated person. Specifically, this course fulfills these General Education Goals: Approved By: Bullock, Quintin Date Approved: 03/15/2019
Course and Section Search
Add to Portfolio (opens a new window)