Microsoft Access and Microsoft Excel Mastery Bundle

BY
Udemy

Develop a comprehensive understanding of the foundational principles and surgeries associated with MS Excel and MS Access.

Mode

Online

Fees

₹ 2499

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

The Microsoft Access and Microsoft Excel Mastery Bundle 2016 certification course was created by Simon Sez IT, a digital learning platform that specializes in business software courses, and is available on Udemy which is designed for students who want to learn how to use MS Access and MS Excel at an advanced level. The Microsoft Access and Microsoft Excel Mastery Bundle 2016 online course teach the students how to manipulate enormous amounts of data and transform them into effective business decisions.

Microsoft Access and Microsoft Excel Mastery Bundle 2016 online course begin with the fundamentals of each software before proceeding on to more advanced features like importing data from an Access database into Excel. Students will receive over 42.5 hours of self-paced video lectures, as well as 13 articles and 13 downloadable learning resources, covering topics such as VBA, data bars, charts, graphs, model dialogue, query wizard, relationships, sparklines, functions, data entry, cell formatting, macros, data analysis, and depreciation calculation.

The highlights

  • Certificate of completion
  • Self-paced course
  • 42.5 hours of pre-recorded video content
  • 13 articles
  • 13 downloadable resources

Program offerings

  • Online course
  • Learning resources. 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 2,499
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing the Microsoft Access and Microsoft Excel Mastery Bundle 2016 online certification, students will be able to develop a deeper understanding of the core concepts and techniques related to Microsoft Acess and Microsoft Excel. Students will learn about macros, validation, model dialog, workbook, worksheet, charts, graphs, query wizard, quick access toolbar, ribbon interface, functions, data bars, and sparklines, among other features of Access and Excel. Students will also obtain a working understanding of data entry, cell formatting, depreciation calculation, and data analysis.

The syllabus

Access 2016: Introduction

  • Introduction to Access 2016 Course
  • Watch Me: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Course Demo Files
  • Downloadable Course Transcript
  • Acquiring Access 2016
  • Structure of the Course
  • What's New in Access 2016
  • Section 1 Quiz

Access 2016: Using Touch

  • Using Access in a Touch Device
  • Section 2 Quiz

Access 2016: Getting Started

  • Using Database Templates
  • Creating, Saving, and Opening Databases
  • The Access Workspace and Backstage
  • Section 3 Quiz

Access 2016: Help

  • Online Help and Tell Me
  • Section 4 Quiz

Access 2016: The Ribbon and Toolbars

  • The Ribbon
  • The Quick Access Toolbar
  • Contextual Menus
  • Section 5 Quiz

Access 2016: Keyboard Shortcuts and Key Tips

  • The Status Bar
  • Keyboard Shortcuts
  • Key Tips
  • Section 6 Quiz

Access 2016: Access Options

  • General, Current Databases, and Language Options
  • Section 7 Quiz

Access 2016: Tables

  • Creating a Table and Fields
  • Indexed Field
  • Lookup Wizard
  • Numeric Fields
  • Exercise 01
  • Section 8 Quiz

Access 2016: Importing Data

  • Importing Data from Excel
  • Exercise 02
  • Section 9 Quiz

Access 2016: Backup, Restore, and Repair

  • Backing up your Database
  • Compact and Repair
  • Section 10 Quiz

Access 2016: Datasheet View

  • Design in the Datasheet View
  • Sorting and Filtering in Datasheet View
  • Entering and Modifying Data in Datasheet View
  • Section 11 Quiz

Access 2016: Relationships

  • Creating a Link Table
  • Setting up Relationships
  • Exercise 03
  • Section 12 Quiz

Access 2016: Forms

  • Creating a Form
  • Modifying a Form
  • Exercise 04
  • Forms in Layout View
  • Forms in Design View
  • Form Design
  • Exercise 05
  • Section 13 Quiz

Access 2016: Subforms

  • Setting up Subforms - Part 1
  • Setting up Subforms - Part 2
  • Setting up Subforms - Part 3
  • Exercise 06
  • Section 14 Quiz

Access 2016: Queries

  • Creating a Query
  • Joins
  • Query Wizard
  • Exercise 07
  • Section 15 Quiz

Access 2016: Expressions

  • Setting up Validations
  • Calculation using Expressions
  • Section 16 Quiz

Access 2016: Reports

  • Basic Report
  • Report Design
  • Complex Report
  • Exercise 08
  • Section 17 Quiz

Access 2016: Printing

  • Printing and Print Properties
  • Section 18 Quiz

Access 2016: More Data Types

  • Yes/No, OLE Object, and Hyperlink Data Types
  • Section 19 Quiz

Access 2016: More About Forms

  • Form Controls
  • Form Themes
  • Form Navigation
  • Section 20 Quiz

Access 2016: Modal, Dialogs, and Macros

  • Introduction to Model Dialog and Macros
  • Model Dialog and Macros Continued
  • Form Validation
  • Adding a Command Button to a Form
  • Exercise 09
  • Section 21 Quiz

Access 2016: Web App Basics

  • Creating an Access Web App
  • Importing an Access Database to a Web App
  • Exercise 10
  • Section 22 Quiz

Access 2016: Exporting

  • Exporting an Access Database
  • Section 23 Quiz

Access 2016: Application Parts

  • Adding Application Parts to a Database

Access 2016: More Access Options

  • Additional Access 2016 Options
  • Section 25 Quiz

Access 2016: Info Tab

  • View and Edit Database Properties, and Encrypt with Password
  • Section 26 Quiz

Access 2016: Security

  • Trust Center Settings
  • Section 27 Quiz

Access 2016: Conclusion

  • Closing

Access 2016 Advanced - Introduction to Microsoft Access 2016 Advanced

  • Course Overview and Content
  • Watch Me: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Course Demo Files
  • Section 29 Quiz

Access 2016 Advanced: Primary Keys and Indexes

  • Primary Keys and Indexing Rules and Guidelines
  • More About Indexes
  • Section 30 Quiz

Access 2016 Advanced: Using Datasheet View

  • Setting Up Northwind Database
  • Working in a Datasheet View
  • Customizing Datasheet View and Advanced Sorting and Filtering
  • Subdatasheets
  • Exercise 01
  • Section 31 Quiz

Access 2016 Advanced: Linking to Other Access Databases

  • Linking Two Tables to Other Access Databases
  • Section 32 Quiz

Access 2016: Using ODBC and SQL Server

  • Acquiring and Installing SQL Server Express
  • Setting Up SQL Server Database
  • Exercise 2
  • Section 33 Quiz

Access 2016 Advanced: Splitting An Access Database

  • Splitting an Access Database into Front-end and Back-end Databases
  • Converting Shared Table into Local Table; Moving Back-end Database
  • Exercise 03
  • Addressing Multi-users Issues When Sharing Data
  • Section 34 Quiz

Access 2016 Advanced: Macros

  • Basics of Macros
  • Macros on Events; AutoExec
  • More About AutoExec; Bypassing AutoExec
  • Macro Security Settings
  • Exercise 04
  • Section 35 Quiz

Access 2016 Advanced: The Ribbon

  • Customizing the Ribbon and Quick Access Tool
  • Section 36 Quiz

Access 2016 Advanced: Visual Basic for Applications in Access 2016

  • Convert Macros to VBA; VBA Editor and Property Windows
  • VBA Modules; Running Code and Error Handling
  • Creating Modules; Subs, Functions, Intellisense and Variables
  • Scope, Variable Naming and Strings
  • Standard Functions; Logical, Case and Loop Statements
  • Section 37 Quiz

Access 2016 Advanced: Access Events Model

  • Adding Events to Assets Database
  • Exercise 05
  • Common Events; Form and Report Events
  • Switchboard and Navigation Form; Error Handling
  • Exercise 06
  • Section 38 Quiz

Access 2016 Advanced: Forms

  • Formatting Bound and Control Form
  • Split Forms; Macro Error Handling
  • Creating Form with Tab
  • Go To Combo Box and Its Properties
  • Exercise 07
  • Section 39 Quiz

Access 2016: Advanced Use of Queries

  • Basic of Queries: Review
  • Syntax of SQL Statements
  • Use of Multiple Where Criteria & Select Statements Function
  • Joins and Its Types
  • Exercise 08
  • Action Queries - Part 1
  • Action Queries - Part 2
  • Subqueries
  • Section 40 Quiz

Access 2016 Advance: Packaging Your Application

  • Steps in Packaging Access Application
  • Exercise 09
  • Section 41 Quiz

Access 2016 Advanced: Conclusion

  • Online Support and Conclusion

Excel 2016: Introduction to Excel 2016 Beginner Course

  • Introduction
  • Watch Me: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Course Demo Files
  • Exercise Files
  • Section 43 - Quiz

Excel 2016: What's New

  • New and Improved Features in Excel 2016

Excel 2016: Using Touch

  • Overview of Principles of Using Touchscreen

Excel 2016: Getting Started

  • Creating and Saving a Workbook
  • Opening a Workbook

Excel 2016: Using Help

  • Online Help and Contextual Help
  • Section 47 - Quiz

Excel 2016: Excel Options

  • Personalizing your use of Excel
  • Section 42 - Quiz

Excel 2016: The Ribbon and Toolbars

  • Basics of using the Ribbon
  • Quick Access Toolbar
  • Tell Me Feature
  • Mini Toolbars and Contextual Menus
  • Status Bar
  • Section 49 - Quiz

Excel 2016: Entering and Editing Data

  • Basics of Entering and Editing Data in a Workbook
  • Exercise 01
  • Formatting Dates
  • Formatting Numbers
  • Exercise 02
  • Section 50 - Quiz

Excel 2016: Backup and Recovery

  • AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
  • Section 51 - Quiz

Excel 2016: Fill and Series

  • Working with Fill and Series
  • Flash Fill
  • Section 54 - Quiz

Excel 2016: Viewing and Printing

  • Workbook Views, Zoom, and Freeze
  • Printing
  • Exercise 03
  • Section 53 - Quiz

Excel 2016: Cut, Copy, and Paste

  • Methods of Cutting, Copying, and Pasting
  • Section 54 - Quiz

Excel 2016: Formatting a Worksheet

  • Delete and Clear
  • Insert, Hide, Column Width and Row Height, and Merge
  • Alignment
  • Themes and Styles
  • Exercise 04
  • Section 3 - Quiz

Excel 2016: Formulas and Functions

  • Basics of Fomulas and Functions
  • Complex Examples of Formulas
  • Exercise 05
  • Section 14 - Quiz

Excel 2016: Managing Worksheets

  • Managing Worksheets
  • Section 15 - Quiz

Excel 2016: Working with Multiple Workbooks

  • Working with Multiple Workbooks
  • Section 16 - Quiz

Excel 2016: Saving Workbooks

  • Saving in Different File Types
  • Section 17 - Quiz

Excel 2016: Proofing

  • The Spell Checker

Excel 2016: Inserting Comments

  • Inserting Comments
  • Exercise 06

Excel 2016: Basic Functions in Excel

  • The VLOOKUP Function
  • Text Functions
  • Date and Time Functions
  • Logical Functions
  • Section 20 - Quiz

Excel 2016: Graphs and Charts

  • Creating Graphs and Charts
  • Customizing a Cluster Column Chart
  • Customizing a Pie Chart
  • New Chart Types in Excel 2016
  • Exercise 07
  • Section 21 - Quiz

Excel 2016: Sorting and Filtering Data

  • Managing Data by Sorting
  • Managing Date by Filtering
  • Customizing Tables
  • Section 22 - Quiz

Excel 2016: Shapes and Pictures

  • Inserting Shapes and Pictures
  • Exercise 08
  • Section 23 - Quiz

Excel 2016: Formatting Cells Based on Content

  • Conditional Formatting
  • Section 24 - Quiz

Excel 2016: Protection and Security

  • Protecting Worksheets
  • Protecting Workbooks

Excel 2016: Naming Items

  • Giving Items Names
  • Exercise 09

Excel 2016: Finding and Replacing Words

  • Find and Replace
  • Section 27 - Quiz

Excel 2016: Borders

  • Adding Borders
  • Section 28 - Quiz

Excel 2016: Workbook Inspection

  • Inspecting a Workbook

Excel 2016: Privacy Options

  • Trust Center Privacy Options

Excel 2016: Sharing Options

  • Sharing a Workbook
  • Section 31 - Quiz

Excel 2016: Wrap Up

  • Closing

Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course

  • Prerequisites of the Course and Version of Excel
  • Watch Me: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Course Demo Files
  • Course Structure

Excel 2016 Advanced: Functions

  • Functions - Part 1
  • Functions - Part 2
  • Autosum
  • Section 76 - Quiz

Excel 2016 Advanced: Date and Time Functions

  • How Date and Time Works
  • Basic Date and Time Functions
  • Complex Date and Time Functions
  • Section 77 - Quiz

Excel 2016 Advanced: Text Functions

  • Using Text Functions - Part 1
  • Using Text Functions - Part 2
  • Section 78 - Quiz

Excel 2016 Advanced: Logical Functions

  • Using Logical Functions
  • Exercise 01
  • Section 79 - Quiz

Excel 2016 Advanced: Lookup Functions

  • HLOOKUP Function
  • VLOOKUP Function
  • Exercise 02
  • Section 80 - Quiz

Excel 2016 Advanced: Financial Functions

  • Financial Functions and Terminology
  • Personal Financial Functions
  • Professional Financial Functions
  • Depreciation
  • Exercise 03
  • Section 81 - Quiz

Excel 2016 Advanced: Statistical Functions

  • Statistical Functions for Description - Part 1
  • Statistical Functions for Description - Part 2
  • Statistical Functions for Forecasting - Part 1
  • Statistical Functions for Forecasting - Part 2
  • Exercise 04
  • One Click Forecasting
  • Statistical Functions for Inference
  • Section 82 - Quiz

Excel 2016 Advanced: Connecting to External Data

  • Connecting to Other Workbooks
  • Connecting to Access Databases
  • Connecting to Web Data Sources
  • Get and Transform
  • Exercise 05
  • Section 83 - Quiz

Excel 2016 Advanced: Tables

  • Introduction to Tables
  • Working with Tables
  • Table References
  • Table Styles
  • Exercise 06
  • Section 84 - Quiz

Excel 2016 Advanced: Pivot Tables

  • Introduction to Pivot Tables
  • Working with Pivot Tables
  • Filters and Slicers
  • Pivot Charts
  • Exercise 07
  • Section 85 - Quiz

Excel 2016 Advanced: Data Analysis

  • What If Analysis
  • Scenario Manager
  • Goal Seek
  • Solver
  • Exercise 08
  • Section 86 - Quiz

Excel 2016 Advanced: Graphs and Charts

  • Area Charts
  • Surface Charts
  • Radar Charts
  • Bubble Charts
  • Sparklines
  • Stock Charts
  • Exercise 09
  • Section 87 - Quiz

Excel 2016 Advanced: Excel Web App

  • Web App - Part 1
  • Web App - Part 2
  • Section 88 - Quiz

Excel 2016 Advanced: Conclusion

  • Closing Message

Extras

  • Extra Lesson: Designing Better Spreadsheets Webinar Recording
  • Extra Lesson: Data Cleaning in Excel Webinar Recording
  • Extra Lesson: Top Ten Excel Functions You HAVE to Know Webinar Recording
  • Extra Resource: The Most Frequently Used Excel Shortcuts - Infographic
  • Extra Resource: The Most Frequently Used Access Shortcuts - Infographic

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books