Office Productivity Training – Microsoft Office 2016: Access 2016 Advanced Series!
Description
This course will teach students how to implement advanced form design, share data across applications, use macros to improve user interface design, use VBA, use advanced database management, distribute and secure a database, and manage switchboards
$49.00Read more
Course Modules
(Duration: 29m )
- Workbook
- Topic A: Add Controls to Forms
- The Original frmInventory View
- The frm Inventory Target Layout
- Quick Styles
- Demo – Changing the Tab Order on a Form
- Topic B: Enhance Navigation and Organization of Forms
- Demo – Creating a Subform
- Demo – Creating Tab Pages
- Demo – Creating a Navigation Form
- Topic C: Apply Conditional Formatting
- Demo – Changing the Display of Data Conditionally
- Chapter 01 Review
- Review Quiz (Number of attempts allowed: Unlimited)
(Duration: 22 m)
- Workbook
- Topic A: Import Data into Access
- External Data Tab—Import & Link Group
- Get External Data Wizard
- Demo – Importing Data from a Text File
- Demo – Importing Data from an Excel File
- Topic B: Export Access Data
- External Data Tab—Export Group
- Demo – Exporting Data
- Topic C: Link Tables to External Data Sources
- Linked Table Manager
- Demo – Using an External Data Source
- Topic D: Create a Mail Merge
- Microsoft Word Mail Merge Wizard
- Merge Fields
- The Mail Merge Task Pane
- Chapter 02 Review
- Review Quiz (Number of attempts allowed: Unlimited)
(Duration: 31 m )
- Workbook
- Topic A: Create a Macro
- The Macro Builder Window and Action Catalog
- Macro Actions and Positioning Arrows
- Form Field Events
- Demo- Creating a Macro to Open a New Record on a Form
- Topic B: Restrict Records by Using a Condition
- The OpenForm Macro Action with Where Condition
- Demo- Using the Where Condition to Restrict Data
- Topic C: Validate Data by Using a Macro
- Demo- Using a Macro to Validate Data
- Topic D: Automate Data Entry by Using a Macro
- Demo- Automating Data Entry with a Macro
- Chapter 03 Review
- Review Quiz (Number of attempts allowed: Unlimited)
(Duration: 15 m)
- Workbook
- Topic A: Getting Started with VBA
- The VBA Editor
- Demo- Creating a Standard Module
- Demo- Converting a Macro to VBA
- Topic B: Enhance Access by Using VBA
- Demo- Enhancing Forms with VBA
- Chapter 04 Review
- Review Quiz (Number of attempts allowed: Unlimited)
(Duration: 15 m )
- Workbook
- Topic A: Manage a Database
- Demo- Compacting and Repairing a Database
- Analysis Results
- Demo- Using the Performance Analyzer
- Topic B: Determine Object Dependency
- The Object Dependencies Pane
- Demo- Viewing Object Dependency
- Topic C: Document a Database
- The Documenter Dialog Box
- Demo- Using the Database Documenter
- Chapter 05 Review
- Review Quiz (Number of attempts allowed: Unlimited)
(Duration: 15 m)
- Workbook
- Topic A: Splitting a Database for Multiple-User Access
- Viewing Tables in a Split Database
- Demo- Splitting a Database
- Topic B: Implement Security
- The Message Bar
- The Trust Center Dialog Box
- Demo- Adding a Trusted Location
- Demo- Setting a Database Password
- Topic C: Convert an Access Database to an ACCDE File
- Creating an ACCDE File
- Quick Start Database Templates Menu
- Template Customization
- Demo – Converting a Database to ACCDE Format
- Topic D: Package a Database with a Digital Signature
- Chapter 06 Review
- Review Quiz (Number of attempts allowed: Unlimited)
(Duration: 13 m )
- Workbook
- Topic A: Create a Database Switchboard
- The Switchboard Manager’s Main Screen
- Demo – Creating a Simple Switchboard
- Topic B:Modify a Database Switchboard
- Demo – Modifying a Switchboard
- Topic C: Set Start-up Options
- Start-up Options for the Current Database
- Error Checking Options
- Demo – Setting Start-up Options
- Chapter 07 Review
- Course Closure
- Review Quiz (Number of attempts allowed: Unlimited)
Training Final Exam ?
Are you ready to earn your certificate of completion?
Launch The Exam
This course includes
- On-demand video
- 7 downloadable Pdf Workbooks
- Unlimited time access (During Membership)
- Access on mobile and Desktop
- Certificate of Completion
Course Features Include:
Expert Lectures
Learn on-demand from top instructors who are industry subject matter experts. Our highly certified expert instructors possess a superior understanding of the subject matter in their fields and have the ability to convey this knowledge in an effective, engaging, and professional manner to a wide audience.Certificates of Completion
Upon completion of a series of courses you can earn a certificate of completion from Career Academy. Certificates of Completion will display your full name, course completed, as well as the date of completion. Students have the ability to print this out or save it digitally to showcase your accomplishment.PowerPoint Visuals:
Many of the in-depth theories and processes discussed in our courses can be learned most efficiently through the detailed PowerPoint slides presented. These visuals are accompanied by an instructor voice-over to provide our students with a clear, efficient, and complete presentation of concepts.Professional Development Activities
Students are provided access to professional development activity files which allow for an individual to test out course theories and apply the knowledge they earned from the course.Review Quizzes
Once a course is completed, test your knowledge by taking our course review quiz! Students have the ability to retake any review quizzes as many times as they wish to ensure they understand the material or to improve upon their scores.Mobile Access
With our universal course player, you can learn from your computer, tablet as well as mobile devices. Keep up with your training on the go!
Trusted by Aspiring IT Professionals, Corporations and
Government agencies for more than a Decade
Get unlimited online access learn anywhere, anytime using your computer or mobile device!