Access: Time Saving Tips That Will Boost Your Productivity
4.9 (21 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,905 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access: Time Saving Tips That Will Boost Your Productivity to your Wishlist.

Add to Wishlist

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.9 (21 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,905 students enrolled
Created by Isá Harrison
Last updated 7/2017
English
Current price: $10 Original price: $105 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 4 Articles
  • 25 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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.
Description

For people who are almost (but not quite) satisfied with their own Access skills - and can't figure out where to begin.

  • If you already use Access well, but want to automate tasks, see Section 7
  • Want to create queries where the criteria can be updated on the fly, see Lecture 35.
  • If you have data in Excel that you want to link to, see Lecture 8.
  • Are you ready for SQL? Find out and take a sneak peak with Section 11.
  • If you would like a print out of Keyboard shortcuts to help you work faster, see Lecture 68, and 69.
  • How to backup and restore your database, see Lecture 62
  • Need to tweek your reports a bit, see Section 5
  • If you need to create drop-down boxes  where the selection in one combo box limits the choices in the next, see Lecture 23


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!

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
76 Lectures
04:38:31
+
Latest Access Time Saving Quick Tip
1 Lecture 00:13

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

Preview 00:13
+
Welcome to Access Tips
3 Lectures 04:20

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

Preview 01:27

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

Preview 1 page

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

Importing Data from Excel into a New Table
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
03:49

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
06:56

Learn how to format your Access database text and memo fields

Formatting Text and Memo Fields
04:52

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

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

Understanding Input Mask Wizard
04:46

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

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

Create user-friendly error messages.

Creating Your Own Custom Error Messages
02:04

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

Advanced Table Filters
06:12

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

Referential Integrity
03:51

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
+
Access Database Forms
6 Lectures 28:32

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

Setting a Form's Tab Order
03:44

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

Using Conditional Formatting to Highlight Form Information
03:43

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

Make selecting a value easy with Option Groups.

Adding Option Groups
09:28

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

Get Organized with Tabs
04:29

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
+
Access Database Reports
6 Lectures 17:52

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

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

Conditional Formatting
04:18

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

Adding a Logo or Background Image
00:35

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

Setting CanGrow & CanShrink Properties
01:40

Control the pagination of a report.

Controlling Page Breaks
03:58

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
+
Access Database Queries
14 Lectures 43:33

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.

How Are You Enjoying the Course?
1 page

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

Adding Wildcards to Queries
08:41

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

Parameter Queries
06:19

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

Queries with Calculated Fields
04:57

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

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

Append Queries
3 pages

Quickly delete a lot of data

Delete Queries
03:54

Copy the data in a table or archive data.

Make Table Queries
01:55

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

Find Unmatched Records
02:04

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

Find Duplicate Records
01:32

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

Crosstab Queries
03:01

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

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
2 pages
+
Save Time with Macros in Access Databases
7 Lectures 21:06

Get a brief overview on macros in Microsoft Access

What are Macros?
1 page

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

Getting Familiar with the Macro Builder Window
03:12

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.

Data Macro for Tables - Using Before Change
05:34

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.

Form Macro - Exporting to Outlook
04:33

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

Report Macro - E-mailing a Report
06:45

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

Running Macros When Your Database Starts
01:02

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
+
Access Database Start up & Navigation
5 Lectures 22:21

Personalize the ribbon the way that you want.

Creating a Custom Tab on the Ribbon
08:29

Organize your database objects the way that you want.

Creating Custom Groups in the Navigation Pane
04:01

Hide the Navigation Pane to increase your workspace

Hide the Navigation Pane
01:43

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

Creating a Switchboard Using the Switchboard Manager
08:08

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
+
Access Database Maintenance
6 Lectures 20:01

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

Documenting Your Database
04:03

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

Finding Dependent Objects
02:08

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

Table Analyzer
08:02

Learn how to create a backup of your Microsoft Access databases

Backup and Restore Desktop Databases
02:50

Regular maintenance of your Access databases is a must.

Compact and Repair Databases
02:58

You've seen it, now do it!

Test your skills with this section's lesson lab.

Exercise: Lesson Lab
1 page
+
Additional Access Database Resources
6 Lectures 15:08

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

IIf Function
07:41

Find the difference between to dates

DateDiff Function
03:06

Add time to a date value

DateAdd Function
04:12

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

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

Access 2013 Quick Start Guide
00:09
2 More Sections
About the Instructor
Isá Harrison
4.6 Average rating
957 Reviews
15,276 Students
16 Courses
Results & Convenience | 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.