Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Access: Beyond the Basics of Access Bundle

Name: Microsoft Access: Beyond the Basics of Access Bundle
Rating: 4.4 (525 reviews)

Don't Miss This Info Packed Three-Course Bundle: (1) Customizing Your Database (2) Automate w/Macros (3) SQL Scripting

Created byIsáBel .

Last updated 1/2026

English

What you'll learn

This bundle combines 3 courses to help you conquer Access in weeks - not months or years (because who's got time for that?)
Learn TIME-SAVING Database Tips, AUTOMATE Your Database with MACROS, and SCRIPT SQL all in one course!
----------
----------
SET Field Validations. Make sure users are entering the correct data.
IMPORT and EXPORT Data Using Microsoft Excel, an application you probably use daily.
CREATE Cascading Combo Boxes. Base the items in a combo box off what was selected in another combo box.
CONDITIONALLY FORMAT Forms & Reports to make your data easier to understand.
CREATE Parameter & Action Queries. Go beyond standard Select Queries
CUSTOMIZE the Access Environment Ribbon, Navigation Pane & Startup
UNDERSTAND Database Maintenance Tools to keep your data intact.
USE the Macro Builder Window to automate your database
CREATE Data Macros for Table Automation
CREATE Macros for Forms & Reports
CREATE AutoExec Macros to run Macros when starting your database
SCRIPT SQL to Query Your Tables
CREATE Database Tables with SQL
CREATE Table Joins with SQL
CREATE Action Queries with SQL
... and so much more!

Course content

32 sections • 186 lectures • 9h 0m total length

Quick Tip: Regular Database Housekeeping0:19
Get the latest Quick Tips from Microsoft Access 2013: Beyond the Basics Bundle

Welcome to Access Bundle Course1:19
Welcome to this Microsoft Access Three Course Bundle:

Access 2013 Tips & Tricks: Time Saving Questions Answered

Microsoft Access Macros: Increase Your Skills & Save Time

Microsoft Access: SQL for Non-Programmers
Downloading the Exercise Database2:53
In this course you will be able to follow along using the Northwind database. This database can be downloaded from within Microsoft Access.

Exporting Data from an Access Table to an Excel Spreadsheet7:12
Temporarily or permanently move data from your Access database into an Excel workbook.
Importing Data from Excel into a New Access Table5:00
If you are like a lot of people, you probably have large amounts of data in Microsoft Excel.

Learn how to import Excel spreadsheets into your Access database
Appending Data from Excel into an Existing Access Table2:00
What you should be aware of before importing data from Microsoft Excel into existing tables in your Access database
Linking to Data in Excel3:49
If you want to keep your data in Excel, but be able to use the querying and reporting features of Access, you can create a link from Access to Excel.
Performing a Mail Merge with Microsoft Word6:56
Use tables or queries as the data source for form letters, e-mail messages, mailing labels, or envelopes.
Formatting Text and Memo Fields4:52
Learn how to format your Access database text and memo fields
Formatting Number Fields3:00
Learn how to format your Access database number and currency fields
Formatting Date Fields3:41
Create custom formatting for the Date field type.
Understanding the Input Mask Wizard4:46
Define how users must enter data in specific fields. This will help maintain consistency, and to make your database easier to manage.
Creating Your Own Custom Input Masks2:00
Create your own, custom input masks to define how users must enter data.
Setting a Field's Default Value3:42
Save time by creating default values for fields.
Field Validation / Controlling Data Entry3:45
Field validation rules restrict what can be entered into a field. This ensures that your database users enter the correct types or amounts of data.
Creating Your Own Custom Error Messages2:04
Create user-friendly error messages.
Advanced Table Filters6:12
Learn to filter by selection, as well as filter by form.
Referential Integrity3:51
To ensure that you data stays synchronized, enforce referential integrity between tables.
Exercise: Lesson Lab1:00
You've seen it, now do it!

Test your skills with this section's lesson lab.

Setting a Form's Tab Order3:44
Specify the order that form controls respond to the TAB key.
Using Conditional Formatting to Highlight Form Information3:43
Selectively highlight data on your form to make it easier to understand.
Creating Cascading Combo Boxes7:08
Synchronize two combo boxes so that when you select an item in the first combo box, that selection limits the choices in the second combo box.
Adding Option Groups9:28
Make selecting a value easy with Option Groups.
Get Organized with Tabs4:29
Reduce clutter on your form, and make it easier to work with your data.
Exercise: Lesson Lab1:00
You've seen it, now do it!

Test your skills with this section's lesson lab.

Grouping and Totaling Reports without the Wizard7:21
Make your data easier to understand with groups. Adding totals to the end of groups reduces the need for manual calculations.
Conditional Formatting4:18
Selectively highlight data on your report to make it easier to understand.
Adding a Logo or Background Image0:31
Learn how to add a logo, or image to a report in your Access databases
Setting CanGrow & CanShrink Properties1:40
Automatically adjust controls vertically to print or preview all the data that the control contains.
Controlling Page Breaks3:58
Master how to control page breaks in Access reports by keeping complete groups together on a page and forcing new pages before each section.
Exercise: Lesson Lab1:00
You've seen it, now do it!

Test your skills with this section's lesson lab.

Adding Wildcards to Queries8:41
Use special characters to locate multiple items with similar, but not identical data.
Parameter Queries6:19
Use the same query over and over again without having to open it in Design view to edit the criteria.
Queries with Calculated Fields4:57
Use built-in functions, or create expressions to calculate the fields in your query.
Unique Values v Unique Records1:00
Unique Values v. Unique Records, what are they, and why should you care?
Update Queries7:03
Add, change, or delete the information in an existing record
Append Queries3:00
Delete Queries3:54
Quickly delete a lot of data
Make Table Queries1:55
Copy the data in a table or archive data.
Find Unmatched Records2:04
Quickly identify records in one of the tables that have no corresponding records in the other table.
Find Duplicate Records1:32
Learn how to quickly find duplicate records within the tables of your Microsoft Access database
Crosstab Queries3:01
Structure summary data to make it easier to read and understand.
Self Join4:07
When you want to create a result set that joins records in a table with other records in the same table use a self join.
Exercise: Lesson Lab2:00
You've seen it, now do it!

Test your skills with this section's lesson lab.

Creating a Custom Tab on the Ribbon8:29
Personalize the ribbon the way that you want.
Creating Custom Groups in the Navigation Pane4:01
Organize your database objects the way that you want.
Hide the Navigation Pane1:43
Hide the Navigation Pane to increase your workspace
Creating a Switchboard Using the Switchboard Manager8:08
Switchboards help users to locate the necessary tables, forms, reports, and queries they use most often.
Exercise: Lesson Lab1:00
You've seen it, now do it!

Test your skills with this section's lesson lab.

Documenting Your Database4:03
Print documentation of your database's design for an offline reference.
Finding Dependent Objects2:08
Learn which database objects interact with or depend on other objects in the database.
Table Analyzer8:02
Create a relational database without having to know relational database design principles.
Backup and Restore Desktop Databases2:50
Learn how to create a backup of your Microsoft Access databases
Compact and Repair Databases2:58
Regular maintenance of your Access databases is a must.
Exercise: Lesson Lab1:00
You've seen it, now do it!

Test your skills with this section's lesson lab.

IIf7:41
You can use IIf to determine if an expression is true or false. If the expression is true, IIf returns one value; if it is false, IIf returns another. It is up to you to specify the values IIf returns
DateDiff3:06
Find the difference between two dates
DateAdd4:12
Add time to a date value
Keyboard Shortcuts for Text and Data3:00
Keyboard Shortcuts for Text and Data
Keyboard Shortcuts for Navigation5:00
Keyboard Shortcuts for Navigating Microsoft Access

Requirements

Download the Northwind database to follow along with examples in this course. The Northwind database is available through the Access application. Please see Lecture 2 for details.

Description

Microsoft Access Three Course Bundle:

→ Access: Customizing Tables, Forms, Reports & Action Queries

→ Microsoft Access Macros: Automate Your Access Database

→ Microsoft Access SQL: SQL for Non-Programmers

So, what's in this course for you?

:: Access Customizing Skills & Strategies ::

↳ Learning Microsoft Access tips will absolutely make your workday easier.

From importing and exporting data with Microsoft Excel, to restricting data that is entered into your tables.

Create cascading combo boxes that display information based off of data in another combo box.

You'll also find pro tips on using reports, and queries, documenting your database, and simplifying navigation.

:: Creating Macros for Saving Time ::

↳ Learn to create Macros for more control over the database, get work done faster, and feel efficient.

You don't need to know any VBA code, you just need a willingness to want to save time with macros, to upgrade your skills, and to invest a few hours of time in the process.

:: Learning How SQL Can Interact with Your Database ::

↳ This week you can start learning SQL, step by step, and improve your skills.

Learn to use SQL in your Access databases from the beginning. Select data, as well as filter, and sort. Learn to create table, and about joins. No prior SQL experience required.

This bundled course can be completed in hours, but the information can last a lifetime.

So if you are beyond the basic beginner stage in Access, and want a convenient way to learn, I invite you to enroll.

This is not an advanced Access course, though advanced users are welcome, and might benefit from lectures within the course.

Take a look at the course curriculum to help decide if this informative, easy-to-follow course is for you.

You only have MICROSOFT ACCESS DATABASE SKILLS to gain.

So Click The Take This Course Button On The Right
and become a better Microsoft Access User.

Who this course is for:

This Microsoft Access three course bundle is for anyone who wants to go beyond the basics of using Access. It is not for brand new users of Access or of databases. It can serve as a refresher for advanced users of Access, but is not designed to be an advanced level course.
Please look over the course curriculum when making your decision on enrolling in this course.
Although the course was created using Access 2013, 95% of the lectures also apply to Access 2010, and Access 2016. Access 2007 can be used for about 70% of this course.

Microsoft Access: Beyond the Basics of Access Bundle

What you'll learn

Explore related topics

Course content

Latest Access Beyond the Basics Quick Tip1 lecture • 1min

Welcome to Microsoft Access: Beyond the Basics of Access Bundle!2 lectures • 4min

Access: Customizing Tables, Forms, Reports & Action Queries1 lecture • 1min

Access Database Tables: Customizing Existing Tables16 lectures • 1hr 4min

Access Database Forms: Adding More Functionality6 lectures • 30min

Access Database Reports: Enhancing the Look & Feel6 lectures • 19min

Access Database Queries: Parameter, Action, Cross Tab, and Self Join Queries13 lectures • 50min

Access Database Start Up & Navigation: Customizing the User Interface5 lectures • 23min

Access Database Maintenance6 lectures • 21min

Additional Access Database Resources5 lectures • 23min

Requirements

Description

Who this course is for: