Master Microsoft Access 2013 & 2016 for Beginners

BY
Udemy

Learn everything there is to understand about MS Access 2013 and 2016 edition utilizing 28 hours of training resources.

Lavel

Beginner

Mode

Online

Fees

₹ 499 3299

Quick Facts

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

Course overview

Simon Sez IT created the Master Microsoft Access 2013 & 2016 for Beginners certification course, which is delivered through Udemy and is aimed at students who want to collect and monitor a variety of information, such as inventories, contacts, or business operations. Before digging into integrating information from different sources, the Master Microsoft Access 2013 & 2016 for Beginners online course by Udemy focuses on providing the information needed to develop desktop databases and applications for many users.

Master Microsoft Access 2013 & 2016 for Beginners online classes comprise 31 hours of taped video-based lectures, as well as six articles and seven downloadable resources, starting with the fundamentals of Microsoft Access 2013 and 2016. Students will learn about VBA, the ribbon interface, validations, keyboard shortcuts, query wizard, queries, tables, relationships, macros, model dialog, database, datasheet, and many other topics and tools connected to MS Access in this course.

The highlights

  • Certificate of completion
  • Self-paced course
  • 31 hours of pre-recorded video content
  • 6 articles 
  • 7 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
₹ 499  ₹3,299
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing the Master Microsoft Access 2013 & 2016 for Beginners online certification, students will be introduced to the essential factors associated with Microsoft Access and Microsoft Excel. Students will learn about queries, tables, macros, validations, datasheets, and databases, as well as their functionalities and techniques. Students will learn about model dialogue techniques, relationships, keyboard shortcuts, ODBC, SQL, and trust centre for security.

The syllabus

Access 2013: Introduction

  • Acquiring Access 2013; Course Overview
  • Watch Me: Essential Information for a Successful Training Experience
  • Access 2013 Exercise Files
  • Downloadable Course Transcript
  • What's New in Access 2013

Access 2013: Using Touch

  • Using Touch

Access 2013: Getting Started

  • Database Templates; Creating, Opening and Saving Databases
  • Workspace and Backstage View

Access 2013: Help

  • Online, Offline, and Contextual Help

Access 2013: Keyboard Shortcuts and Key Tips

  • Finding Keyboard Shortcuts and Key Tips

Access 2013: Access Options

  • Customizing the Settings and Use of Access 2013

Access 2013: The Ribbon and Toolbars

  • The Ribbon
  • Quick Access Toolbar
  • The Ribbon
  • The Quick Access Toolbar
  • Contextual Menus
  • The Status Bar

Access 2013: Status Bar

  • Customizing the Status Bar

Access 2013: Database Basics

  • Overview of the Main Features of Access Database
  • Web App Basics

Access 2013: Tables

  • Creating Tables - Part 1
  • Creating Tables - Part 2
  • Relationships Between Tables - Part 1
  • Relationships Between Tables - Part 2

Access 2013: Datasheet View

  • Inserting and Formatting Fields; Field Validation; Navigation Buttons
  • Sorting, Filtering and Finding Data
  • Entering Data; Changing the Order of Columns, Field Width and Height

Access 2013: Table Design

  • Design View; Field Properties
  • Saving Data; Data Types, Attachments and Field Size
  • Input Masks; More on Field Properties

Access 2013: Forms

  • Creating Forms; Form Wizard
  • Single Forms; Insert, Delete, Modify, Sort and Filter Records
  • Layout View; Adding Existing Fields
  • Design View; Arranging Fields
  • Controls
  • Form Design

Access 2013: Queries

  • Query Design
  • Joins and Query Wizard
  • Query Types
  • Operators and Expressions - Part 1
  • Operators and Expressions - Part 2
  • Operators and Expressions - Part 3
  • Subforms

Access 2013: Reports

  • Report Wizard; Previewing a Report
  • Report Design
  • Grouped and Summary Reports; Modifying a Report
  • Adding Subreports

Access 2013: Printing

  • Documenter; Print Properties and Options

Access 2013: Importing and Exporting Data

  • Import and Append; Copy and Paste; Export Access Database

Access 2013: Templates and Application Parts

  • Database Templates and Application Parts

Access 2013: More on Forms

  • Navigation Form
  • Modal Dialogs - Part 1
  • Modal Dialogs - Part 2
  • Modal Dialogs - Part 3

Access 2013: Macros and VBA

  • Actions; Example of VBA; Creating AutoExec Macro

Access 2013: Additional Topics

  • More Access Options
  • Info Tab

Access 2013: Security

  • Trust Center

Access 2013: Conclusion

  • Updates; Closing

Access 2013 Advanced: Introduction

  • Pre-requisites and Basic Knowledge of Access 2013
  • Watch Me: Essential Information for a Successful Training Experience
  • Access 2013 Advanced Exercise Files

Access 2013 Advanced: Indexes

  • Course Review
  • Indexes and Introduction to the Movies Database

Access 2013 Advanced: Datasheet View

  • Basics in Working with Datasheet View
  • Controlling the Display and Advanced Sorting and Filtering in Datasheet View

Access 2013 Advanced: Linking Access Databases

  • Linking to Other Access Database Tables

Access 2013 Advanced: ODBC and SQL Server

  • How to Install SQL Server Express
  • Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server

Access 2013 Advanced: Splitting an Access Database

  • Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
  • Consequences of the Split; Moving a Database; Adding a Trusted Location

Access 2013 Advanced: Multi-user Aspects

  • Access Options relating to Multi-user Issues; Record Locking

Access 2013 Advanced: Macros

  • Basics of Macros and Properties of Macro Editor
  • Examples of Macros; Autoexec
  • More Autoexec
  • Macro Security

Access 2013 Advanced: The Ribbon

  • Customizing the Quick Access Toolbar and the Ribbon

Access 2013 Advanced: Visual Basic for Applications

  • Convert Macro to VBA; VBA Editor
  • Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
  • Modules, Subs, Options Explicit, and Variables
  • Scope of Variables
  • Branch and Loop

Access 2013 Advanced: Events

  • Customizing Events
  • Responding to Events and Developing Error Handles
  • More on Events
  • Getting Help with Events

Access 2013 Advanced: Forms

  • Basics of Forms: Review and Tips and Tricks
  • Advanced Features of Forms - Part 1
  • Advanced Features of Forms - Part 2
  • Advanced Features of Forms - Part 3
  • Advanced Features of Forms - Part 4

Access 2013 Advanced: SQL

  • Basics of Queries: Review
  • Main Features and Syntax of SQL Statements
  • Use of Multiple Criteria of a Where Clause

Access 2013 Advanced: Joins

  • How Joins Look in SQL Statements and using Query Grids

Access 2013 Advanced: Action Queries

  • Update Query
  • Delete and Make Table Queries
  • Append Query

Access 2013 Advanced: Packaging your Application

  • Protecting your Database and Codes
  • Making your Database More User-Friendly

Access 2013 Advanced: Web Apps

  • Setting up an Access Web App
  • Building Basic Web Apps

Access 2013 Advanced: Conclusion

  • Closing

Access 2016: Introduction

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

Access 2016: Using Touch

  • Using Access in a Touch Device

Access 2016: Getting Started

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

Access 2016: Help

  • Online Help and Tell Me

Access 2016: Keyboard Shortcuts and Key Tips

  • Keyboard Shortcuts
  • Key Tips

Access 2016: Access Options

  • General, Current Databases, and Language Options

Access 2016: Tables

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

Access 2016: Importing Data

  • Importing Data from Excel
  • Exercise 02

Access 2016: Backup, Restore, and Repair

  • Backing up your Database
  • Compact and Repair

Access 2016: Datasheet View

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

Access 2016: Relationships

  • Creating a Link Table
  • Setting up Relationships
  • Exercise 03

Access 2016: Forms

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

Access 2016: Subforms

  • Setting up Subforms - Part 1
  • Setting up Subforms - Part 2
  • Setting up Subforms - Part 3
  • Exercise 06

Access 2016: Queries

  • Creating a Query
  • Joins
  • Query Wizard
  • Exercise 07

Access 2016: Expressions

  • Setting up Validations
  • Calculation using Expressions

Access 2016: Reports

  • Basic Report
  • Report Design
  • Complex Report
  • Exercise 08

Access 2016: Printing

  • Printing and Print Properties

Access 2016: More Data Types

  • Yes/No, OLE Object, and Hyperlink Data Types

Access 2016: More About Forms

  • Form Controls
  • Form Themes
  • Navigation Form

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

Access 2016: Web App Basics

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

Access 2016: Exporting

  • Exporting an Access Database

Access 2016: Application Parts

  • Adding Application Parts to a Database

Access 2016: More Access Options

  • Additional Access 2016 Options

Access 2016: Info Tab

  • View and Edit Database Properties, and Encrypt with Password

Access 2016: Security

  • Trust Center Settings

Conclusion

  • Closing

Similar Courses

Excel for Beginners

Great Learning

Online
Beginner
Free

Step by Step Spreadsheets for Absolute Beginners

Simpliv Learning

Online
Beginner
$9 $49

Microsoft Excel 2013 Course Beginners Intermediate...

Udemy

Online
Beginner
₹399 ₹2,699

Microsoft Excel for Beginners

GreyCampus

Online
Beginner
₹ 1,110

Excel for Beginners

Davidson College, Davidson via Edx

4 Weeks Online
Beginner
Free
HR Analytics using Excel For Beginners

HR Analytics using Excel For Beginners

Udemy

Online
Beginner
₹649 ₹2,799
Microsoft Excel Outlook and Word 2016 for Beginner...

Microsoft Excel Outlook and Word 2016 for Beginner...

Udemy

Online
Beginner
₹499 ₹3,099
The Huge Microsoft Excel Training Bundle Beginner ...

The Huge Microsoft Excel Training Bundle Beginner ...

Udemy

Online
Beginner
₹449 ₹3,099

Analyzing Data with Excel

IBM via Edx

5 Weeks Online
Beginner
Free

Excel VBA for Creative Problem Solving Part 1

CU Boulder via Coursera

6 Weeks Online
Beginner

Courses of your Interest

How to start Blogging

Great Learning

Online
Beginner
Free

Smart English Basics for Professionals

Great Learning

Online
Beginner
Free
Write a Book Creative Writing Skills For Beginner ...

Write a Book Creative Writing Skills For Beginner ...

Simpliv Learning

Online
Beginner
$9 $49
Learn How To Start Your Own Soap Making Business L...

Learn How To Start Your Own Soap Making Business L...

Simpliv Learning

Online
Beginner
$149 $749
Revolutionize Your Career Competitive Edge

Revolutionize Your Career Competitive Edge

Simpliv Learning

Online
Beginner
$149 $749
Write A Feature Length Screenplay For Film Or Tele...

Write A Feature Length Screenplay For Film Or Tele...

MSU East Lansing via Coursera

Online
Beginner
Free

LIVE Streaming Pro Ultimate Course From Beginner t...

Udemy

Online
Beginner
₹499 ₹2,499
Becoming a Successful Leader Inclusive Leadership ...

Becoming a Successful Leader Inclusive Leadership ...

Catalyst via Edx

4 Weeks Online
Beginner
Free
Communicating Strategically

Communicating Strategically

Purdue University, West Lafayette via Edx

5 Weeks Online
Beginner
Free
Easy Vlogging Making Interactive Self Introduction...

Easy Vlogging Making Interactive Self Introduction...

The Hong Kong Polytechnic University,... via Edx

5 Weeks Online
Beginner
Free

More Courses by Udemy

Python for Beginners to Advance

Udemy

Online
Beginner
₹ 2,499

Learn Python Turtle Using Block Coding

Udemy

Online
Beginner
₹399 ₹799

Master Python Basics For Developer

Udemy

Online
Beginner
₹475 ₹3,499

Programming in Python for Beginners

Udemy

Online
Beginner
₹ 799

Learn Python 3 Programming from Scratch

Udemy

Online
Beginner
₹475 ₹1,299

Automate Your Life With Python

Udemy

Online
Beginner
₹ 2,899

Learn Python Python for Beginners

Udemy

Online
Beginner
₹ 1,799

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