Course Number and Title: OAT 151 Access Level I
This course covers the fundamental concepts of designing and developing database skills necessary to be successful within an organization. Through project-based learning students build their technical knowledge of manipulating query data, developing forms, and reinforce problem-solving abilities through data analysis.
- Plan, design, and prepare documents. (CCC 1, 2; PGC OAT 1, 2, 3; GBT 1, 2, 4, 5, 6)
- Use appropriate software for completion of projects. (CCC 2, 4; PGC OAT 1, GBT 1, 2, 4, 5, 6)
- Develop critical thinking and problem solving skills. (CCC 1, 2; PGC OAT 3; GBT 1, 2, 3, 4, 5, 6)
- Identify content and organization of application software. (CCC 1, 2; PGC OAT PGC 1, 3; GBT PGC 1)
- Display file management skills. (CCC 1, 2, 4; PGC OAT 3; GBT 1)
Upon completion of this course, the student will:
- Plan, design, and prepare documents.
- Create and save databases.
- Navigate databases.
- Select and edit text.
- Create fields, records, tables, and queries.
- Move and copy text, field, and records.
- Design, modify, and print forms and reports.
- Apply page numbering
- Create labels.
- Create text boxes.
- Designate data types.
- Move and resize fields.
- Create lookup columns.
- Use input masks.
- Create conditional formats.
- Prevent duplicate entries.
- Create default values.
- Define relationships.
- Use appropriate software for completion of projects.
- Integrate database with alternative data sources.
- Create queries.
- Create mailing labels.
- Create subsets of data which meet specific criteria.
- Sort data.
- Develop critical thinking and problem solving skills.
- Relate and devise solutions to real-world business situations.
- Use case-study scenarios to develop business databases.
- Create and modify mailing labels.
- Develop forms.
- Create and format reports.
- Identify content and organization of application software.
- Manipulate multiple applications simultaneously.
- Import and export files.
- Link multiple databases.
- Convert a database from a previous version of Access.
- Use a browser to interact with the database.
- Display file management skills.
- Create files and folders.
- Manipulate files, folders, and paths.
Calculated using the following weighted average
Percentage of final grade
Summative: Concept Exams (14) (Equally weighted)
Formative: Pre-Check & Tutorials (Equally weighted)
Formative: Assignment Chapter Projects and Skill Checks (Equally weighted)
Summative: Unit Project Evaluations (3) (Equally weighted)
- Apply clear and effective communication skills.
- Use critical thinking to solve problems.
- Collaborate to achieve a common goal.
- Demonstrate professional and ethical conduct.
- Use information literacy for effective vocational and/or academic research.
- Apply quantitative reasoning and/or scientific inquiry to solve practical problems.
- Produce the documents necessary for a functioning business office.
- Demonstrate accurate and efficient keyboarding skills.
- Integrate office-related skills to function in a professional manner within the workplace.
- Use diverse research methods and information sources to complete a variety of business documents.
- Integrate professional, ethical, and legal standards into business practice.
- Employ the various theories of management and marketing in a business.
- Apply the principles of human resource management to organizations.
- Evaluate the actions taken to acquire and retain customers.
- Measure and track financial performance of an organization.
- Analyze and apply the strategic management process to organizations.