Microsoft Access: Beyond the Basics of Access Bundle
4.5 (146 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,679 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access: Beyond the Basics of Access Bundle to your Wishlist.

Add to Wishlist

Microsoft Access: Beyond the Basics of Access Bundle

Three Access database courses in one. (1) Work Faster with Quick Tips, (2) Script SQL Queries, (3) Automate w/Macros
4.5 (146 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,679 students enrolled
Created by IsáBel Harrison
Last updated 4/2017
Current price: $10 Original price: $195 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 9 hours on-demand video
  • 16 Articles
  • 45 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • TIME-SAVING Database Tips & Tricks
  • AUTOMATE Your Database with MACROS
  • 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!
View Curriculum
  • 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.

Microsoft Access Three Course Bundle:

→ Access: Time Saving Tips That Will Boost Your Productivity

→ Microsoft Access Macros: Automate Your Access Database

→ Microsoft Access SQL: SQL for Non-Programmers

  • Click the Green "Take This Course" button to Learn Microsoft Access Tips, Macros, and SQL from Anywhere, Anytime

So, what's in this course for you?

:: Access Tips & 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.


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

Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 188 Lectures Collapse All 188 Lectures 11:41:22
Latest Access 2013 Beyond the Basics Quick Tip
1 Lecture 00:11

Get the latest Quick Tips from Microsoft Access 2013: Beyond the Basics Bundle

Preview 00:11
Welcome to Microsoft Access 2013: Beyond the Basics of Access Bundle!
2 Lectures 04:12

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
Preview 01:19

In this course you will be able to follow along using the Northwind database. This database can be downloaded from within Microsoft Access.

Preview 02:53
Access Database Time Savers
1 Lecture 00:30
Access Database Time Savers - Access Tables
16 Lectures 55:50

Temporarily or permanently move data from your Access database into an Excel workbook.

Preview 07:12

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

Preview 05:00

What you should be aware of before importing data from Microsoft Excel into existing tables in your Access database

Appending Data from Excel into an Existing Access Table
2 pages

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.

Linking to Data in Excel

Use tables or queries as the data source for form letters, e-mail messages, mailing labels, or envelopes.

Performing a Mail Merge with Microsoft Word

Learn how to format your Access database text and memo fields

Formatting Text and Memo Fields

Learn how to format your Access database number and currency fields

Formatting Number Fields
3 pages

Create custom formatting for the Date field type.

Formatting Date Fields

Define how users must enter data in specific fields. This will help maintain consistency, and to make your database easier to manage.

Understanding the Input Mask Wizard

Create your own, custom input masks to define how users must enter data.

Creating Your Own Custom Input Masks
2 pages

Save time by creating default values for fields.

Setting a Field's Default Value

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.

Field Validation / Controlling Data Entry

Create user-friendly error messages.

Creating Your Own Custom Error Messages

Learn to filter by selection, as well as filter by form.

Advanced Table Filters

To ensure that you data stays synchronized, enforce referential integrity between tables.

Referential Integrity

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
Access Database Time Savers - Access Forms
6 Lectures 28:32

Specify the order that form controls respond to the TAB key.

Setting a Form's Tab Order

Selectively highlight data on your form to make it easier to understand.

Using Conditional Formatting to Highlight Form Information

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.

Creating Cascading Combo Boxes

Make selecting a value easy with Option Groups.

Adding Option Groups

Reduce clutter on your form, and make it easier to work with your data.

Get Organized with Tabs

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
Access Database Time Savers - Access Reports
6 Lectures 17:48

Make your data easier to understand with groups. Adding totals to the end of groups reduces the need for manual calculations.

Grouping and Totaling Reports without the Wizard

Selectively highlight data on your report to make it easier to understand.

Conditional Formatting

Learn how to add a logo, or image to a report in your Access databases

Adding a Logo or Background Image

Automatically adjust controls vertically to print or preview all the data that the control contains.

Setting CanGrow & CanShrink Properties

Controlling Page Breaks

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
Access Database Time Savers - Access Queries
13 Lectures 43:33

Use special characters to locate multiple items with similar, but not identical data.

Adding Wildcards to Queries

Use the same query over and over again without having to open it in Design view to edit the criteria.

Parameter Queries

Use built-in functions, or create expressions to calculate the fields in your query.

Queries with Calculated Fields

Unique Values v. Unique Records, what are they, and why should you care?

Unique Values v Unique Records
1 page

Add, change, or delete the information in an existing record

Update Queries

Append Queries - UPDATED
3 pages

Quickly delete a lot of data

Delete Queries

Copy the data in a table or archive data.

Make Table Queries

Quickly identify records in one of the tables that have no corresponding records in the other table.

Find Unmatched Records

Learn how to quickly find duplicate records within the tables of your Microsoft Access database

Find Duplicate Records

Structure summary data to make it easier to read and understand.

Crosstab Queries

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.

Self Join

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
2 pages
Access Database Time Savers - Access Start up & Navigation
5 Lectures 22:21

Personalize the ribbon the way that you want.

Creating a Custom Tab on the Ribbon

Organize your database objects the way that you want.

Creating Custom Groups in the Navigation Pane

Hide the Navigation Pane to increase your workspace
Hide the Navigation Pane

Switchboards help users to locate the necessary tables, forms, reports, and queries they use most often.

Creating a Switchboard Using the Switchboard Manager

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
Access Database Time Savers - Access Database Maintenance
6 Lectures 20:01

Print documentation of your database's design for an offline reference.

Documenting Your Database

Learn which database objects interact with or depend on other objects in the database.

Finding Dependent Objects

Create a relational database without having to know relational database design principles.

Table Analyzer

Learn how to create a backup of your Microsoft Access databases

Backup and Restore Desktop Databases

Regular maintenance of your Access databases is a must.

Compact and Repair Databases

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
Access Database Time Savers - Additional Access Database Resources
5 Lectures 14:59

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


Find the difference between two dates


Add time to a date value


Keyboard Shortcuts for Text and Data

Keyboard Shortcuts for Text and Data
3 pages

Keyboard Shortcuts for Navigating Microsoft Access

Keyboard Shortcuts for Navigation
5 pages
22 More Sections
About the Instructor
IsáBel Harrison
4.7 Average rating
822 Reviews
14,648 Students
15 Courses
Computer Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.

Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, because Change Matters, Growth Matters.