- 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.
Course Objectives
- 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
Course Outlines
Description:
This module covers how to create and use subforms, link subforms with parent forms, and format a subform within a main form.
Main Points:
- Creating Subforms
- Using Subforms
- Linking Subforms with Parent Forms
- Formatting a Subform within a Main Form
Description:
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.
Main Points:
- Creating a Navigation Form
- Adding Tabs to a Navigation Form
- Creating a Tab Hierarchy
- Displaying the Navigation Form when the Database Opens
Description:
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.
Main Points:
- Understanding SQL Statements
- Basic SQL Keywords
- Creating SQL Queries
- Using the Expression Builder
Description:
Modal dialog boxes get a thorough look in this module. Topics include how to create, format, and modify a modal dialog box.
Main Points:
- Creating a Modal Dialog Box
- Adding Controls
- Setting Properties
- Formatting a Modal Dialog Box
Description:
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.
Main Points:
- Backing Up the Database
- Splitting the Database
- Configuring Access 2013 for a Multi-User Database
- Setting Record Locking Options
Description:
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.
Main Points:
- Linking Tables and Lists
- Moving a Database to SharePoint
- Saving a Database to SharePoint
- About Access Web Apps
Description:
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.
Main Points:
- Creating a Standalone Macro
- Using the Action Catalog
- Adding Comments to Macros
- Using If-Then Actions
- Handling Macro Errors
Description:
Next, students will learn how to create event procedures, data macros, and submacros.
Main Points:
- Creating Event Procedures
- Creating Data Macros
- Creating Submacros
- Grouping Submacros
Description:
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.
Main Points:
- Converting a Macro to Visual Basic
- Using Visual Basic for Applications
- Understanding Modules
- Building Visual Basic Procedures