by | Released November 2013 | ISBN: 9781771371803

In this Advanced Microsoft Access 2013 training course, expert instructor Guy Vaccaro will take you beyond the fundamentals of this powerful Microsoft program. This course is designed for users that already have a basic working knowledge of Microsoft Access.In this video tutorial, you will jump right into learning advanced table design with indexing and input masks. You will learn how to create advanced queries and action, and how to use SQL (standard query language). Guy will cover topics such as advanced form design, how to create an advanced report, and creating and using bound and unbound subforms. This video based training course will teach you how to create and use a Macro, a Sub Macro, and how to configure a Macro. Guy will show you how to turn a database into an application, and how to back up a database and convert Access databases to and from previous versions. Finally, you will learn how to create a custom web app and how to use Access with external applications.By the conclusion of this computer based training course, you will be fully capable of creating, managing, and displaying your Microsoft Access 2013 data, and have an in-depth understanding of the many tools and techniques available to you in this Microsoft program. Working files are included, allowing you to follow along with the author throughout the lessons. Show and hide more Publisher resources Download Example Code

1. Access Advanced Introduction
   • What Will You Learn? 00:05:22
   • Relational Databases Explained 00:05:03
   • Working Files Explained 00:02:51
   • About The Author 00:01:32
2. Advanced Table Design
   • Create And Use Input Masks 00:09:02
   • Indexing In Access Tables 00:06:55
   • Multiple Field Primary Keys 00:04:43
   • Extended Field Properties 00:05:39
   • Analyze A Table For Improved Performance 00:08:17
3. Advanced Querying
   • Selecting Unique And Distinct Values 00:03:52
   • Parameter Queries 00:06:20
   • Adding A Formula Field 00:07:55
   • Using If Conditions Within A Formula Field 00:07:13
   • Altering Join Types Between Tables 00:05:28
   • Cross Tab With The Wizards Help 00:04:30
   • Cross Tab Without Wizards 00:07:52
   • Introducing The Expression Builder 00:05:49
4. Action Queries
   • Change Data In Tables With An Action Query 00:08:48
   • Adding A Parameter To Update Queries 00:06:22
   • Make A New Table From An Existing Table Query 00:04:20
   • Make A Single Table From Multiple Table Data 00:04:31
   • Amending And Appending Imported Data 00:06:55
   • Deleting Records With The Delete Query 00:05:37
   • Backup And Restore By Use Of Action Queries 00:07:27
5. Standard Query Language
   • SQL Syntax And Using It In Access Queries 00:06:16
   • Filtering Your SQL Statement 00:05:11
   • Linking Multiple Tables In SQL 00:04:47
   • Grouping Data Through SQL 00:04:59
   • Using Formula In SQL Select Statements 00:04:09
   • The Powerful Subquery 00:07:07
   • Generating A Union Query In Access 00:05:50
   • Action SQL Statements 00:06:27
6. Advanced Form Design
   • Adding New Bound Data Objects 00:05:30
   • Adding Unbound Objects 00:06:43
   • Manually Configuring Combo Boxes 00:07:26
   • Referencing The Unbound Columns Of Combo Boxes 00:08:35
   • Introducing Navigation Forms 00:05:37
   • Create Non Data Forms As Menus And Dialogs 00:09:06
   • Creating Command Buttons For Forms 00:07:03
   • Open One Form Filtered By Another 00:04:51
   • Creating Buttons Without The Wizard 00:06:50
   • Using Double Click Instead Of Click 00:06:44
   • Building A Search Form 00:07:28
   • Dynamic List Box Filtering 00:09:15
   • Adding A Data Chart To A Form 00:06:49
7. Advanced Reports
   • Creating A Report Without The Wizard 00:08:01
   • Add Titles And Images 00:03:44
   • Formatting Lines And Background Colors 00:06:21
   • Page Numbering And Displaying The Current Date 00:07:50
   • Add Calculations To A Report 00:06:19
   • Sorting And Grouping Data 00:08:09
   • Adding Totals To Groups 00:09:44
   • Creating Summary Reports 00:07:25
   • Multiple Lines In A Concatenated Field 00:08:43
   • Open A Report Filtered By A Form 00:06:00
   • Adding A Chart To A Report 00:06:19
   • Charts Filtered By The Reports Grouping 00:05:43
8. Subforms And Reports
   • Subforms Can Be Bound Or Unbound 00:04:55
   • Creating And Using Unbound Subforms 00:06:34
   • Create A Bound Subform 00:05:51
   • Form Tabs For Displaying Multiple Subform Data 00:08:13
   • Adding A Bound Sub Report 00:06:16
   • Clever Use Of Unbound Reports 00:06:46
9. Macros
   • What Is A Macro 00:03:11
   • Steps To Creating A Macro 00:06:02
   • Assign Macros To Buttons On Forms 00:06:30
   • Assign A Macro To A Ribbon Icon 00:04:21
   • Use Of Sub Macros 00:05:13
   • Assigning Keyboard Shortcuts To Macros 00:05:43
   • Open A Form Filtered Through A Macro 00:07:49
   • Using An If To Control The Flow Of Actions 00:06:09
   • Running Action SQL From A Macro 00:07:39
   • Adding Comments To Macros 00:04:29
   • Configure A Macro To Run When The Database Opens 00:06:00
   • Adding An OK Confirmation Step 00:06:35
10. Database Utilities
    • Why Do I Need To Compact And Repair? 00:06:38
    • Converting Access Databases To And From Previous Versions 00:04:42
    • Backing Up A Database 00:02:21
    • Tracking Dependent Objects 00:04:03
11. Turn A Database Into An Application
    • Creating A Welcome Screen 00:04:41
    • Setting The Options For Database Startup 00:04:56
    • Encrypting And Password Protecting Your Application 00:03:31
    • Restrict Access To Some Objects By Use Of The ACCDE Format 00:04:26
    • Why Split A Database In Two? 00:05:05
    • Download, Distribute And Test Access Runtime 00:04:49
    • Creating Your Own Ribbon And Tabs 00:07:10
    • Adding Further Commands To A Custom Ribbon 00:07:40
12. Custom Access Web Apps
    • What Do I Need To Make Custom Web Apps? 00:01:59
    • Creating A New Custom Web App 00:04:23
    • Adding And Editing Tables 00:06:24
    • Editing The Default View Forms 00:06:12
    • Creating New View Forms 00:07:45
    • Queries In A Custom Web App 00:05:10
    • Clever Action Buttons 00:03:35
13. Access With External Applications
    • Using Excel As Table Data 00:05:35
    • Access Data In Excel Pivot Tables 00:06:06
    • Mail Merging In Word Using Access Data 00:06:32
    • Linking To SQL Server Tables 00:06:59
14. Summary
    • Course Wrap-Up 00:06:36
Show and hide more