Advanced Microsoft Access 2013

Table of contents

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