Business Analysis

 

Course content Details:

 

 

Access Environment:

  Examine Database Concepts

  Explore the User Interface

  Use an Existing Access Database

  Customize the Access Environment

  Obtain Help

Designing a Database:

  Describe the Relational Database Design Process

  Define Database Purpose

  Review Existing Data

  Determine Fields

  Group Fields into Tables

  Normalize Data

  Designate Primary and Foreign Keys

  Determine Table Relationships

Building a Database:

  Create a New Database

  Create a Table

  Manage Tables

  Create a Table Relationship

  Save a Database as a Previous Version

Managing Data in a Table:

  Modify Table Data

  Sort Records

  Work with Subdatasheets

  Querying a Database

Filter Records:

  Create a Query

  Add Criteria to a Query

  Add a Calculated Field to a Query

  Perform Calculations on a Record Grouping

Designing Forms:

  View Data Using an Access Form

  Create a Form

  Modify the Design of a Form

Generating Reports:

  View an Access Report

  Create a Report

  Add a Custom Calculated Field to a Report

  Format the Controls in a Report

  Apply an AutoFormat Style to a Report

  Prepare a Report for Print

Creating Flexible Queries:

  Set Select Query Properties

  Create Parameter Queries

  Create Action Queries

Improving Forms:

  Design a Form Layout

  Enhance the Appearance of a Form

  Restrict Data Entry in Forms

  Add a Command Button to a Form

  Create a Subform

  Display a Calendar on a Form

  Organize Information with Tab Pages

  Display a Summary of Data in a Form 

Customizing Reports:

  Organize Report Information

  Format the Report

  Set Report Control Properties

  Control Report Pagination

  Summarize Report Information

  Add a Subreport to an Existing Report

  Create a Mailing Label Report

  Include a Chart in a Report

  Print Data in Columns

  Create a Report Snapshot

Sharing Data Across Applications:

  Import Data into Access

  Export Data

  Analyze Access Data in Excel

  Export Data to a Text File

  Merge Access Data with a Word Document

Structuring Existing Data:

  Analyze Tables

  Create a Junction Table

  Improve Table Structure

Writing Advanced Queries:

  Create Subqueries

  Create Unmatched and Duplicate Queries

  Group and Summarize Records Using Criteria

  Create a PivotTable and a PivotChart

 

For Inquiries you can walk-in to our Co-operate office (485 US Highway 1 South, Building C, Suite # 105,Iselin,NJ-08830) between 9 am to 6 pm.

Please Email to Training@VForceInfoTech.com OR Call On 732-218-5912 Ext 7008/7010