US $19.97

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
6 mins
Course Overview and Content
free preview
10 mins
Primary Keys and Indexing Rules and Guidelines
free preview
Section 2:Primary Keys and Indexes
9 mins
More About Indexes
4 mins
Setting-up Northwind Database
Section 3: Using Datasheet View
12 mins
Working in a Datasheet View
18 mins
Customizing Datasheet View and Advanced Sorting and Filtering
10 mins
Subdatasheets
2 mins
Exercise 01
14 mins
Linking Two Tables to Other Access Databases
Section 4: Linking to Other Access Databases
12 mins
Acquiring and Installing SQL Server Express
Section 5: Using ODBC and SQL Server
View more lessons +

About the instructor

Simon Sez IT
Simon Sez IT
  • 1 review
  • 34 courses

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 …

Read more
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?
  • Checkout