Answer Quest offers training for the following classes:
Course Objectives:
In this course, you will learn to create and manage a fundamental Access 2013 database. You will:
- Navigate within the Microsoft Access application environment and create a simple database.
- Organize and manage data stored within Access tables.
- Use queries to join, sort, and filter data from different tables.
- Create advanced queries, including action queries and parameter queries.
- Create and format custom reports.
- Customize Access configuration options
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 2013 Common Keyboard Shortcuts
Course Objectives:
In this course, you will work with relational database structure, relationships, efficiency, integrity, and customization. You will:
- Design a relational database.
- Join tables to retrieve data from unrelated tables.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Share data among Access and other applications.
- Customize reports to organize the displayed information and produce specific print layouts.
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
Course Objectives:
Upon successful completion of this course, students will be able to:
- Customize a form layout to improve usability and efficiency of data entry.
- Add user interface features to validate data entry.
- Use macros to improve user interface design.
- Organize data into appropriate tables to ensure data dependency and minimize redundancy.
- Lock down and prepare a database for distribution to multiple users.
- Create and modify a database switchboard and set the startup options.
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 2013 Common Keyboard Shortcuts
Course Objectives
Upon successful completion of this course, students will be able to:
- Identify the basic components of an Access database.
- Build the structure of a database.
- Manage data in tables.
- Query a database.
- Design forms.
- Generate reports.
Course Content
Lesson 1: Getting Started with Access Databases
Topic 1A: Identify the Elements of the Access 2010 Interface
Topic 1B: Identify the Components of a Database
Topic 1C: Examine the Relational Database Design Process
Lesson 2: Building the Structure of a Database
Topic 2A: Create a New Database
Topic 2B: Create a Table
Topic 2C: Manage Tables
Topic 2D: Establish Table Relationships
Lesson 3: Managing Data in a Table
Topic 3A: Modify Table Data
Topic 3B: Sort and Filter Records
Topic 3C: Work with Subdatasheets
Lesson 4: Querying a Database
Topic 4A: Create a Query
Topic 4B: Add Criteria to a Query
Topic 4C: Add a Calculated Field to a Query
Topic 4D: Perform Calculations on a Record Grouping
Lesson 5: Designing Forms
Topic 5A: Create a Form
Topic 5B: Modify the Design of a Form
Topic 5C: View and Edit Data Using an Access Form
Lesson 6: Generating Reports
Topic 6A: Create a Report
Topic 6B: Add a Control to a Report
Topic 6C: Format the Controls in a Report
Topic 6D: Enhance the Appearance of a Report
Topic 6E: Prepare a Report for Print
Appendix A: Microsoft Office Access 2010 Exam 77–885
Course Objectives
Upon successful completion of this course, students will be able to:
- Streamline data entry and maintain data integrity.
- Join tables to retrieve data from unrelated tables.
- Create flexible queries to retrieve data and modify tables.
- Improve the functionality of Access forms.
- Customize reports to organize the displayed information and produce specific print layouts.
- Share data between Access and other applications.
Course Content
Lesson 1: Controlling Data Entry
Topic 1A: Constrain Data Entry Using Field Properties
Topic 1B: Establish Data Entry Formats for Entering Field Values
Topic 1C: Create a List of Values for a Field
Lesson 2: Joining Tables
Topic 2A: Create Query Joins
Topic 2B: Join Tables That Have No Common Fields
Topic 2C: Relate Data Within a Table
Lesson 3: Creating Flexible Queries
Topic 3A: Set the Select Query Properties
Topic 3B: Retrieve Records Based on Input Criteria
Topic 3C: Create Action Queries
Lesson 4: Improving Forms
Topic 4A: Restrict Data Entry in Forms
Topic 4B: Organize Information with Tab Pages
Topic 4C: Add a Command Button to a Form
Topic 4D: Create a Subform
Topic 4E: Display a Summary of Data in a Form
Topic 4F: Change the Display of Data Conditionally
Lesson 5: Customizing Reports
Topic 5A: Organize Report Information
Topic 5B: Format Reports
Topic 5C: Control Report Pagination
Topic 5D: Add a Calculated Field to a Report
Topic 5E: Add a Subreport to an Existing Report
Topic 5F: Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
Topic 6A: Import Data into Access
Topic 6B: Export Data to Text File Formats
Topic 6C: Export Access Data to Excel
Topic 6D: Create a Mail Merge
Appendix A: Navigation FormsAppendix B: Microsoft Office Access 2010 Exam 77–885
Course Objectives
Upon successful completion of this course, students will be able to:
- Restructure data into appropriate tables to ensure data.
- Dependency and minimize redundancy.
- Write advanced queries to analyze and summarize data.
- Create macros.
- Customize reports by using various Access features.
- Maintain your database using Access tools.
Course Content
Lesson 1: Structuring Existing Data
Topic 1A: Restructure the Data in a Table
Topic 1B: Create a Junction Table
Topic 1C: Improve the Table Structure
Lesson 2: Writing Advanced Queries
Topic 2A: Create Subqueries
Topic 2B: Create Unmatched and Duplicate Queries
Topic 2C: Filter Records Using Criteria
Topic 2D: Summarize Data Using a Crosstab Query
Topic 2E: Create a PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro
Topic 3C: Restrict Records Using a Condition
Topic 3D: Validate Data Using a Macro
Topic 3E: Automate Data Entry Using a Macro
Lesson 4: Creating Effective Reports
Topic 4A: Include a Chart in a Report
Topic 4B: Print Data in Columns
Topic 4C: Cancel Printing of a Blank Report
Topic 4D: Publish a Report as a PDF
Lesson 5: Maintaining an Access Database
Topic 5A: Link Tables to External Data Sources
Topic 5B: Manage a Database
Topic 5C: Determine Object Dependency
Topic 5D: Document a Database
Topic 5E: Analyze the Performance of a Database
Appendix A: Microsoft Office Access 2010 Exam 77–885
Course Objectives
Upon successful completion of this course, students will be able to:
- Share Access data with other applications.
- Use VBA to automate a business process.
- Create and modify a database switchboard and set the startup options.
- Secure and distribute databases.
- Share databases using a SharePoint site.
Course Content
Lesson 1: Integrating Access into Your Business
Topic 1A: Import XML Data into an Access Database
Topic 1B: Export Access Data to the XML Format
Topic 1C: Export Data to an Outlook Address Book
Topic 1D: Collect Data Through Email Messages
Lesson 2: Automating a Business Process with VBA
Topic 2A: Create a Standard Module
Topic 2B: Develop Code
Topic 2C: Call a Procedure from a Form
Topic 2D: Run a Procedure
Lesson 3: Managing Switchboards
Topic 3A: Create a Database Switchboard
Topic 3B: Modify a Database Switchboard
Topic 3C: Set the Startup Options
Lesson 4: Distributing and Securing Databases
Topic 4A: Split a Database
Topic 4B: Implement Security
Topic 4C: Set Passwords
Topic 4D: Convert an Access Database to an ACCDE File
Topic 4E: Package a Database with a Digital Signature
Lesson 5: Sharing Databases Using a SharePoint Site
Topic 5A: Export a Table to a SharePoint List
Topic 5B: Import Data from a SharePoint List
Topic 5C: Publish a Database to a SharePoint Site
Topic 5D: Move a Database to a SharePoint Site
Topic 5E: Work Offline