Microsoft Access Training Classes in Houston Texas - Hands on Access Classes in Houston Texas - (Houston)

Posted on: 11/07/17

Description

Microsoft Access Training Classes in Houston, Texas Microsoft Access in Houston Course Outlines • Hands-on, instructor-led training classes • Step-by-step training manual with exercise link • Certificate of completion • Onsite Training available • Class can be customized to suit your needs • Private one-on-one classes are available Listed below are our standard course outlines. Each course is instructor led hands-on classroom-training using step-by-step student manual and exercises. Microsoft Access in Houston - Training Classes in Houston, Texas Microsoft Access in Houston: Level 1 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 2013 Exam 77-424 Appendix B: Microsoft Access in Houston Common Keyboard Shortcuts Microsoft Access in Houston: Level 2 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 in Houston Common Keyboard Shortcuts Microsoft Access in Houston: Level 3 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 Appendix A: Microsoft Office Access 2013 Exam 77-424 Appendix B: Microsoft Access in Houston Common Keyboard Shortcuts Microsoft Access in Houston: Level 4 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 Microsoft Access Tutor in Houston Microsoft Access Trainer in Houston Microsoft Access Teacher in Houston Microsoft Access Classes in Houston Microsoft Access Training in Houston Microsoft Access Expert in Houston Microsoft Access VBA Expert in Houston Houston Basic Access Classes in Houston, TX Houston Beginner Access Classes in Houston, TX Houston Intermediate Microsoft Access Classes in Houston, TX Houston Advanced Microsoft Access Classes in Houston, TX Houston Microsoft Access Tutor in Houston, TX

Ad Number: 21056913