Access 2019 Advanced

——   Created by Simon Sez IT

Share this course:

NEW
Course
46
Lessons
7h 34m
Lesson time
intermediate
Skill level

More about this course

Microsoft Access remains an amazing tool for when your data outgrows spreadsheets. Unlike many other database tools, it’s far more user-friendly and ideal if you’re not a developer.

 

In this Microsoft Access advanced course, we start where the beginner’s course finishes and dives straight into more advanced Access features. This course assumes you know the basics of Access, including how to set up your database, how tables work, how to create forms and how to run simple queries.

 

In this advanced Access course, we look at using ODBC and SQL Server. We also take a deeper dive on using Macros and VBA in Access, splitting databases and advanced form creation. It’s perfect if you have a working knowledge of Access but need to utilize its more advanced features.

 

In this course you will learn:

 

●     All about Primary Keys and Indexes in Access

●     About customizing and filtering on the Datasheet View

●     How to link to other databases

●     All about using ODBC and SQL Server

●     How to split an Access database into front and back-end

●     All about Macros in Access including AutoExec

●     How to do basic VBA in Access including code and error handling

●     More advanced techniques around creating forms in Access

●     Advanced queries including “multiple where” criteria

 

Course Format

●     This is a video-led course.

●     This course includes practice exercise files.

●     This course is suitable for Windows users.

46 Lessons

Section 1: Introduction
0:05:07
Course Overview and Content
free preview
0:09:54
Primary Keys and Indexing Rules and Guidelines
free preview
Section 2:Primary Keys and Indexes
0:08:36
More About Indexes
0:03:34
Setting-up Northwind Database
Section 3: Using Datasheet View
0:11:04
Working in a Datasheet View
0:17:14
Customizing Datasheet View and Advanced Sorting and Filtering
0:09:24
Subdatasheets
0:01:06
Exercise 01
0:13:24
Linking Two Tables to Other Access Databases
Section 4: Linking to Other Access Databases
0:11:36
Acquiring and Installing SQL Server Express
Section 5: Using ODBC and SQL Server
View more lessons +
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 7h 34m of on-demand video
  • 3 downloadable files
  • Have a coupon?

About the instructor

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no …

View full profile

For super learners, get unlimited access for $15 per month

Start your 14 day free trial. Cancel at any time.