Topic 3: Importing and Exporting Data from Excel - Taylor Pro College
Hello! How can I Assist you
today?

Chat with Eddy!

Hello! How can I assist you today?
clear conversation
Course Content
Module I
0/42
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
15:00
Case Study: Information Presentation and Usage
15:00
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
15:00
Case Study: Data Management and Assignment Workflow
15:00
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
15:00
Case Study: Importing and Exporting Data from Excel
15:00
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
15:00
Case Study: Forms, Queries, and Reports
15:00
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
15:00
Case Study: Presentations with PowerPoint
15:00
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
15:00
Case Study: PowerPoint and Time-Based Media
15:00
Module Based Quiz
01:00:00
Final Exam Quiz
0/1
Final Exam: MS Office Skills - II
01:15:00
OAD_COMC130: MS Office Skills II
Join the conversation
Previous
Next
0% Complete