Access 2010 Advanced

Free Videos From This Course
What Will This Course Cover
Relational Databases Demystified
Using The Working Files
About The Author
Creating And Using Input Masks
Indexing - The Hows And Whys
Multiple Field Primary Keys
Selecting Unique Values
Use Of Parameter Queries
Adding A Calculated Field
Using iif In A Calculated Field
Creating A Cross Tab Query
A Cross Tab Without The Wizard
Why Change The Join Type In Queries
Viewing And Writing SQL
Introducing The Expression Builder
The Power Of The Sub Query
Generating A Union Query In Access

Getting Started
What Will This Course Cover
Relational Databases Demystified
Using The Working Files
About The MS Access Tutor

Advanced Table Design
Creating And Using Input Masks
Indexing - The Hows And Whys
Multiple Field Primary Keys

Advanced Queries
Selecting Unique Values
Use Of Parameter Queries
Adding A Calculated Field
Using iif In A Calculated Field
Creating A Cross Tab Query
A Cross Tab Without The Wizard
Why Change The Join Type In Queries
Viewing And Writing SQL
Introducing The Expression Builder
The Power Of The Sub Query
Generating A Union Query In Access

Action Queries
The Make Table Query - For Backups
The Make Table Query From Multiple Tables Of Data
Changing Data Using An Update Query
Update Query With A User Driven Parameter
Add Records To A Table Using The Append Query
Delete Records Using The Delete Query
Backup And Restore Data Using Action Queries

Advanced Form Design
Adding Linked Objects And Displaying On A Form
Sub Forms Unbound Or Bound
Using Tabs To Display Multiple Sub Form Data
Referencing Combo Box Unbound Columns
The NEW Navigation Forms
Creating A Form To Use As A Menu Or Dialog
Adding A Form Button With The Wizard
Creating Buttons WITHOUT The Wizard
Open Another Form-Filtered By Current Form (Lesson - 1)
Open Another Form-Filtered By Current Form (Lesson - 2)
Building A Search Form
Check Whether The Search Criteria Is Entered
Use Double Click To Open Related Data
Dynamically Changing The Row Source Of A Combo Or List Box

Advanced Reports
Creating A Report From Scratch Without The Wizard
Adding Images To The Report
Calculations On A Report
Sorting And Grouping A Report
Totals On Reports Groups
Creating And Adding Sub Reports
Concatenation With Carriage Returns
Adding A Chart Or Graph
A Chart Filtered By The Report Section
Pie Charts In Reports

Macros
Creating A New Macro
Example Functionality Of Macros
Assigning Macros To Buttons On Forms
Using if In A Macro To Control Program Flow
Commenting Your Macro Code For Future Reference
NEW - The Embedded Macro
Sub Macros And Their Uses
Trigger A Macro From The Ribbons
Controlling Startup Actions With The AutoExec Macro
Creating An AutoKeys Macro For Customizing Keyboard Shortcuts
Adding An OK/Cancel Confirmation Box

Database Utilities
Compact And Repair - A Useful Utility
Converting Access To Previous Versions
Saving A Backup Copy
Tracking Object Dependencies
The Start Up Settings

Application Making And Security
Main Menu Tidying Requirements
Restricted Access By Use Of The ACCDE Format
Download And Distribute Access 2010 Runtime
Encrypting And Password Protecting An Access Database
Splitting The Database In Two For Final Security

Access With SQL Server
Upgrade An Existing Application To Use SQL Server
Linking a New Database To SQL Server
Introducing The MS Access Project File
Running A Stored Procedure From The MS Access Project

Summary
What Have You Learned?