Microsoft Access Advanced

[Bo0mB0oma]

 

Microsoft Access Advanced

.MP4 | Video: 1280x720, 30 fps® | Audio: AAC, 48000 Hz, 2ch | 1.32 GB

Duration: 2.5 hours | Genre: eLearning Video | Language: English

Learning to use MS Access to its Fullest Extent

 

Learning to use MS Access to its Fullest Extent

What you'll learn

This training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access in order to increase their knowledge and productivity.

Requirements

Some of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Description

MODULE 1: Advanced Data Management

Learning outcomes: A look into table relationships and referential integrity along with introducing SQL, the language database professionals use to manage a database.

Topics covered:

Referential Integrity

Table Relationships

An Introduction to SQL

Modal Dialog Boxes

MODULE 2: Advanced Form Tasks

Learning outcomes: Creating navigation forms and sub-forms along with some of the advanced form controls necessary to create a fully rounded user interface.

Topics covered:

Using Subforms

Creating a Navigation Form

Advanced Form Controls

Exporting a Form

Other Form Tasks

MODULE 3: Automating Reports

Learning outcomes: Create Reports in Access that can return data quickly by using a form to control and launch reports. Look at modifying form properties including combo boxes and link a query to a form.

Topics covered:

Creating the Report Form

Building Query Criteria

MODULE 4: SQL and Microsoft Access

Learning outcomes: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries.

Topics covered:

Understanding SQL

Using the SELECT Statement

Using Subqueries

Using SQL Joins

MODULE 5: Macros and Visual Basic for Applications (VBA)

Learning outcomes: Using Macros and Visual Basic to create some advanced functionality to your Access Database.

Topics covered:

Macro Basics

More about Macros

Access and VBA

Building Advanced Procedures

Using VBA in a Database

MODULE 6: Finishing the Application

Learning outcomes: Look at finishing touches to control how users interact with a database using start-up and sharing options. Identify security measures by creating an ACCDE and encrypting a database with a password.

Topics covered:

Setting Start Up Options

Sharing/Splitting the Database

Creating an ACCDE

Encrypting the Database with a Password

Who this course is for:

Users with a solid understanding of MS Access 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time.

 

DOWNLOAD

(Buy premium account for maximum speed and resuming ability)

 

http://nitroflare.com/view/C1151021D3C8989/5dtd4.Microsoft.Access.Advanced.rar

 

https://rapidgator.net/file/c607f91845e370c8f9b91cfffde54d9b/5dtd4.Microsoft.Access.Advanced.rar

 

http://turbobit.net/coht95ofnxjq/5dtd4.Microsoft.Access.Advanced.rar.html