by | Released November 2011 | ISBN: 9781926873763

In this Advanced Microsoft Access 2010 Training video, popular Infinite Skills author Guy Vaccaro takes you beyond the basics of Microsoft Access 2010. Delving into advanced concepts and tools, Guy makes it easy to understand and use these features in your own databases and interfaces.Continuing where the Learning Microsoft Access 2010 training title left off, you jump right into advanced table design with indexing and input masks. You will learn how to create advanced queries using joins, unions, and sub queries. Additional topics such as advanced form design and reporting will allow you to better manage and display your data. A full chapter on Macros will make it easier than ever to manage your data in Access 2010. This is just the tip of the iceberg of what this advanced training video for Access 2010 will teach you.By the conclusion of this training video, you will be fully capable of creating, managing and displaying your Microsoft Access 2010 data, and have an in-depth understanding of the tools and features that are available to you in this powerful software. Extensive working files are included to allow you to work alongside the author in the training course. Show and hide more Publisher resources Download Example Code

1. Getting Started
   • What Will This Course Cover 00:02:41
   • Relational Databases Demystified 00:07:54
   • Using The Working Files 00:04:12
   • About The Author 00:01:18
2. Advanced Table Design
   • Creating And Using Input Masks 00:09:02
   • Indexing - The Hows And Whys 00:07:31
   • Multiple Field Primary Keys 00:02:48
3. Advanced Queries
   • Selecting Unique Values 00:04:36
   • Use Of Parameter Queries 00:07:36
   • Adding A Calculated Field 00:05:35
   • Using iif In A Calculated Field 00:04:45
   • Creating A Cross Tab Query 00:05:20
   • A Cross Tab Without The Wizard 00:03:32
   • Why Change The Join Type In Queries 00:07:09
   • Viewing And Writing SQL 00:07:50
   • Introducing The Expression Builder 00:06:45
   • The Power Of The Sub Query 00:06:47
   • Generating A Union Query In Access 00:06:44
4. Action Queries
   • The Make Table Query - For Backups 00:04:16
   • The Make Table Query From Multiple Tables Of Data 00:05:22
   • Changing Data Using An Update Query 00:07:06
   • Update Query With A User Driven Parameter 00:03:53
   • Add Records To A Table Using The Append Query 00:03:46
   • Delete Records Using The Delete Query 00:03:51
   • Backup And Restore Data Using Action Queries 00:07:08
5. Advanced Form Design
   • Adding Linked Objects And Displaying On A Form 00:07:01
   • Sub Forms Unbound Or Bound 00:09:00
   • Using Tabs To Display Multiple Sub Form Data 00:08:08
   • Referencing Combo Box Unbound Columns 00:05:18
   • The NEW Navigation Forms 00:04:25
   • Creating A Form To Use As A Menu Or Dialog 00:04:02
   • Adding A Form Button With The Wizard 00:08:08
   • Creating Buttons WITHOUT The Wizard 00:08:37
   • Open Another Form-Filtered By Current Form (Method 1) 00:08:04
   • Open Another Form-Filtered By Current Form (Method 2) 00:06:56
   • Building A Search Form 00:08:57
   • Check Whether The Search Criteria Is Entered 00:07:35
   • Use Double Click To Open Related Data 00:04:55
   • Dynamically Changing The Row Source Of A Combo Or List Box 00:08:16
6. Advanced Reports
   • Creating A Report From Scratch Without The Wizard 00:08:39
   • Adding Images To The Report 00:04:21
   • Calculations On A Report 00:03:40
   • Sorting And Grouping A Report 00:10:09
   • Totals On Reports Groups 00:06:26
   • Creating And Adding Sub Reports 00:10:00
   • Concatenation With Carriage Returns 00:08:30
   • Adding A Chart Or Graph 00:06:21
   • A Chart Filtered By The Report Section 00:06:01
   • Pie Charts In Reports 00:08:30
7. Macros
   • Creating A New Macro 00:04:10
   • Example Functionality Of Macros 00:05:46
   • Assigning Macros To Buttons On Forms 00:05:09
   • Using if In A Macro To Control Program Flow 00:09:08
   • Commenting Your Macro Code For Future Reference 00:02:49
   • NEW - The Embedded Macro 00:05:02
   • Sub Macros And Their Uses 00:06:17
   • Trigger A Macro From The Ribbons 00:07:04
   • Controlling Startup Actions With The AutoExec Macro 00:07:50
   • Creating An AutoKeys Macro For Customizing Keyboard Shortcuts 00:06:25
   • Adding An OK/Cancel Confirmation Box 00:04:31
8. Database Utilities
   • Compact And Repair - A Useful Utility 00:02:42
   • Converting Access To Previous Versions 00:03:02
   • Saving A Backup Copy 00:01:04
   • Tracking Object Dependencies 00:04:04
   • The Start Up Settings 00:05:19
9. Application Making And Security
   • Main Menu Tidying Requirements 00:04:47
   • Restricted Access By Use Of The ACCDE Format 00:03:57
   • Download And Distribute Access 2010 Runtime 00:02:11
   • Encrypting And Password Protecting A 2010 Database 00:04:11
   • Splitting The Database In Two For Final Security 00:07:59
10. Access With SQL Server
    • Upgrade An Existing Application To Use SQL Server 00:07:29
    • Linking a New Database To SQL Server 00:06:37
    • Introducing The Access Project File 00:07:21
    • Running A Stored Procedure From The Access Project 00:05:29
11. Summary
    • What Have You Learned? 00:03:05
Show and hide more