OAD_COMC130: MS Office Skills II

About Course

Students will learn how to effectively apply presentation and basic database (PowerPoint, Access) applications in the operation of a business.

Students will be able to create and use a simple database to track, manage, and generate business-related reports.

Describe the key components of a Database and their functions
Describe how Databases and the World Wide Web changed how we access and use data
Identify the basic features of Access and PowerPoint
Plan and create an Access Database and create tables and records
Use an Access Database to import and export data
Filter and Sort an Access Database
Query an Access Database and generate reports
Develop a PowerPoint Presentation with a focused message to organize and effectively present a wide variety media types

Course Content

Module I

Topic 1: Information Presentation and Usage

03:24
LO1: Describe the key components of a Database and their functions

00:00
LO2: Define Access and identify the basic features of Access

00:00
LO3: List and explain the key components of Microsoft Access

00:00
LO4: Explain how to Open and Close Databases, as well as how to Open, Close, and Save objects

00:00
LO5: Identify the Names and Functions of the Access Interface

00:00
LO6: Knowledge Check
Case Study: Information Presentation and Usage
Topic 2: Data Management and Assignment Workflow

00:00
LO1: Examine different Table Structures and determine their suitability for various data management tasks

00:00
LO2: List and explain the steps involved in creating Tables from Database and Design View

00:00
LO3: Define Records and how to create Records in Access

00:00
LO4: Describe the techniques to Find and Delete specific records within a Database

00:00
LO5: Knowledge Check
Case Study: Data Management and Assignment Workflow
Topic 3: Importing and Exporting Data from Excel

00:00
LO1: Describe the processes for Importing and Exporting data from Excel by using Access Database

00:00
LO2: Comprehend common issues that occur during Data Import/export and propose solutions

00:00
LO3: Knowledge Check
Case Study: Importing and Exporting Data from Excel
Topic 4: Forms, Queries, and Reports

00:00
LO1: Explain the steps to Create Forms for specific Data Entry Tasks

00:00
LO2: Analyze the effectiveness of Queries in Retrieving relevant data

00:00
LO3: Describe how to design and produce comprehensive Reports that effectively present data

00:00
LO4: Knowledge Check
Case Study: Forms, Queries, and Reports
Topic 5: Presentations with PowerPoint

00:00
LO1: Explain the basic functions of the Microsoft PowerPoint

00:00
LO2: Identify the Names and Functions of the PowerPoint Interface

00:00
LO3: Demonstrate how to Save, Close, Open, and switch between Presentation files

00:00
LO4: Describe how to Integrate Tables, and Charts into PowerPoint slides effectively

00:00
LO5: Understand basic Editing functions and Formatting text in PowerPoint slides

00:00
LO6: Describe how to create a new PowerPoint Presentation

00:00
LO7: Knowledge Check
Case Study: Presentations with PowerPoint
Topic 6: PowerPoint and Time-Based Media

00:00
LO1: Explain the importance of Time-Based Media in enhancing presentations

00:00
LO2: Describe how to add Pictures and Animation in a Presentation

00:00
LO3: Explain how to add Time-Based Media elements in a Presentation

00:00
LO4: Knowledge Check
Case Study: PowerPoint and Time-Based Media
Module Based Quiz

About Course

What Will You Learn?

Course Content

Module I

Topic 1: Information Presentation and Usage

LO1: Describe the key components of a Database and their functions

LO2: Define Access and identify the basic features of Access

LO3: List and explain the key components of Microsoft Access

LO4: Explain how to Open and Close Databases, as well as how to Open, Close, and Save objects

LO5: Identify the Names and Functions of the Access Interface

LO6: Knowledge Check

Case Study: Information Presentation and Usage

Topic 2: Data Management and Assignment Workflow

LO1: Examine different Table Structures and determine their suitability for various data management tasks

LO2: List and explain the steps involved in creating Tables from Database and Design View

LO3: Define Records and how to create Records in Access

LO4: Describe the techniques to Find and Delete specific records within a Database

LO5: Knowledge Check

Case Study: Data Management and Assignment Workflow

Topic 3: Importing and Exporting Data from Excel

LO1: Describe the processes for Importing and Exporting data from Excel by using Access Database

LO2: Comprehend common issues that occur during Data Import/export and propose solutions

LO3: Knowledge Check

Case Study: Importing and Exporting Data from Excel

Topic 4: Forms, Queries, and Reports

LO1: Explain the steps to Create Forms for specific Data Entry Tasks

LO2: Analyze the effectiveness of Queries in Retrieving relevant data

LO3: Describe how to design and produce comprehensive Reports that effectively present data

LO4: Knowledge Check

Case Study: Forms, Queries, and Reports

Topic 5: Presentations with PowerPoint

LO1: Explain the basic functions of the Microsoft PowerPoint

LO2: Identify the Names and Functions of the PowerPoint Interface

LO3: Demonstrate how to Save, Close, Open, and switch between Presentation files

LO4: Describe how to Integrate Tables, and Charts into PowerPoint slides effectively

LO5: Understand basic Editing functions and Formatting text in PowerPoint slides

LO6: Describe how to create a new PowerPoint Presentation

LO7: Knowledge Check

Case Study: Presentations with PowerPoint

Topic 6: PowerPoint and Time-Based Media

LO1: Explain the importance of Time-Based Media in enhancing presentations

LO2: Describe how to add Pictures and Animation in a Presentation

LO3: Explain how to add Time-Based Media elements in a Presentation

LO4: Knowledge Check

Case Study: PowerPoint and Time-Based Media

Module Based Quiz

Final Exam Quiz

Final Exam: MS Office Skills – II

Quick Links

Resources

Support