Access: Time Saving Tips That Will Boost Your Productivity

How to work faster in your Access databases, even if you have been using Access for years.
4.6 (13 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,509 students enrolled
$19
$105
82% off
Take This Course
  • Lectures 76
  • Length 4.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course Description

*UPDATED: Nov. 13, 2016*


Imagine a Monday morning. You've just gotten in the office, said your "Hellos", your "How was your weekends", and you sit at your desk and start your computer.

You push your cup of green tea, or coffee to the side. You start up Access, and you pause.

You have data to enter, or reports to run and e-mail, or both.

Maybe you need to write queries.

If you have ever hesitated because you thought it would take too long, or it was just too cumbersome, you might be surprised on the amount of time that can be saved, the data entry errors that will never happen, with the knowledge of just a few tips and tricks.


Here's how to get started:

Do you or your co-workers use Microsoft Excel, but need your data imported into Access?
Take a look at Section 2: Tables.

Are users entering in data that is not appropriate for the fields, or do they need extra help knowing what data to enter?

Do you want to create drop-down boxes that display information based off of data in another drop-down box?

This course will show you how.

Grouping, totaling, and setting page breaks for reports in Access can, at times, be difficult.
Watch the lectures in Section 4: Reports to help you.

From wildcards, to parameter queries, to action queries, go beyond the basics with Section 5: Queries.

Macros will save you time with Access databases. Get an introductions to the Macro Builder Window, and learn to create a few macros in Section 7.

Learn how to help users quickly navigate to the tables, forms, and reports that they need most by completing the lectures in Section 8: Start up & Navigation.

Maintenance is so important to the life of your database, so take a look at Section 9, for an introduction to the tools that you need to know to keep your database running smoothly.


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

So if you are beyond the beginner stage in Access, and want a convenient way to learn Access Tips & Tricks, 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 can only GAIN MICROSOFT ACCESS DATABASE SKILLS.

So Click The Take This Course Button On The Right & I'll See You In Class!

What are the 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 3 for details.

What am I going to get from this course?

  • Import and Export Data Using Microsoft Excel
  • Set Field Validations
  • Format Fields
  • Create Cascading Combo Boxes
  • Conditionally Format Forms & Reports
  • Create Parameter Queries
  • Create Action Queries
  • Create Simple Macros
  • Customize the Access Environment
  • Understand Database Maintenance Tools

What is the target audience?

  • This Microsoft Access Tips & Tricks course 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, the lectures also apply to Access 2010, and Access 2016. Access 2007 can be used for about 85% of this course.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Latest Access Time Saving Quick Tip
Article

Get the latest Quick Tips for Access 2013 Tips & Tricks: Time Saving Questions Answered

Section 2: Welcome to Access Tips
01:27

Welcome to this Microsoft Access Tips & Tricks course on Udemy.com

1 page

Steps to help you make the most out of this Microsoft Access Tips & Tricks Udemy.com course

02:53

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

Section 3: Access Database Tables
07:12

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

05: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

2 pages

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

03: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.

06:56

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

04:52

Learn how to format your Access database text and memo fields

3 pages

Learn how to format your Access database number and currency fields

03:41

Create custom formatting for the Date field type.

04:46

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

2 pages

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

03:42

Save time by creating default values for fields.

03: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.

02:04

Create user-friendly error messages.

06:12

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

03:51

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

1 page

You've seen it, now do it!

Test your skills with this section's lesson lab.

Section 4: Access Database Forms
03:44

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

03:43

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

07: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.

09:28

Make selecting a value easy with Option Groups.

04:29

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

1 page

You've seen it, now do it!

Test your skills with this section's lesson lab.

Section 5: Access Database Reports
07:21

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

04:18

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

Article

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

01:40

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

03:58

Control the pagination of a report.

1 page

You've seen it, now do it!

Test your skills with this section's lesson lab.

Section 6: Access Database Queries
1 page

If you are enjoying this Microsoft Access Tips & Tricks course, please leave a positive comment, and a rating, which you can do at the top right hand corner of the Course Dashboard.

It takes less than a minute and it is a huge help to other students, and to me too.

08:41

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

06:19

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

04:57

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

1 page

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

07:03

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

3 pages

Add new records to an existing table by using data from other sources.

03:54

Quickly delete a lot of data

01:55

Copy the data in a table or archive data.

02:04

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

01:32

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

03:01

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

04: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.

2 pages

You've seen it, now do it!

Test your skills with this section's lesson lab.

Section 7: Save Time with Macros in Access Databases
1 page

Get a brief overview on macros in Microsoft Access

03:12

Become familiar with the Microsoft Access macros builder window. This is your first step to creating macros that will save you time in Access.

05:34

You will use the Before Change event to perform any actions that you want to occur before a record is changed. The Before Change event is most often used to perform validation, to raise custom error messages, and to populate fields.

04:33

When you have contacts in your database, but not yet in your Microsoft Outlook Contacts folder, use this macro to export the contact for you.

06:45

Create a button to quickly e-mail reports as PDFs, HTML documents, and more.

01:02

Do you need a macro to run when your database loads? Here is the easy trick to making that happen.

1 page

You've seen it, now do it!

Test your skills with this section's lesson lab.

Section 8: Access Database Start up & Navigation
08:29

Personalize the ribbon the way that you want.

04:01

Organize your database objects the way that you want.

01:43

Hide the Navigation Pane to increase your workspace

08:08

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

1 page

You've seen it, now do it!

Test your skills with this section's lesson lab.

Section 9: Access Database Maintenance
04:03

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

02:08

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

08:02

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

02:50

Learn how to create a backup of your Microsoft Access databases

02:58

Regular maintenance of your Access databases is a must.

1 page

You've seen it, now do it!

Test your skills with this section's lesson lab.

Section 10: Additional Access Database Resources
07: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

03:06

Find the difference between to dates

04:12

Add time to a date value

3 pages

Keyboard Shortcuts for Text and Data

5 pages

Keyboard Shortcuts for Navigating Microsoft Access

Article

For those new to Access 2013, this free guide provided by Microsoft has useful tips to help you find your way around.

Section 11: SNEAK PEAK: Microsoft Access: SQL for Non-Programmers
The SELECT Syntax
02:11
SELECT Statements
10:32
Aliasing Columns
03:55
Lesson Lab
2 pages
Section 12: Next Steps
1 page

What can you do, now that the course is complete, to help you with your Microsoft Access databases?

Here are your next steps.

Article

Complete one of my courses within 10 days of enrollment, get another one of my courses 100% free.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

IsáBel Harrison, 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.


Ready to start learning?
Take This Course