Access Expert in Houston, Texas

ACCESS TRAINER IN HOUSTON

MICROSOFT ACCESS EXPERT BASED IN HOUSTON

Would you like me to help you with your Access or Excel projects?

Whether it is  programming or teaching you or your entire staff I can help!

Very reasonable pricing and I will work within your budget, either at your office or in our classroom or I can work remotely, your choice!

 

 

Quick instant quote provided for your project – Simply tell us your needs in the form below

Please fill the form below for an instant response

* indicates required field

Microsoft Access Expert in Houston


Training Course Content

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Topic C: Create Lookups

Lesson 3: Querying a Database

Topic A: Join Data from Different Tables in a Query

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Create Action Queries

Topic C: Create Unmatched and Duplicate Queries

Topic D: Summarize Data

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Lesson 6: Customizing the Access Environment

Topic A: The Access Options Dialog Box

Appendix A: Microsoft Office Access Exam 77-424

Appendix B: Microsoft Access Common Keyboard Shortcuts


Microsoft Access Expert in Houston


Training Course Content

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design

Topic B: Create a Table

Topic C: Create Table Relationships

Lesson 2: Joining Tables

Topic A: Create Query Joins

Topic B: Join Tables That Have No Common Fields

Topic C: Relate Data within a Table

Topic D: Work with Subdatasheets

Topic E: Create Subqueries

Lesson 3: Organizing a Database for Efficiency

Topic A: Data Normalization

Topic B: Create a Junction Table

Topic C: Improve Table Structure

Lesson 4: Sharing Data Across Applications

Topic A: Import Data into Access

Topic B: Export Data to Text File Formats

Topic C: Export Access Data to Excel

Topic D: Create a Mail Merge

Lesson 5: Advanced Reporting

Topic A: Organize Report Information

Topic B: Format Reports

Topic C: Include Control Formatting in a Report

Topic D: Add a Calculated Field to a Report

Topic E: Add a Subreport to an Existing Report

Appendix A: Additional Reporting Options

Appendix B: Microsoft Office Access 2013 Exam 77-424

Appendix C: Microsoft Access 2013 Common Keyboard Shortcuts


Microsoft Access Expert in Houston


Training Course Content

Lesson 1: Implementing Advanced Form Design

Topic A: Add Controls to Forms

Topic B: Create Subforms

Topic C: Organize Information with Tab Pages

Topic D: Enhance Navigation of Forms

Topic E: Apply Conditional Formatting

Lesson 2: Using Data Validation

Topic A: Field Validation

Topic B: Form and Record Validation

Lesson 3: Using Macros to Improve User Interface Design

Topic A: Create a Macro

Topic B: Restrict Records Using a Condition

Topic C: Validate Data Using a Macro

Topic D: Automate Data Entry Using a Macro

Topic E: Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

Topic A: Link Tables to External Data Sources

Topic B: Manage a Database

Topic C: Determine Object Dependency

Topic D: Document a Database

Topic E: Analyze the Performance of a Database

Lesson 5: Distributing and Securing a Database

Topic A: Split a Database for Multiple User Access

Topic B: Implement Security

Topic C: Set Passwords

Topic D: Convert an Access Database to an ACCDE File

Topic E: Package a Database with a Digital Signature

Lesson 6: Managing Switchboards

Topic A: Create a Database Switchboard

Topic B: Modify a Database Switchboard

Topic C: Set Startup Options

Microsoft Access Expert in Houston

Microsoft Access Common Keyboard Shortcuts


Microsoft Access Expert in Houston


Training Course Content

Getting Started
Introduction to Programming in Access
Why Program in Access?
Understanding the Development Environment
Using Visual Basic Help
Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Organizing Code and Procedures
Working with the Code Editor
Understanding Objects
Understanding Classes and Objects
Navigating the Access Object Hierarchy
Understanding Collections
Using the Object Browser
Working with the Application Object
Understanding the Form Object
Working with Properties
Using the With Statement
Working with Methods
Understanding the DoCmd Object
Working with Events
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Working with Variable Lifetime
Considering Variable Scope and Lifetime Together
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If…End If Decision Structures
Using the Select Case…End Select Structure
Using the For…Next Structure
Using the For Each…Next Structure
Using the Do…Loop Structure
Guidelines for use of Branching Structures
Working with Recordsets
Declaring and Creating Object Variables
Working with the DAO Recordset Object
Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Setting Break Expressions
Using Break Mode during Run Mode
Stepping through Code
Determining the Value of Expressions
Handling Errors
Understanding Error Handling
Understanding VBA’s Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling
Appendix – Working with the ADO Recordset Object

 

 

 
 

Excel Expert in Houston, Texas

ACCESS TRAINER IN HOUSTON

MICROSOFT EXCEL EXPERT BASED IN HOUSTON

Would you like me to help you with your Excel or Access projects?

Whether it is  programming or teaching you or your entire staff I can help!

Very reasonable pricing and I will work within your budget, either at your office or in our classroom or I can work remotely, your choice!

 

 

Quick instant quote provided for your project – Simply tell us your needs in the form below

Please fill the form below for an instant response

* indicates required field

 

 

 

 

Microsoft Excel Expert in Houston, Texas

Lesson 1: Getting Started with Microsoft Office Excel Expert in Houston, Texas
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help
Lesson 2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas
Lesson 3: Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
Topic A: Modify Fonts
Topic B: Add Borders and Colors to Worksheets
Topic C: Apply Number Formats
Topic D: Align Cell Contents
Topic E: Apply Styles and Themes
Topic F: Apply Basic Conditional Formatting
Topic G: Create and Use Templates
Lesson 5: Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Define the Page Layout
Lesson 6: Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties
Appendix A: Microsoft Office Excel Expert in Houston, Texas Exam 77-420
Appendix B: Microsoft Office Excel Expert in Houston, Texas Expert Exams 77–427 and 77-428
Appendix C: Microsoft Excel Expert in Houston, Texas Common Keyboard Shortcuts
Microsoft Excel Expert in Houston, Texas

Lesson 1: Customizing the Excel Environment
Topic A: Configure Excel Options
Topic B: Customize the Ribbon and the Quick Access Toolbar
Topic C: Enable Excel Add-Ins
Lesson 2: Creating Advanced Formulas
Topic A: Use Range Names in Formulas
Topic B: Use Specialized Functions
Topic C: Use Array Formulas
Lesson 3: Analyzing Data with Functions and Conditional Formatting
Topic A: Analyze Data by Using Text and Logical Functions
Topic B: Apply Advanced Conditional Formatting
Lesson 4: Organizing and Analyzing Datasets and Tables
Topic A: Create and Modify Tables
Topic B: Sort Data
Topic C: Filter Data
Topic D: Use SUBTOTAL and Database Functions
Lesson 5: Visualizing Data with Basic Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Slicers
Appendix A: Microsoft Office Excel Expert in Houston, Texas Exam 77-420
Appendix B: Microsoft Office Excel Expert in Houston, Texas Expert Exams 77–427 and 77-428
Appendix C: Financial Functions
Appendix D: Date and Time Functions
Appendix E: Working with Graphical Objects

Microsoft Excel Expert in Houston, Texas

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic A: Use 3-D References
Topic B: Use Links and External References
Topic C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Work with Forms and Controls
Topic C: Work with Macros
Lesson 4: Applying Conditional Logic
Topic A: Use Lookup Functions
Topic B: Combine Functions
Topic C: Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Topic A: Trace Cells
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Activate and Use the Solver Tool
Topic E: Analyze Data with Analysis ToolPak Tools
Lesson 7: Presenting Your Data Visually
Topic A: Use Advanced Chart Features
Topic B: Create Sparklines
Appendix A: Microsoft Office Excel Expert in Houston, Texas Exam 77-420
Appendix B: Microsoft Office Excel Expert in Houston, Texas Expert Exams 77–427 and 77-428
Appendix C: Cube Functions
Appendix D: Import and Export Data
Appendix E: Internationalize Workbooks
Appendix F: Work with PowerPivot