0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Microsoft Products

Advanced Access

**This course includes practice exercises and LIFETIME access** Become a Microsoft Access expert with this Advanced Access course for 2019 and MS 365 Users

4.6
(211 ratings) 703 students



Enroll now


What you will learn

Discover how to effectively link to other data sources.
Learn how to split a database by splitting the frontend and backend.
Explore the use of Visual Basic for Applications (VBA).
Discover advanced options for the use of forms.
Dive into options for packaging your application for distribution.
Practice with included Access 2019 exercises files.
Discover advanced options and tips for building and using queries.
Follow along as you learn to create and maintain macros.
Complete database projects at the advanced level.
Get helpful techniques that allow you to link, report, and package your data quickly.

Who should take this training

Prerequisites

  • A working knowledge of Microsoft Access including how to create and manage databases.
  • Microsoft Access 2013, 2016, 2019 or 365

Target audience

  • Experienced database managers or those who are familiar with Access 2016 or 2013

About this training

In this Microsoft Access advanced course, we start where the beginner’s course finishes and dives straight into more advanced Access features. In this course, we assume you know the basics of Microsoft Access, including how to set up a table or database, create a basic form and run a simple query.

This course includes:

7 hours of video tutorials

46 individual video lectures

Exercise files to practice what you learned

Certificate of completion

Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 290

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 520 $ 495

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 810 $ 648

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

1. Introduction
1. Course Overview and Content 05:07 mins
2. Primary Keys and Indexes
1. Primary Keys and Indexing Rules and Guidelines 09:55 mins
2. More About Indexes 08:37 mins
3. Using Datasheet View
1. Setting-up Northwind Database 03:34 mins
2. Working in a Datasheet View 11:04 mins
3. Customizing Datasheet View and Advanced Sorting and Filtering 17:15 mins
4. Subdatasheets 09:24 mins
Exercise 01 01:06 mins
4. Linking to Other Access Databases
1. Linking Two Tables to Other Access Databases 13:24 mins
5. Using ODBC and SQL Server
1. Acquiring and Installing SQL Server Express 11:36 mins
2. Setting Up SQL Server Database 13:41 mins
Exercise 02 01:18 mins
6. Splitting an Access Database
1. Splitting an Access Database into Front-end and Back-end 09:39 mins
2. Converting Shared Table into Local Table; Moving Back-end Database 11:25 mins
Exercise 03 01:49 mins
3. Addressing Multi-user Issues when Sharing Data 09:55 mins
7. Macros
1. Basics of Macros 13:26 mins
2. Macros on Events; AutoExec 12:02 mins
3. More About AutoExec; Bypassing AutoExec 16:12 mins
4. Macro Security Settings 06:33 mins
Exercise 04 04:09 mins
8. The Ribbon
1. Customizing the Ribbon and Quick Access Toolbar 13:12 mins
9. Visual Basic for Applications
1. Convert Macros to VBA; VBA Editor and Property Windows 12:06 mins
2. VBA Modules; Running Code and Error Handling 14:42 mins
3. Creating Modules; Subs, Functions, Intellisense and Variables 12:57 mins
4. Scope, Variable Naming aand Strings 13:46 mins
5. Standard Functions; Logical, Case and Loop Statements 15:15 mins
10. Access Events Model
1. Adding Events to Assets Database 11:00 mins
Exercise 05 01:58 mins
2. Common Events; Form and Report Events 12:25 mins
3. Switchboard and Navigation Form; Error Handling 14:54 mins
Exercise 06 06:49 mins
11. Forms
1. Formatting Bound and Control Form 13:19 mins
2. Split Forms; Macro Error Handling 13:54 mins
3. Creating Form with Tab 12:27 mins
4. Go To Combo Box and Its Properties 10:06 mins
Exercise 07 05:09 mins
12. Advanced Use of Queries
1. Basics of Queries 11:38 mins
2. Syntax of SQL Statements 15:22 mins
3. Use of Multiple Where Criteria & Select Statements Function 11:29 mins
Exercise 08 00:47 mins
4. Action Queries - Part 1 14:20 mins
5. Action Queries - Part 2 10:56 mins
13. Packaging You Application
1. Steps in Packaging Access Application 13:11 mins
Exercise 9 00:56 mins
14. Conclusion
Course Close 00:45 mins

Request more information

Similar courses

Join our mail list for news