Microsoft Access 2013 Advanced Essentials
This course builds upon basic 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 forms, macros, and dialog boxes; create and use SQL queries; split databases; and much more.
- Managing Data
- Advanced Table Tasks
- Managing Data Entry in Tables
- Creating Subforms
- Creating Navigation Forms
- Advanced Query Tasks
- Creating Modal Dialog Boxes
- Splitting the Database
- Using Access with SharePoint Server
- Creating Basic Macros
- Advanced Macro Tasks
- Using Visual Basic for Applications
Once done, you may get a certificate certified by the Filipino Institute, an internationally accredited organization, for a fee of AED 70. To know more about the free online courses, contact Dean Oliver at email@example.com or send him a WhatsApp message at +971-58-2439959.
- Lectures 65
- Quizzes 1
- Duration 24 hours
- Language English
- Students 91
- Assessments Self
This opening module will show students how to view relationships, view object dependencies, enforce referential integrity, and enforce cascade update and delete. Students also will learn about types of relationships and referential integrity.
Advanced Table Tasks
In this module, students are shown how to insert application parts, use the Table Analyzer Wizard, create validation rules, and configure validation messages.
Managing Data Entry in Tables
In this module, topics include how to mark fields as required, mark a field for indexing, create lookup fields, create value lists, and create input masks
This module covers how to create and use subforms, link subforms with parent forms, and format a subform within a main form.
Advanced Query Tasks
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.
Creating Modal Dialog Boxes
Modal dialog boxes get a thorough look in this module. Topics include how to create, format, and modify a modal dialog box.
Splitting the Database
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.
Creating Basic Macros
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.
Advanced Macro Tasks
Next, students will learn how to create event procedures, data macros, and submacros.
Using Visual Basic for Applications
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.
Quick Reference Guide