Access: Customizing Tables, Forms, Reports & Action Queries

Learn Microsoft Access Skills & Work Faster in Your Databases. Bonus Sections on Macros, Maintenance, and Navigation.

What you'll learn

70 Lectures Designed to Boost Your Access Database Skills

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

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

Expand your Access database technical skills.Customizing Existing TablesAdd More Functionality to Your Access FormsEnhancing the Look & Feel of Your ReportsCreate Parameter, Action, Cross Tab, and Self Join Queriesas well as Duplicate, and Non Matching QueriesSave Time with Macros in Access DatabasesCustomizing the User InterfaceCreate Switchboards for Easy NavigationLearn About Access Database Maintenanceand Get Additional Access Database ResourcesThis 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 more Access skill, 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!

Overview

Section 1: Latest Access Time Saving Quick Tip

Lecture 1 ​Import from Excel to Access

Section 2: Welcome to Access: Customizing Tables, Forms, Reports & Action Queries

Lecture 2 Downloading the Exercise Database

Lecture 3 Steps for Success

Section 3: Access Database Tables: Customizing Existing Tables

Lecture 4 Exporting Data from an Access Table to an Excel Spreadsheet

Lecture 5 Importing Data from Excel into a New Table

Lecture 6 Appending Data from Excel into an Existing Access Table

Lecture 7 Linking to Data in Excel

Lecture 8 Performing a Mail Merge with Microsoft Word

Lecture 9 Formatting Text and Memo Fields

Lecture 10 Formatting Number Fields

Lecture 11 Formatting Date Fields

Lecture 12 Understanding Input Mask Wizard

Lecture 13 Creating Your Own Custom Input Masks

Lecture 14 Setting a Field's Default Value

Lecture 15 Field Validation / Controlling Data Entry

Lecture 16 Creating Your Own Custom Error Messages

Lecture 17 Advanced Table Filters

Lecture 18 Referential Integrity

Lecture 19 Exercise: Lesson Lab

Section 4: Access Database Forms: Adding More Functionality

Lecture 20 Setting a Form's Tab Order

Lecture 21 Using Conditional Formatting to Highlight Form Information

Lecture 22 Creating Cascading Combo Boxes

Lecture 23 Adding Option Groups

Lecture 24 Get Organized with Tabs

Lecture 25 Exercise: Lesson Lab

Section 5: Access Database Reports: Enhancing the Look & Feel

Lecture 26 Grouping and Totaling Reports without the Wizard

Lecture 27 Conditional Formatting

Lecture 28 Adding a Logo or Background Image

Lecture 29 Setting CanGrow & CanShrink Properties

Lecture 30 Controlling Page Breaks

Lecture 31 Exercise: Lesson Lab

Section 6: Access Database Queries: Parameter, Action, Cross Tab, and Self Join Queries

Lecture 32 How Are You Enjoying the Course?

Lecture 33 Adding Wildcards to Queries

Lecture 34 Parameter Queries

Lecture 35 Queries with Calculated Fields

Lecture 36 Unique Values v Unique Records

Lecture 37 Update Queries

Lecture 38 Append Queries

Lecture 39 Delete Queries

Lecture 40 Make Table Queries

Lecture 41 Find Unmatched Records

Lecture 42 Find Duplicate Records

Lecture 43 Crosstab Queries

Lecture 44 Self Join

Lecture 45 Exercise: Lesson Lab

Section 7: Save Time with Macros in Access Databases

Lecture 46 What are Macros?

Lecture 47 Getting Familiar with the Macro Builder Window

Lecture 48 Data Macro for Tables - Using Before Change

Lecture 49 Form Macro - Exporting to Outlook

Lecture 50 Report Macro - E-mailing a Report

Lecture 51 Running Macros When Your Database Starts

Lecture 52 Exercise: Lesson Lab

Section 8: Access Database Start Up & Navigation: Customizing the User Interface

Lecture 53 Creating a Custom Tab on the Ribbon

Lecture 54 Creating Custom Groups in the Navigation Pane

Lecture 55 Hide the Navigation Pane

Lecture 56 Creating a Switchboard Using the Switchboard Manager

Lecture 57 Exercise: Lesson Lab

Section 9: Access Database Maintenance

Lecture 58 Documenting Your Database

Lecture 59 Finding Dependent Objects

Lecture 60 Table Analyzer

Lecture 61 Backup and Restore Desktop Databases

Lecture 62 Compact and Repair Databases

Lecture 63 Exercise: Lesson Lab

Section 10: Additional Access Database Resources

Lecture 64 IIf Function

Lecture 65 DateDiff Function

Lecture 66 DateAdd Function

Lecture 67 Keyboard Shortcuts for Text and Data

Lecture 68 Keyboard Shortcuts for Navigation

Section 11: SNEAK PEAK: Microsoft Access: SQL for Non-Programmers

Lecture 69 The SELECT Syntax

Lecture 70 SELECT Statements

Lecture 71 Aliasing Columns

Lecture 72 Lesson Lab

Section 12: Next Steps

Lecture 73 Next Steps for Success

Section 13: Course Coupons

Lecture 74 [BONUS LECTURE] How to Save Money While You Learn.

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.