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 74ONUS 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.


Homepage

https://www.udemy.com/course/access-2013-tips/