OAD_COMC130: MS Office Skills II (Professional)

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

00:00
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
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
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
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
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
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
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

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

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

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

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

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

Module Based Quiz

Final Exam Quiz

Final Exam: MS Office Skills – II

Quick Links

Resources

Support