Microsoft Access Advanced 2016

Video Description

The ultimate next step for anyone interested in supercharging their Microsoft Access and data analysis skills

About This Video

  • Master Microsoft Access and explore the use of VBA, forms, and queries
  • Master Microsoft Access and complete projects on time and within budget

In Detail

In today's data-driven world, effective data management is crucial, with no room for error. Your Microsoft-certified professional trainer will show you how to use macros, advanced forms and queries, and other tools to create a professional, working database. Follow along as you learn to create and maintain macros, then see how to effectively link to other data sources.

Master helpful techniques that allow you to link, report, and package your data quickly, and discover how to split a database by splitting the front end and back end.

With this informative course, you'll learn the skills you need to make an impact with sleek, high-performing databases that help you do your job efficiently and competently.

Publisher Resources

Download Example Code

Table of Contents

  1. Chapter 1 : Introduction to Microsoft Access 2016 Advanced
    1. Course Overview and Content 00:06:51
  2. Chapter 2 : Primary Keys and Indexes
    1. Primary Keys and Indexing Rules and Guidelines 00:12:15
    2. More About Indexes 00:09:07
  3. Chapter 3 : Using Datasheet View
    1. Setting Up Northwind Database 00:04:44
    2. Working in a Datasheet View 00:13:07
    3. Customizing Datasheet View and Advanced Sorting and Filtering 00:16:11
    4. Subdatasheets 00:11:04
    5. Exercise 01 00:01:07
  4. Chapter 4 : Linking to Other Access Databases
    1. Linking Two Tables to Other Access Databases 00:15:38
  5. Chapter 5 : Using ODBC and SQL Server
    1. Acquiring and Installing SQL Server Express 00:14:31
    2. Setting Up SQL Server Database 00:14:57
    3. Exercise 2 00:01:16
  6. Chapter 6 : Splitting an Access Database
    1. Splitting an Access Database into Front-end and Back-end Databases 00:12:04
    2. Converting Shared Table into Local Table; Moving Back-end Database 00:13:55
    3. Exercise 03 00:01:58
    4. Addressing Multi-users Issues When Sharing Data 00:16:04
  7. Chapter 7 : Macros
    1. Basics of Macros 00:13:36
    2. Macros on Events; AutoExec 00:14:34
    3. More About AutoExec; Bypassing AutoExec 00:16:21
    4. Macro Security Settings 00:08:37
    5. Exercise 04 00:05:43
  8. Chapter 8 : The Ribbon
    1. Customizing the Ribbon and Quick Access Tool 00:13:56
  9. Chapter 9 : Visual Basic for Applications in Access 2016
    1. Convert Macros to VBA; VBA Editor and Property Windows 00:14:27
    2. VBA Modules; Running Code and Error Handling 00:16:32
    3. Creating Modules; Subs, Functions, Intellisense and Variables 00:14:47
    4. Scope, Variable Naming and Strings 00:15:18
    5. Standard Functions; Logical, Case and Loop Statements 00:15:41
  10. Chapter 10 : Access Events Model
    1. Adding Events to Assets Database 00:14:35
    2. Exercise 05 00:02:20
    3. Common Events; Form and Report Events 00:15:45
    4. Switchboard and Navigation Form; Error Handling 00:16:28
    5. Exercise 06 00:10:16
  11. Chapter 11 : Forms
    1. Formatting Bound and Control Form 00:14:45
    2. Split Forms; Macro Error Handling 00:14:43
    3. Creating Form with Tab 00:12:49
    4. Go to Combo Box and Its Properties 00:13:20
    5. Exercise 07 00:07:42
  12. Chapter 12 : Advanced Use of Queries
    1. Basic of Queries: Review 00:13:26
    2. Syntax of SQL Statements 00:14:10
    3. Use of Multiple Where Criteria & Select Statements Function 00:10:50
    4. Joins and Its Types 00:13:20
    5. Exercise 08 00:00:40
    6. Action Queries - Part 1 00:15:21
    7. Action Queries - Part 2 00:11:01
    8. Subqueries 00:04:16
  13. Chapter 13 : Packaging Your Application
    1. Steps in Packaging Access Application 00:15:17
    2. Exercise 09 00:01:20
  14. Chapter 14 : Conclusion
    1. Online Support and Conclusion 00:04:51

Product Information

  • Title: Microsoft Access Advanced 2016
  • Author(s): Simon Sez IT
  • Release date: August 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781839213304