Take this
course

Office Productivity / Microsoft

Microsoft Access 2013 Advanced Course

Get ready to take your Microsoft Access 2013 skills to the next level with this advanced Access 2013 course.

Description

In this day and age, data management is absolutely crucial, and there’s not much room for error. If you’ve already taken our basic Microsoft Access 2013 course, or know your way around the program already, you’re ready for our Microsoft Access 2013 Advanced course. Get ready to become a data management expert as this 9.25 hour class takes your skills to the next level. In the Microsoft Access 2013 Advanced video training course, you’ll take your knowledge up a notch as you get acquainted with Microsoft Access 2013’s most sophisticated features. If you think you know all you need to know about Access 2013, think again, as this course goes way beyond the basics, leaving you with knowledge of all of the best Access tips and tricks out there. Your professional trainer will show you how to use macros, tables, forms, 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. Get helpful techniques that allow you to link, report, and package your data quickly, and find out how to split a database by splitting the frontend and backend. 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 better.
Full details

Curriculum

  • Introduction
    Prerequisites and Basic Knowledge of Access 2013
    9:11
  • Indexes
    Indexes and Introduction to the Movies Database
    14:37
  • Datasheet View
    Basics in Working with Datasheet View
    10:30
    Controlling the Display and Advanced Sorting and Filtering in Datasheet View
    15:22
  • Linking Access Databases
    Linking to Other Access Database Tables
    14:42
  • ODBC and SQL Server
    How to Install SQL Server Express
    14:50
    Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
    16:51
  • Splitting an Access Database
    Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
    15:20
    Consequences of the Split; Moving a Database; Adding a Trusted Location
    16:08
  • Multi-user Aspects
    Access Options relating to Multi-user Issues; Record Locking
    14:59
  • Macros
    Basics of Macros and Properties of Macro Editor
    14:25
    Examples of Macros; Autoexec
    14:30
    More Autoexec
    14:44
    Macro Security
    8:38
  • The Ribbon
    Customizing the Quick Access Toolbar and the Ribbon
    15:18
  • Visual Basic for Applications
    Convert Macro to VBA; VBA Editor
    14:14
    Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
    14:14
    Modules, Subs, Options Explicit, and Variables
    15:59
    Scope of Variables
    16:14
    Branch and Loop
    14:39
  • Events
    Customizing Events
    15:09
    Responding to Events and Developing Error Handles
    14:01
    More on Events
    14:12
    Getting Help with Events
    8:25
  • Forms
    Basics of Forms: Review and Tips and Tricks
    15:40
    Advanced Features of Forms: Details of a Students List Sample Form and using Macro Code to add rich functionality to your Access application - Part 1
    17:20
    Advanced Features of Forms: Details of a Students List Sample Form and using Macro Code to add rich functionality to your Access application - Part 2
    14:34
    Advanced Features of Forms: Details of a Students List Sample Form and using Macro Code to add rich functionality to your Access application - Part 3
    14:50
    Advanced Features of Forms: Details of a Students List Sample Form and using Macro Code to add rich functionality to your Access application - Part 4
    15:20
  • SQL
    Basics of Queries: Review
    13:58
    Main Features and Syntax of SQL Statements
    15:54
    Use of Multiple Criteria of a Where Clause
    12:56
  • Joins
    How Joins Look in SQL Statements and using Query Grids
    15:51
  • Action Queries
    Update Query
    15:43
    Delete and Make Table Queries
    12:21
    Append Query
    7:10
  • Packaging your Application
    Protecting your Database and Codes
    15:09
    Making your Database More User-Friendly
    7:24
  • Web Apps
    Setting up an Access Web App
    16:34
    Building Basic Web Apps
    16:49
  • Conclusion
    Closing
    0:45

Skills

  • Microsoft Access
  • Microsoft Office Professional

Similar Courses

More Courses by this Instructor