|
May 04, 2024
|
|
|
|
2022-2023 Catalog [ARCHIVED CATALOG]
|
BOAT 222 - Microsoft Access PREREQUISITES: Demonstrated competency through appropriate assessment or earning a grade of “C” or better in ENGL 083 - Reading Strategies for College and ENGL 093 - Introduction to College Writing , or ENGL 095 - Integrated Reading and Writing or ENGL 075 - Co-Requisite Integrated Reading & Writing , MATH 023 - Essentials of Algebra or MATH 080 - Mathematical Principles . PROGRAM: Business Operations, Applications, and Technology CREDIT HOURS MIN: 3 LECTURE HOURS MIN: 3 DATE OF LAST REVISION: Summer, 2020
Provides “hands-on” experience and familiarizes students with the creation and management of a Microsoft Access database. Uses Access database software to create, modify, query, and report information from a database. Integration of other software applications with Access will be addressed as well. Students are required to demonstrate course objectives through the appropriate Microsoft certification examination.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course, the student will be expected to:
- Create, open, close, and exit a database.
- Identify objects in the navigation pane.
- Demonstrate the ability to build tables using standard database guidelines.
- Create and edit relationships among tables.
- Utilize and refine query tools.
- Maintain, sort, and filter data.
- Create forms using Form Wizard and other design tools.
- Define criteria for record selection.
- Create, modify, and customize tables, forms, and reports.
- Integrate and analyze data by importing, exporting, and linking.
- Demonstrate the ability to apply application parts using blank forms, quick start and templates.
- Automate tasks using macros.
- Manage and secure the database.
- Recognize special and/or advanced software features as they relate to software certifications.
COURSE CONTENT: Topical areas of study include -
- Creating a database table
- Creating relationships between database tables
- Creating a table using a wizard and using Help
- Performing queries and filtering records
- Creating and modifying reports, mailing labels, charts, forms and advanced tables
- Importing and exporting data
- Creating web pages and using database wizards
- Defining relationships
- Using database tools
Course Addendum - Syllabus (Click to expand)
|
|