Office Productivity Training – Microsoft Office 2013 Access Advanced Series!
$49.00Read more
Description
This course provides students with knowledge and skills such as database management, advanced form design, packaging a database, encrypting a database, and preparing a database for multi-user access.
Course Modules:
Module 01: Implementing Advanced Form Design
(Duration: 37m )
- Workbook
- Topic A: Add Controls to Forms
- Types of Controls
- Other Elements
- The Original frmInventory View
- The frmInventory Target Layout
- Styling Elements
- Demo 1-1: Changing the Tab Order on a Form
- Topic B: Create Subforms
- Subforms
- Demo 1-2: Creating a Subform
- Topic C: Organize Information with Tabs Pages
- Demo 1-3: Creating Tab Pages
- Topic D: Enhance Navigation of Forms
- Demo 1-4: Creating a Navigation Form
- Topic E: Apply Conditional Formatting
- Demo 1-5: Changing the Display of Data Conditionally
- Lesson 01 Review
- Review Quiz (Number of attempts allowed: Unlimited)
Module 02: Using Data Validation
(Duration: 29m)
- Workbook
- Topic A: Field and Record Validation
- Field and Record Navigation
- Field Properties for a Number Data Type Field in tblInventory
- Input Masks
- Input Mask Characters
- Lookup Lists
- Demo 2-1: Validating Data with a Field Property
- Topic B: Form Validation
- Selecting the Type of Combo Box for a Form
- Controls – List Box and Option Group
- Demo 2-2: Using a Combo Box Control to Limit Option Values
- Lesson 02 Review
- Review Quiz (Number of attempts allowed: Unlimited)
Module 03: Using Macros to Improve User Interface Design
(Duration: 40 m )
- Workbook
- Topic A: Create a Macro
- Macros
- The Macro Builder Window and Action Catalog
- Macro Actions and Positioning Arrows
- Types of Macro Actions
- Event Options Form Field
- Macro Event Groups
- Events and Supported Controls
- Demo 3-1: Creating a Macro to Open a New Record on a Form
- Topic B: Restrict Records Using a Condition
- The OpenForm Macro Action with Where Condition
- Demo 3-2: Using the Where Condition to Restrict Data
- Topic C: Validate Data Using a Macro
- Validate Data Using a Macro
- Demo 3-3: Using a Macro to Validate Data
- Topic D: Automate Data Entry Using a Macro
- Event Properties for Automating Data Entry
- Demo 3-4: Automating Data Entry with a Macro
- Topic E: Convert a Macro to VBA
- Macros and VBA
- Demo 3-5: Converting a Macro to VBA
- Lesson 03 Review
- Review Quiz (Number of attempts allowed: Unlimited)
Module 04: Using Advanced Database Management
(Duration: 27 m)
- Workbook
- Topic A: Link Tables to External Data Sources
- External Data Sources
- Demo 4-1: Using an External Data Source
- Topic B: Manage a Database
- Modes to Open a Database
- Maintaining a Database
- Demo 4-2: Compacting and Repairing a Database
- Topic C: Determine Object Dependency The Object Dependencies Pane
- Demo 4-3: Viewing Object Dependency
- Topic D: Document a Database
- Database Documenter
- Demo 4-4: Using the Database Documenter
- Topic E: Analyze the Performance of a Database
- Analysis Results
- Demo 4-5: Using the Performance Analyzer
- Lesson 04 Review
- Review Quiz (Number of attempts allowed: Unlimited)
Module 05: Distributing and Securing a Database
(Duration: 51 m )
- Workbook
- Topic A: Splitting a Database for Multiple User Access
- Viewing Tables in a Split Database
- Demo 5-1: Splitting a Database
- Topic B: Implement Security
- The Message Bar
- Implementing Security
- The Trust Center Dialog Box
- Demo 5-2: Adding a Trusted Location
- Topic C: Set Passwords
- Password Guidelines
- Demo 5-3: Setting a Database Password
- Topic D: Convert an Access Database to an ACCDE File
- ACCDE File Format
- Creating an ACCDE File
- Quick Start Database Templates Menu
- Template Customization
- Saving Your Database as a Template
- Demo 5-4: Converting a Database to ACCDE Format
- Topic E: Package a Database with a Digital Signature
- Packaging a Database with Digital Signatures
- Package and Sign
- Certificates
- Lesson 05 Review
- Review Quiz (Number of attempts allowed: Unlimited)
Module 06: Managing Switchboards
(Duration: 17 m)
- Workbook
- Topic A: Create a Database Switchboard
- The Switchboard Manager’s Initial Message
- The Switchboard Manager’s Main Screen
- Demo 6-1: Creating a Simple Switchboard
- Topic B: Modify a Database Switchboard
- Demo 6-2: Modifying a Switchboard
- Topic C: Set Startup Options
- Startup Options for the Current Database
- Error Checking Options
- Demo 6-3: Setting Startup Options
- Lesson 06 Review
- Course Closure
- Review Quiz (Number of attempts allowed: Unlimited)
This course includes
- On-demand video
- 6 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!