BA_COMC130: MS Office Skills II (Professional) - Taylor Pro College

BA_COMC130: MS Office Skills II (Professional)

Wishlist Share
Share Course
Page Link
Share On Social Media

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.

What Will You Learn?

  • 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
    06:36
  • LO2: Define Access and identify the basic features of Access
    07:34
  • LO3: List and explain the key components of Microsoft Access
    04:41
  • LO4: Explain how to Open and Close Databases, as well as how to Open, Close, and Save objects
    03:50
  • LO5: Identify the Names and Functions of the Access Interface
    04:02
  • LO6: Knowledge Check
  • Topic 2: Data Management and Assignment Workflow
    02:56
  • LO1: Examine different Table Structures and determine their suitability for various data management tasks
    04:55
  • LO2: List and explain the steps involved in creating Tables from Database and Design View
    07:07
  • LO3: Define Records and how to create Records in Access
    05:44
  • LO4: Describe the techniques to Find and Delete specific records within a Database
    04:13
  • LO5: Knowledge Check
  • Topic 3: Importing and Exporting Data from Excel
    02:24
  • LO1: Describe the processes for Importing and Exporting data from Excel by using Access Database
    09:13
  • LO2: Comprehend common issues that occur during Data Import/export and propose solutions
    05:18
  • LO3: Knowledge Check
  • Topic 4: Forms, Queries, and Reports
    02:47
  • LO1: Explain the steps to Create Forms for specific Data Entry Tasks
    09:14
  • LO2: Analyze the effectiveness of Queries in Retrieving relevant data
    10:17
  • LO3: Describe how to design and produce comprehensive Reports that effectively present data
    07:28
  • LO4: Knowledge Check
  • Topic 5: Presentations with PowerPoint
    03:30
  • LO1: Explain the basic functions of the Microsoft PowerPoint
    02:33
  • LO2: Identify the Names and Functions of the PowerPoint Interface
    08:13
  • LO3: Demonstrate how to Save, Close, Open, and switch between Presentation files
    03:41
  • LO4: Describe how to Integrate Tables, and Charts into PowerPoint slides effectively
    08:09
  • LO5: Understand basic Editing functions and Formatting text in PowerPoint slides
    07:12
  • LO6: Describe how to create a new PowerPoint Presentation
    05:54
  • LO7: Knowledge Check
  • Topic 6: PowerPoint and Time-Based Media
    02:57
  • LO1: Explain the importance of Time-Based Media in enhancing presentations
    04:18
  • LO2: Describe how to add Pictures and Animation in a Presentation
    09:56
  • LO3: Explain how to add Time-Based Media elements in a Presentation
    12:06
  • LO4: Knowledge Check
  • Module Based Quiz

Final Exam Quiz

Taylor Pro College

Learning often happens in classrooms
but it doesn’t have to.

1-877-860-7627
info@taylorprotraining.com

Want to receive push notifications for all major on-site activities?

✕