- Duration: 10 hours
Microsoft Access Advanced
This course builds upon basic and intermediate Microsoft Access skills to help students become power users. In this advanced Microsoft Access 2013 course, students will delve deeper into the program by studying a dozen different topics. Modules in this course cover how to manage data and data entry; create macros, and dialog boxes; create and use SQL queries; split databases; and much more.
- How to write sql statements
- How to create aliases for fields
- How to attach a sql query to a control in a form
- How to view a crosstab query and use the crosstab query wizard
- How to create single-criterion & multiple-criteria parameter queries
- How to create and run macros
- How to attach macros to events and command buttons in forms
- How to create data validation, data entry, & user-input macros
- How to use the query wizard & design view to create joins
- How to export & import xml documents
- How to link database objects
- How to analyse database performance
- How to split a database
- How to compact, repair & backup a database
- How to assign & remove passwords & encryption
- How to open a database in exclusive mode
- How to configure access options
- How to populate database file properties
This module covers how to create and use subforms, link subforms with parent forms, and format a subform within a main form.
- Creating Subforms
- Using Subforms
- Linking Subforms with Parent Forms
- Formatting a Subform within a Main Form
Next, students are shown how to create a navigation form and add tabs to it, create a tab hierarchy in a navigation form, and automatically display a navigation form when the database opens.
- Creating a Navigation Form
- Adding Tabs to a Navigation Form
- Creating a Tab Hierarchy
- Displaying the Navigation Form when the Database Opens
This module will give students the answers about queries. Topics covered include how to create SQL queries, use the Expression Builder, create SQL statements, and use SQL keywords.
- Understanding SQL Statements
- Basic SQL Keywords
- Creating SQL Queries
- Using the Expression Builder
Modal dialog boxes get a thorough look in this module. Topics include how to create, format, and modify a modal dialog box.
- Creating a Modal Dialog Box
- Adding Controls
- Setting Properties
- Formatting a Modal Dialog Box
When dealing with databases, it’s a good idea to have tools to manipulate them effectively. This module takes a look at how to back up a database, split a database, configure Access 2013 for a multi-user database, and set record locking options.
- Backing Up the Database
- Splitting the Database
- Configuring Access 2013 for a Multi-User Database
- Setting Record Locking Options
SharePoint Server meshes well with Access 2013 and this module takes advantage of that relationship. Students will learn how to link tables to lists, move a database to SharePoint, save a database to SharePoint, and use Access web apps.
- Linking Tables and Lists
- Moving a Database to SharePoint
- Saving a Database to SharePoint
- About Access Web Apps
This module shows students how to create a standalone macro, use the Action Catalog, add comments to macros, use If-Then actions, and handle macro errors.
- Creating a Standalone Macro
- Using the Action Catalog
- Adding Comments to Macros
- Using If-Then Actions
- Handling Macro Errors
Next, students will learn how to create event procedures, data macros, and submacros.
- Creating Event Procedures
- Creating Data Macros
- Creating Submacros
- Grouping Submacros
The final module in this course explores how to use Visual Basic for Applications. Students will learn how to convert a macro to Visual Basic, use Visual Basic for Applications, use modules, and build Visual Basic procedures.
- Converting a Macro to Visual Basic
- Using Visual Basic for Applications
- Understanding Modules
- Building Visual Basic Procedures