About this Event
Certificate: Course Completion Certificate Language: English
Duration: 1 Day
Course Delivery: Classroom/ Virtual/ On-site Credits: 8
Course Overview:
This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. This workshop is designed for the advanced users of Access 2013. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
This workshop is meant to provide a safe learning environment where they can practice and learn Access 2013 Expert functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.
Target Audience:
Anybody who is interested in learning Access 2013 Expert Skills
Learning Objectives:
After completing this course, Individuals will be able to demonstrate their understanding of:
- Customizing Apps
- Working with Validation Rules and Messages
- Working with Macros
- Advanced Query Tasks
- Designing Forms
- Advanced Reporting Tasks
- Advanced Database Tools
- Working with the Access Environment
Agenda:
Module One: Customizing Apps (I)
- Creating a Custom App from Scratch
- Adding a Template Table Adding a Blank Table
- Importing Access 2010 Tables
- Module One: Review Questions
Module Two: Customizing Apps (II)
- About Custom Actions
- Adding a Custom Action
- Editing a Custom Action
- Deleting a Custom Action
- Module Two: Review Questions
Module Three: Customizing Apps (III)
- About User Interface Macros
- Creating an Embedded Macro
- Creating a Standalone macro
- Saving Your App as a Package
Module Four: Working with Validation Rules and Messages
- Creating a Field Validation Rule
- Creating a Field Validation Message
- Creating a Validation Rule
- Creating a Validation Message
- Testing Validation Rules
Module Five: Working with Macros
- Creating a Before Change Event
- Working with the Macro Tools Design Tab
- Working with the Action Catalog
- Creating an After Event
- Creating a Named Macro
- Renaming or Deleting Macros
Module Six: Advanced Query Tasks
- Using Query Design View
- Creating Ad Hoc Relationships
- Creating an Update Query
- Creating a Parameter Query
- Comparing Two Tables by Using a Join
Module Seven: Designing Forms
- Common Formatting Tasks
- Using Themes
- Working with Controls
- Adding Header and Footer Elements
- Arranging Form Elements
- Formatting Forms
Module Eight: Advanced Reporting Tasks
- Using Report Sections
- Using Conditional Formatting
- Grouping and Sorting Data
- Adding Calculated Controls
- Creating Labels
Module Nine: Advanced Database Tools
- Using the Database Documenter
- Analyzing Table Performance
- Analyzing Database Performance
- Repairing a Database
- Compacting a Database
Module Ten: Working with the Access Environment
- Working with Database Properties
- Encrypting a Database with a Password
- Using Save Object As
- Setting Access Options
Module Eleven: Wrapping Up
- Words from the Wise
- Review of Parking Lot
Prerequisites:
None
Course Materials:
Students will receive a course manual with presentation slides and reference materials.
Technical Requirements:
For eBooks:
Internet for downloading the eBook
Laptop, tablet, Smartphone, eReader (No Kindle)
Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)
eBook download and activation instructions
Note:
However, catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. Reach us at [email protected] for dates and details of Instructor Led Live Virtual Sessions.
If you would like to get this course customized and delivered exclusively for your group, we have an On-Site Training Option you can reach us at [email protected] for more details about on-site or corporate training.
Offers:
Groups of 3 people 10% Discount
Groups of 5 people 15% Discount
Groups of 10 people 20% Discount
Event Venue & Nearby Stays
For venue details reach us at [email protected], +1 469 666 9332, Perth, Australia
AUD 599.00 to AUD 799.00