Microsoft Access 2013 - Advanced. Master Databases

In this module you'll learn about Indexes and be introduced to the Movies Database, and it covers topics such as working with Datasheet View, Controlling the Display and Advanced Sorting, and Filtering in Datasheet View.

In this module you'll learn about Linking Database Tables and ODBC & SQL Server , and it covers topics such as Linking to Other Access Database Tables, Installing SQL Server Express, Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server.

In this module you'll learn about Splitting an Access Database and Access Options, and it covers topics such as Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end; Consequences of the Split; Moving a Database; Adding a Trusted Location; Access Options relating to Multi-user Issues; and Record Locking.

In this module you'll learn about Macros, and it covers topics such as Basics of Macros and Properties of Macro Editor, Examples of Macros; Autoexec, Macro Security, Customizing the Quick Access Toolbar and the Ribbon.

In this module you'll learn about Visual Basic for Applications, and it covers topics such as Convert Macro to VBA; VBA Editor Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes; Modules, Subs, Options Explicit, and Variables; Scope of Variables; and Branch and Loop.