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

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

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

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

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

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.

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

Learn how to format your Access database text and memo fields

Learn how to format your Access database number and currency fields

Create custom formatting for the Date field type.

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

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

Save time by creating default values for fields.

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.

Create user-friendly error messages.

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

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

You've seen it, now do it!

Test your skills with this section's lesson lab.

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

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

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.

Make selecting a value easy with Option Groups.

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

You've seen it, now do it!

Test your skills with this section's lesson lab.

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

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

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

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

Control the pagination of a report.

You've seen it, now do it!

Test your skills with this section's lesson lab.

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.

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

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

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

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

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

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

Quickly delete a lot of data

Copy the data in a table or archive data.

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

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

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

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.

You've seen it, now do it!

Test your skills with this section's lesson lab.

Get a brief overview on macros in Microsoft Access

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

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.

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.

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

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

You've seen it, now do it!

Test your skills with this section's lesson lab.

Tailor the Ribbon to your needs, reducing clutter and improving your productivity within Microsoft Access.

Group related database objects together in the Navigation Pane to improve organization and accessibility.

Maximize your workspace by temporarily hiding the Navigation Pane when you're focused on working with specific objects.

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

You've seen it, now do it!

Test your skills with this section's lesson lab.

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

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

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

Learn how to create a backup of your Microsoft Access databases

Regular maintenance of your Access databases is a must.

You've seen it, now do it!

Test your skills with this section's lesson lab.

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

Add time to a date value

Keyboard Shortcuts for Text and Data

Keyboard Shortcuts for Navigating Microsoft Access