The Ultimate Microsoft Access 2013 & 2016 Mastery

Udemy

Acquire a comprehensive understanding of the core functionalities of Microsoft Access 2013 and 2016 editions from scratch.

Online

₹ 499 2799

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Introduction

Introduction
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
Downloadable Course Transcript
What's New in Access 2013

Using Touch

Overview of Principles

Using Access in a Touch Device

Getting Started

Database Template: Creating: Opening and Saving Databases
Workspace and Backstage View

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

Help

Online, Offline and Contextual Help

Online Help and Tell Me

Keyboard Shortcuts and Key Tips

Finding Keyboard Shortcuts and Key Tips

Keyboard Shortcuts
Key Tips

Access Options

Customizing the Settings and Use of Access 2013

General, Current Databases, and Language Options

The Ribbon and Toolbars

The Ribbon
Quick Access Toolbar

The Ribbon
The Quick Access Toolbar
Contextual Menus
The Status Bar

Status Bar

Customizing the Status Bar

Database Basics

Overview of the Main Features of Access Database
Web App Basics

Tables

Creating Tables - Part 1
Creating Tables - Part 2
Relationship between Tables - Part 1
Relationship between Tables - Part 2

Creating a Table and Fields
Indexed Fiels
Lookup Wizard
Numeric Fields
Exercise 01

Datasheet Views

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

Table Design

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

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

Basics of Forms: Review and Tips and Tricks
Advanced Features of Forms: Details of a Students List Sample Form and using Mac
Advanced Features of Forms: Details of a Students List Sample Form and using Mac
Advanced Features of Forms: Details of a Students List Sample Form and using Mac
Advanced Features of Forms: Details of a Students List Sample Form and using Mac

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

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

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

Creating a Query
Joins
Query Wizard
Exercise 07

Reports

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

Basic Report
Report Design
Complex Report
Exercise 08

Printing

Documenter; Print Properties and Options

Printing and Print Properties

Importing and Exporting Data

Import and Append; Copy and Paste; Export Access Database

Templates and Application Parts

Database Templates and Application Parts

Macros and VBA

Actions; Example of VBA; Creating AutoExec Macro

Additional Topics

More Access Options
Info Tab

Security

Trust Center

Trust Center Settings

Conclusion

Updates; Closing
Access 2013 Quiz

Closing
Access 2013 Advanced Quiz

Closing
Access 2016 - Quiz

Online Support and Conclusion
Access 2016 Advanced - Quiz

Microsoft Access 2013 Advanced Course - Introduction

Prerequisites and Basic Knowledge of Access 2013
WATCH ME: Essential Information for a Successful Training Experience
Course Exercise Files

Indexes

Indexes and Introduction to the Movies Database

Datasheet View

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

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

Linking Access Database

Linking to Other Access Database Tables

ODBS and SQL Server

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

Splitting an Access Databse

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

Multi-user Aspects

Access Options relating to Multi-user Issues; Record Locking

Macros

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

Basics of Macros
Macros on Events; AutoExec
More About AutoExec; Bypassing AutoExec
Macro Security Settings
Exercise 04

The Ribbon

Customizing the Quick Access Toolbar and the Ribbon

Customizing the Ribbon and Quick Access Tool

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

Events

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

SQL

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

Joins

How Joins Look in SQL Statements and using Query Grids

Action Queries

Update Query
Delete and Make Table Queries
Append Query

Packaging your Application

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

Steps in Packaging Access Application
Exercise 09

Web Apps

Setting up an Access Web App
Building Basic Web Apps

Access 2016 Beginners - Introduction

Introduction to Access 2016 Course
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Demo Files
Downloadable Course Transcripts
Acquiring Access 2016
Structure of the Course
What's New in Access 2016

Importing Data

Importing Data from Excel
Excercise 02

Backup, Restore and Repair

Backing up your Database
Compact and Repair

Relationships

Creating a Link Table
Setting up Relationships
Exercise 03

Subforms

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

Expressions

Setting up Validations
Calculation using Expressions

More Data Types

Yes/No, OLE Object, and Hyperlink Data Types

More about Forms

Form Controls
Form Themes
Form Navigation

Model, 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

Web App Basics

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

Exporting

Exporting an Access Database

Application Parts

Adding Application Parts to a Database

More Access Options

Additional Access 2016 Options

Info Tab

View and Edit Database Properties, and Encrypt with Password

Access 2016 Intermediate/Advanced - Introduction

Course Overview and Content
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Demo Files

Primary Keys and Indexes

Primary Keys and Indexing Rules and Guidelines
More About Indexes

Using Datasheet Views

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

Linking to other Access Databases

Linking Two Tables to Other Access Databases

Using ODBC and SQL Server

Acquiring and Installing SQL Server Express
Setting Up SQL Server Database
Exercise 2

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

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

Access Events Model

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

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

Popular Courses

Popular Platforms

Popular Searches