Microsoft Office Training

Microsoft Office Training allows you to create, edit, share, and even collaborate on files with more ease than ever before. In this course, you’ll learn in the Microsoft Office Training how to take advantage of the many features offered online in Word, Excel, PowerPoint, Outlook and Access
For more Details find this link : https://en.wikipedia.org/wiki/Microsoft_Office

Microsoft Office Training Outline

  Word 2016 – Part 1 

(Microsoft Office Training )

Duration: Classroom Learning – 1 Day(s)

Overview 

In this course, you’ll learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

 

Who Should Attend

The Microsoft Office Training course is intended for students who want to learn basic Word 2016 skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.

 

At Course Completion

Upon successful completion of this course, students will be able to: – create a basic Word document by using Microsoft Office Word 2016. – edit a document by using Word. – Format text in a Word document. – Format paragraphs in a Word document. – insert a table in a Word document. – insert special characters and graphical objects in a Word document. – control the page setup and appearance of a Word document. – proofread documents for accuracy.

 

Suggested Next Steps

Word 2016 – Part 2

 

Outline :

• Lesson 1: Getting Started with Word
• Identify the Components of the Word Interface
• Create a Word Document
• Help
• Lesson 2: Editing a Document
• Find and Select Text
• Modify Text
• Find and Replace Text
• Lesson 3: Formatting Text and Paragraphs
• Apply Character Formatting
• Align Text Using Tabs
• Display Text as List Items
• Control Paragraph Layout
• Apply Borders and Shading
• Apply Styles
• Manage Formatting
• Lesson 4: Adding Tables
• Table
• Modify a Table
• Format a Table
• Convert Text to a Table
• Lesson 5: Managing Lists
• Sort a List
• Renumber a List
• Customize a List
• Lesson 6: Inserting Graphic Objects
• Insert Symbols and Special Characters
• Add Images to a Document
• Lesson 7: Controlling Page Appearance
• Apply a Page Border and Color
• Add a Watermark
• Add Headers and Footers
• Control Page Layout
• Lesson 8: Proofing a Document
• Check Spelling and Grammar
• Other Proofing Tools
• Lesson 9: Customizing the Word Environment
• Customize the Word Interface
• Additional Save Options

Word 2016 – Part 2  

(Microsoft Office Training )

Duration: Classroom Learning – 1 Day(s)

Overview

In this course, students will create complex documents and build personalized efficiency tools using Microsoft Office Word 2016.

 

Who Should Attend

This course is designed for students who are able to create and modify standard business documents in Microsoft Word 2016, but need to know how to create or modify complex business documents and customized Word efficiency tools. It also aims to assist students preparing for the Microsoft Office Specialist exams for Microsoft Word 2016.

 

At Course Completion

Upon successful completion of this course, students will be able to: – manage lists. – customize tables and charts. – customize the formatting of a document using styles and themes. – modify pictures in a document. – create customized graphic elements. – insert content using Quick Parts. – control text flow. – use templates to automate document creation. – use the mail merge function. – use macros to automate common tasks.

 

Prerequisite(s) or equivalent knowledge

Word 2016 – Part 1

 

Suggested Next Steps

Word 2016 – Part 3

 

Outline

• Lesson 1: Working with Tables and Charts
• Sort Table Data
• Control Cell Layout
• Perform Calculations in a Table
• Create a Chart
• Lesson 2: Customizing Formats Using Styles and Themes
• Create and Modify Text Styles
• Create Custom List or Table Styles
• Apply Document Themes
• Lesson 3: Using Images in a Document
• Resize an Image
• Adjust Image Appearance
• Integrate Pictures and Text
• Insert and Format Screenshots
• Lesson 4: Creating Custom Graphic Elements
• Create Text Boxes and Pull Quotes
• Draw Shapes
• Add WordArt and Other Text Effects
• Create Complex Illustrations with SmartArt
• Lesson 5: Inserting Content Using Quick Parts
• Insert Building Blocks
• Create and Modify Building Blocks
• Insert Fields Using Quick Parts
• Lesson 6: Controlling Text Flow
• Control Paragraph Flow
• Insert Section Breaks
• Insert Columns
• Link Text Boxes to Control Text Flow
• Lesson 7: Using Templates
• Create a Document Using a Template
• Create a Template
• Lesson 8: Using Mail Merge
• The Mail Merge Features
• Merge Envelopes and Labels
• Create a Data Source Using Word
• Lesson 9: Using Macros
• Automate Tasks Using Macros
• Create a Macro

Word 2016 – Part 3

(Microsoft Office Training )

Duration
Classroom Learning – 1 Day(s)

Overview
The student will learn to collaborate on complicated documents and manage how the documents are accessed and distributed. Advanced features of Word 2016 enable you to revise, manage, and secure your business documents

Who Should Attend
This course is intended for students who create and work with lengthy documents, collaborate with others on documents, and create forms in Microsoft Word.

At Course Completion
Upon successful completion of this course, students will be able to: – use Microsoft Office Word 2016 with other programs. – collaborate on documents. – manage document versions. – add reference marks and notes. – make long documents easier to use. – secure a document. – create forms. – use XML in Word.

Prerequisite(s) or equivalent knowledge

Word 2010 – Part 1

Word 2010 – Part 2

Prerequisite Comments
Students should be able to use Microsoft® Office Word 2010 to create, edit, format, save, and print business documents that contain text, tables, and graphics. Students should also be able to use a web browser and an email program. A basic understanding of XML would also be helpful. In order to understand how Word interacts with other applications in the Microsoft Office System, students should have a basic understanding of how worksheets and presentations work.

Outline

• Lesson 1: Collaborating on Documents
• Modify User Information
• Share a Document
• Compare Document Changes
• Review a Document
• Merge Document Changes
• Lesson 2: Adding Reference Marks and Notes
• Add Captions
• Add Cross-References
• Add Bookmarks
• Add Hyperlinks
• Insert Footnotes and Endnotes
• Lesson 3: Simplifying and Managing Long Documents
• Insert Blank and Cover Pages
• Insert an Index
• Insert a Table of Contents
• Insert an Ancillary Table
• Manage Outlines
• Lesson 4: Securing a Document
• Suppress Information
• Set Formatting and Editing Restrictions
• Add a Digital Signature to a Document
• Restrict Document Access
• Lesson 5: Forms
• Create Forms
• Manipulate Forms

 

Excel 2016 – Part 1

(Microsoft Office Training )

Duration
Classroom Learning – 1 Day(s)

Overview
In this course, students will use Microsoft® Office Excel® 2016 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.

Who should attend
this course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets.

At Course Completion
Upon successful completion of this course, students will be able to: – create a basic worksheet using Microsoft® Office Excel® 2016. – perform calculations in an Excel worksheet. – modify an Excel worksheet. – format a worksheet. – print Excel workbook contents. – manage an Excel workbook. 

Suggested Next Steps

Excel 2010 – Part 2

Outline

Lesson 1: Getting Started with Microsoft Office Excel 2010

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help
• Lesson 2: Performing Calculations
• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas
• Lesson 3: Modifying a Worksheet
• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools
• Lesson 4: Formatting a Worksheet
• Modify Fonts
• Add Borders and Colors to Worksheets
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates
• Lesson 5: Printing Workbooks
• Preview and Print a Workbook
• Define the Page Layout
• Lesson 6: Managing Workbooks
• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Excel 2016 – Part 2

(Microsoft Office Training )

Duration
Classroom Learning – 1 Day(s)

Overview
this course builds upon the foundational Microsoft® Office Excel® 2016 knowledge and skills you’ve already acquired and sets you on the road to creating advanced workbooks and worksheets that will deepen your firm’s business intelligence.

Who should attend
this course is designed for students who already have foundational knowledge and skills in Excel 2010 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

At Course Completion
Upon successful completion of this course, students will be able to: – use advanced formulas. – organize worksheet and table data using various techniques. – create and modify charts. – analyze data using PivotTables, Slicers, and Pivot Charts. – insert and modify graphic objects in a worksheet. – customize and enhance workbooks and the Microsoft® Office Excel® environment. 

Prerequisite(s) or equivalent knowledge

Excel 2016 – Part 1

Suggested Next Steps

Excel 2016 – Part 3

Outline

Lesson 1: Customizing the Excel Environment

• Configure Excel Options
• Customize the Ribbon and the Quick Access Toolbar
• Enable Excel Add-Ins
• Lesson 2: Creating Advanced Formulas
• Use Range Names in Formulas
• Use Specialized Functions
• Use Range Names in Formulas
• Use Specialized Functions
• Lesson 3: Analyzing Data with Functions and Conditional Formatting
• Analyze Data by Using Text and Logical Functions
• Apply Advanced Conditional Formatting
• Lesson 4: Organizing and Analyzing Datasets and Tables
• Create and Modify Tables
• Sort Data
• Filter Data
• Use SUBTOTAL and Database Functions
• Lesson 5: Visualizing Data with Basic Charts
• Create Charts
• Modify and Format Charts
• Lesson 6: Analyzing Data with PivotTables, Slicers, and Pivot Charts
• Create a PivotTable
• Analyze PivotTable Data
• Present Data with Pivot Charts
• Filter Data by Using Slicers

Excel 2016 – Part 3

(Microsoft Office Training )

 

Duration
Classroom Learning – 1 Day(s)

Overview
the students will learn about some of the more advanced features of Excel including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications.

Who should attend
this course is intended for students who are experienced Excel 2016 users who have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

Prerequisite(s) or equivalent knowledge

Excel 2010 – Part 1

Excel 2010 – Part 2

Prerequisite Comments
to ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2010. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and Pivot Charts; and customizing the Excel environment

Outline

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously

• Use 3-D Reference
• Use Links and External References
• Consolidate Data
• Lesson 2: Sharing and Protecting Workbooks
• Collaborate on a Workbook
• Protect Worksheets and Workbooks
• Lesson 3: Automating Workbook Functionality
• Apply Data Validation
• Work with Forms and Controls
• Work with Macros
• Lesson 4: Applying Conditional Logic
• Use Lookup Functions
• Combine FunctionsUse Formulas and Functions to Apply Conditional Formatting
• Use Formulas and Functions to Apply Conditional Formatting
• Lesson 5: Auditing Worksheets
• Trace Cells
• Search for Invalid Data and Formulas with Errors
• Watch and Evaluate Formulas
• Lesson 6: Using Automated Analysis Tools
• Determine Potential Outcomes by Using Data Tables
• Determine Potential Outcomes by Using Scenarios
• Use the Goal Seek Feature
• Activate and Use the Solver Tools
• Lesson 7: Presenting Your Data Visually
• Use Advanced Chart Features
• Create Sparklines

PowerPoint 2016 – Part 1

(Microsoft Office Training )

Duration
Classroom Learning – 1 Day(s)

Overview
using the vast array of features and functionality contained within Microsoft® Office PowerPoint® 2016, students will gain the ability to organize content, enhance it with high-impact visuals, and deliver it with a punch.

Who should attend
this course is designed for students who wish to gain the foundational understanding of Microsoft Office PowerPoint 2016 that is necessary to create and develop engaging multimedia presentations.

At Course Completion
Upon successful completion of this course, students will be able to: – explore the PowerPoint 2016 interface and get familiarized using it. – create a presentation. – Format text on slides. – add graphical objects to a presentation. – modify graphical objects on slides. – Work with tables in a presentation. – import charts to a presentation. – prepare to deliver a presentation

Suggested Next Steps

PowerPoint 2010 – Part 2

Outline

Lesson 1: Getting Started with PowerPoint

• Navigate the PowerPoint Environment
• Create and Save a PowerPoint Presentation
• Use Help
• Lesson 2: Developing a PowerPoint Presentation
• Select a Presentation Type
• View and Navigate a Presentation
• Edit Text
•  Build a Presentation

Lesson 3: Performing Advanced Text Editing

• Format Characters
• Format Paragraphs
• Format Text Boxes
• Lesson 4: Adding Graphical Elements to Your Presentation
• Insert Clip Art and Images
• Insert Shapes
• Lesson 5: Modifying Objects in Your Presentation
• Edit Objects
• Format Objects
• Group Objects
• Arrange Objects
• Animate Objects
•  Lesson 6: Adding Tables to Your Presentation
• Create a Table
• Format a Table
• Insert a Table from Other Microsoft Office Application
• Lesson 7: Adding Charts to Your Presentation
• Create a Chart
• Format a Chart
• Insert a Chart from Microsoft Excel
• Lesson 8: Preparing to Deliver Your Presentation 
• Review Your Presentation
• Apply Transitions
• Print Your Presentation
• Deliver Your Presentation
  
  

PowerPoint 2016 – Part 2

(Microsoft Office Training )

Duration
Classroom Learning – 1 Day(s)

Overview
In this course, students will enhance their presentation by using features that will transform it into a powerful means of communication. They will customize the PowerPoint interface to suit the requirements and use features to create presentations.

Who should attend
this course is intended for students who have a foundational working knowledge of PowerPoint 2016, who wish to take advantage of the application’s higher-level usability, security, collaboration, and distribution functionality.

Prerequisite(s) or equivalent knowledge

PowerPoint 2016 – Part 1

Outline

Lesson 1: Modifying the PowerPoint Environment

• Customize the User Interface
• Set PowerPoint 2016 Options
• Lesson 2: Customizing Design Templates
• Modify Slide Masters and Slide Layouts
• Add Headers and Footers
• Modify the Notes Master and the Handout Master
• Lesson 3: Adding SmartArt to a Presentation
• Create SmartArt
• Modify SmartArt
• Lesson 4: Working with Media and Animations
• Add Audio to a Presentation
• Add Video to a Presentation
• Lesson 5: Collaborating on a Presentation
• Review a Presentation
• Publish Slides to a Slide Library
• Share a Presentation on the Web
• Lesson 6: Customizing a Slide Show
• Annotate a Presentation
• Set Up a Slide Show
• Create a Custom Slide Show
• Add Hyperlinks and Action Buttons
• Record a Presentation
• Lesson 7: Securing and Distributing a Presentation
• Secure a Presentation
• Broadcast a Slide Show
• Create a Video or a CD

Outlook 2016 – Part 1

(Microsoft Office Training )

Duration
Classroom Learning – 1 Day(s)

Overview
In this course, you will explore the Outlook interface, manage Email communications, Calendar, Contacts, create Tasks and Notes for yourself and customize the Outlook interface to serve your own personal needs.

At Course Completion
Upon successful completion of this course, students will be able to: – identify the components of the Outlook 2016 environment. – compose email messages using Outlook. – send and receive email messages using Outlook. – organize email messages into folders. – manage contacts using Outlook. – Schedule appointments using Outlook. – Schedule meetings. – manage tasks, notes, and journal entries

Outline :

Lesson 1: Getting Started With Outlook 2016

• Navigate the Outlook Interface
• Perform Basic Email Functions
• Use Outlook Help
• Lesson 2: Composing Messages
• Create an Email Message
• Check Spelling and Grammar
• Format Message Content
• Attach Files and Items
• Enhance an Email Message
• Manage Automatic Message Content
• Lesson 3: Reading and Responding to Messages
• Customize Reading Options
• Work with Attachments
• Manage Your Message Responses
• Lesson 4: Managing Your Messages
• Manage Messages Using Tags, Flags, and Commands
• Organize Messages Using Folders
•  Lesson 5: Managing Your Calendar
• View the Calendar
• Manage Appointments
• Manage Meetings
•  Lesson 6: Managing Your Contacts
• Create and Update Contacts
• View and Organize Contacts
• Lesson 7: Working With Tasks and Notes
• Manage Tasks
• Manage Notes
• Lesson 8: Customizing the Outlook Environment
• Customize the Outlook Interface
• Create and Manage Quick Steps

Outlook 2016 – Part 2

(Microsoft Office Training )

Duration
Classroom Learning – 1 Day(s)

Overview
In this course, students will explore the advanced features provided with the Outlook interface, such as advanced message, calendar, and contacts management.

Who Should Attend
This course is intended for people who have a basic understanding of Microsoft® Windows® and Microsoft Office Outlook 2016 and want or need to know how to perform more advanced tasks in Outlook.

At Course Completion
Upon successful completion of this course, students will be able to: – customize message settings. – organize and locate Outlook messages. – set calendar options. -track activities using the Journal. – assign and track tasks. – share folder information. – customize the Outlook environment.

Prerequisite(s) or equivalent knowledge

Outlook 2016 – Part 1

Prerequisite Comments
Prospective students should be familiar with using personal computers, basic typing skills are recommended. They should be comfortable with the Windows environment and be able to use Windows to manage information on the computer. Specifically, they should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Outline

Lesson 1: Configure Advanced Message Options

• Insert Advanced Characters and Objects
• Modify Message Settings, Properties, and Options
• Use Automatic Replies
•  Lesson 2: Advanced Message Management
• Sort Messages
• Filter Messages
• Organize Messages
• Search Messages
• Manage Junk Mail
• Manage Your Mailbox
•  Lesson 3: Advanced Calendar Management
• Manage Advanced Calendar Options
• Manage Availability Options
• Create Calendar Groups
•  Manage Meeting Responses
• Lesson 4: Advanced Contact Management
• Edit an Electronic Business Card
• Manage Advanced Contacts Options
• Forward Contacts
• Export Contacts
• Lesson 5: Managing Activities by Using Tasks and Journal Entries
• Assign and Manage Tasks
• Record and Modify Journal Entries
• Lesson 6: Sharing Workspaces with Others
• Delegate Access to Mail Folders
• Share Your Calendar
• Share Your Contacts
• Lesson 7: Managing Outlook Data Files
• Back Up Outlook Items
• Change Data File Settings

Outlook 2016- Level 3

(Microsoft Office Training )

Duration
Classroom Learning – 1 Day(s)

Overview
In this course, students will work with the advanced features of Outlook.

Who Should Attend
This course is intended for persons with an intermediate understanding of Outlook who need to use Outlook to personalize and organize their email, manage Outlook data files, share and link contacts, archive items, create forms, and work offline and remotely.

Prerequisite(s) or equivalent knowledge

Outlook 2016- Part 1

Outlook 2016 – Part 2

Outline

Lesson 1: Personalizing Your Email

• Apply Stationery and Themes
• Create a Custom Theme
• Create a Signature
• Modify Signatures
• Configure Email Message Security Settings

Lesson 2: Organizing Outlook Items

• Group Items
• Create Search Folders
• Apply Conditional Formatting
• Lesson 3: Managing Outlook Data Files
• Back Up Outlook Items in Outlook Data Files
• Add Outlook Data Files to a Mail Profile
• Change Data File Settings
• Lesson 4: Managing Contacts and Contact Information

• Forward Contacts
• Edit an Electronic Business Card
• Export Contacts
• Perform a Mail Merge
•  Link Items to the Business Contact Manager
• Lesson 5: Saving and Archiving Email
• Save Messages in Alternate Formats
• Archive Messages
• Lesson 6: Creating a Custom Outlook Form
• Customize a Form
• Create Outlook Items Based on a Custom Form
• Lesson 7: Working Offline and Remotely
• Make Folders Available Offline
• Configure Remote Procedure Calls over HTTP
• Download Selected Messages
• Publish Calendar Information to Office Online

 

Access 2016- Part 1

(Microsoft Office Training )

Duration
Classroom Learning – 2 Day(s)

Overview
In this course, students will learn how to use Access 2016 to manage your data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

Who Should Attend
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2010, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

At Course Completion
Upon successful completion of this course, students will be able to: – explore the Microsoft Office Access 2016 environment. – examine the components of a database. – Work with tables. – manage data in a table. – query a database. – design forms. – generate reports

Outline

Lesson 1: Getting Started with Access

• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help in Microsoft Access
• Lesson 2: Working with Table Data
• Modify Table Data
• Sort and Filter Records
• Create Lookups
• Lesson 3: Querying a Database
• Join Data from Different Tables in a Query
• Sort and Filter Data in a Query
• Perform Calculations in a Query
  Lesson 4: Creating Advanced Queries
• Create Parameter Queries
• Create Action Queries
• Create Unmatched and Duplicate Queries
• Summarize Data
  Lesson 5: Generating Reports
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print
• Lesson 6: Customizing the Access Environment
• The Access Options Dialog Box
• Lesson 7: Designing a Relational Database
•  Relational Database Design
•  Create a Table
•  Create Table Relationships
• Lesson 8: Joining Tables
• Create Query Joins
• Join Tables That Have No Common Fields
• Relate Data within a Table
• Work with Subdatasheets
• Create Sub queries
• Lesson 9: Organizing a Database for Efficiency
• Data Normalization
• Create a Junction Table
• Improve Table Structure
• Lesson 10: Sharing Data Across Applications 
• Import Data into Access
• Export Data to Text File Formats
• Export Access Data to Excel
• Create a Mail Merge
• Lesson 11: Advanced Reporting
• Organize Report Information
• Format Reports
• Include Charts in a Report
• Add a Calculated Field to a Report
• Add a Sub report to an Existing Report

Access 2016 – Part 2

(Microsoft Office Training )

Duration
Classroom Learning – 2 Day(s)

Overview
Students will expand their knowledge of Microsoft® Access® 2016 to include relational database design, writing advanced queries, structuring existing data, sharing data across applications, and customizing reports.

Who Should Attend
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

At Course Completion
Upon successful completion of this course, students will be able to: – restructure data into appropriate tables to ensure data dependency and minimize redundancy. – write advanced queries to analyze and summarize data. – create and revise Microsoft® Office Access® 2016 macros. – customize reports by using various Microsoft® Office Access® 2016 features. – maintain their databases using Microsoft® Office Access® 2016 tools.

Prerequisite(s) or equivalent knowledge

Access 2016 – Part 1

Outline

Lesson 1: Advanced Form Design

• Adding Controls to Forms
• Creating Sub forms
• Organizing Information with Tab Pages
• Displaying a Summary of Data in a Form
• Applying Conditional Formatting
• Lesson 2: Data Validation
• Field and Record Validation
• Form Validation
• Lesson 3: Using Macros to Improve User Interface Design
• Creating a Macro
• Restricting Records Using a Condition
• Validating Data Using a Macro
• Automating Data Entry Using a Macro
• Converting a Macro to VBA
• Lesson 4: Advanced Database Management
• Linking Tables to External Data Sources
• Managing a Database
• Determining Object Dependency
• Documenting a Database
• Analyzing the Performance of a Database
• Lesson 5: Distributing and Securing a Database
• Preparing a Database for Multiple User Access
• Implementing Security
• Setting Passwords
• Converting an Access Database to an ACCDE File
• Packaging a Database with a Digital Signature
  Lesson 6: Managing Switchboards
• Creating a Database Switchboard
• Modifying a Database Switchboard
• Setting Startup Options

 

Access 2016 – Level 3

(Microsoft Office Training )

Duration
Classroom Learning – 1 Day(s)

Overview
In this course student will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Who Should Attend
This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access® 2016 application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access applications to the environment.

At Course Completion
Upon successful completion of this course, students will be able to: – share Access data with other applications. – use VBA to automate a business process. – create and modify a database switchboard and set the startup options. – secure and distribute databases. – share databases using a SharePoint site.

Prerequisite(s) or equivalent knowledge

Access 2016 – Part 1

Access 2016 – Part 2

Outline

Lesson 1: Integrating Access into Your Business

• Import XML Data into an Access Database
• Export Access Data to the XML Format
• Export Data to an Outlook Address Book
•  Collect Data Through Email Messages
• Lesson 2: Automating a Business Process with VBA
• Create a Standard Module
• Develop Code
• Call a Procedure from a Form
• Run a Procedure
• Lesson 3: Managing Switchboards
• Create a Database Switchboard
• Modify a Database Switchboard
• Set the Startup Options
• Lesson 4: Distributing and Securing Databases
• Split a Database
• Implement Security
• Set Passwords
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature
• Lesson 5: Sharing Databases Using a SharePoint Site
• Export a Table to a SharePoint List
• Import Data from a SharePoint List
• Publish a Database to a SharePoint Site
• Move a Database to a SharePoint Site
• Work Offline

Project 2016 – Level 1

Duration
Classroom Learning – 1 Day(s)

Overview
In this course, students will create and manage a project schedule using Microsoft® Project 2010.

Who Should Attend
This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage those project plans.

Suggested Next Steps

Project 2016 – Level 2

Outline

Lesson 1: Getting Started with Microsoft Project

• Explore the Microsoft Project 2010 Environment
• Display an Existing Project Plan in Different Views
• Lesson 2: Creating a Project Plan
• Create a Project Plan
• Assign a Project Calendar
• Add Tasks to a Project Plan
• Enter the Task Duration Estimates
• Add Resources to a Project Plan
• Lesson 3: Managing Tasks in a Project Plan
• Outline Tasks
• Link Dependent Tasks
• Set Task Constraints and Deadlines
• Add Notes to a Task
• Lesson 4: Managing Resources in a Project Plan
• Create a Resource Calendar
• Assign Resources to Tasks
• Enter Costs for Resources
• Resolve Resource Conflicts
• Lesson 5: Finalizing a Project Plan
• Shorten a Project Using the Critical Path
• Set a Baseline
• Print a Project Summary Report

  Project 2016 – Level 2

• Duration
  Classroom Learning – 1 Day(s)Overview
  Students will manage and customize project plans during the implementation stage of a project.

  Who Should Attend
  This course is designed for a person who has an understanding of project management concepts, who has the basic skills to create and modify project plans using Microsoft Project 2016, and who needs to use Microsoft Project 2016 to manage and customize those plans through the implementation stage of a project.

  Prerequisite(s) or equivalent knowledge

• Project 2016 – Level 1

 

• Prerequisite Comments
  Students enrolling in this class should have the following: A general introductory-level understanding of project management concepts. Courses that help fulfill this requirement include: Project Management Fundamentals (Second Edition). Basic end-user skills with any current Windows operating system. Courses that help fulfill this requirement include: Microsoft® Windows® XP Professional: Level 1 or Microsoft® Windows® Vista™: Level 1 or Microsoft® Windows® 7: Level 1
• Outline
• Lesson 1: Exchanging Project Plan Data with Other Application
• Import Project Information
• Export Project Plan Cost Data to an Excel Workbook
• Copy a Picture of the Project Plan Information
• Lesson 2: Updating a Project Plan
• Enter Task Progress
• Enter Overtime Work
• Edit Tasks
• Reschedule a Task
• Filter Tasks
• Set an Interim Plan
• Create a Custom Table
• Create a Custom Field
  Lesson 3: Managing Project Costs
• Update Cost Rate Tables
• Group Costs
• Link Documents to a Project Plan
•  Lesson 4: Reporting Project Data Visually
• Create a Visual Report
• Customize a Visual Report
• Create a Visual Report Template
• Lesson 5: Reusing Project Plan Information
• Create a Project Plan Template
• Create a Custom View
• Make Custom Views Available to Other Project Plans
• Share Resources
• Create a Master Project