Microsoft Access Advanced

MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 2.5 hours | Size: 1.32 GB
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.

Password/解压密码-0daydown

Download rapidgator
https://rg.to/file/0b96aece8e1c4703637155591dda4aed/Microsoft_Access_Advanced.part1.rar.html
https://rg.to/file/8657db456c4e0fd75c2f47b18fa1e147/Microsoft_Access_Advanced.part2.rar.html
https://rg.to/file/d8f44fe45f97357cdc21812c286c1120/Microsoft_Access_Advanced.part3.rar.html

Download nitroflare
http://nitroflare.com/view/8B256A172F9265B/Microsoft_Access_Advanced.part1.rar
http://nitroflare.com/view/A3BEA5F67EAE241/Microsoft_Access_Advanced.part2.rar
http://nitroflare.com/view/CACFF65AFDEBD5C/Microsoft_Access_Advanced.part3.rar

Download 百度云

你是VIP 1个月(1 month)赞助会员，