Microsoft Access

Access 2013: Level 1

Course Outline

 

  • 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 Contruls 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

 
Duration: 8 Hours
Course Fee: INR. 5,000 + Tax

Access 2013: Level 2

Course Outline

 

  • 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 Contrul Formatting in a Report
    • Topic D: Add a Calculated Field to a Report
    • Topic E: Add a Subreport to an Existing Report

 
Duration: 8 Hours
Course Fee: INR. 6,000 + Tax

Access 2013: Level 3

Course Outline

 

  • 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 and Record Validation
    • Topic B: Form 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: Splitting 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

 
Duration: 8 Hours
Course Fee: INR. 7,000 + Tax


 
Microsoft Access 2010

Access 2010 Combo

Course Outline

 

Duration: 24 Hours
Course Fee: INR. 15,000 + Tax

Access 2010: Level 1

Course Outline

 

  • Lesson 1: Getting Started with Access 2010
    • Identify the Elements of the User Interface
    • Identify the Tabs and Commands on the Ribbon
    • Obtain Help in Access
  • Lesson 2: Identifying the Components of a Database
    • Define Database Concepts
    • Identify the Components of a Database
    • Examine the Relational Database Design Process
  • Lesson 3: Organizing Data in Tables
    • Create a Table
    • Modify Table Data and Properties
    • Create a Table Relationship
  • Lesson 4: Viewing Data in Tables
    • Sort Records
    • Filter Records
    • View Data from Related Tables
  • Lesson 5: Querying a Database
    • Create a Query
    • Add Criteria to a Query
    • Add a Calculated Field to a Query
    • Perform Calculations on a Record Grouping
  • Lesson 6: Designing Forms
    • Create a Form
    • View Data Using an Access Form
    • Modify a Form
  • Lesson 7: Generating Reports
    • View an Access Report
    • Create a Report
    • Add a Calculated Field to a Report
    • Format the Contruls in a Report
    • Apply a Theme to a Report
    • Prepare a Report for Print

 
Duration: 8 Hours
Course Fee: INR. 5,000 + tax

Access 2010: Level 2

Course Outline

 

  • Lesson 1: Contrulling Data Entry
    • Constrain Data Entry Using Field Properties
    • Establish Data Entry Formats for Entering Field Values
    • Create a List of Values for a Field
  • Lesson 2: Joining Tables
    • Create Query Joins
    • Join Tables with No Common Fields
    • Relate Data Within a Table
  • Lesson 3: Creating Flexible Queries
    • Set the Select Query Properties
    • Retrieve Records Based on Input Criteria
    • Create Action Queries
  • Lesson 4: Improving Forms
    • Restrict Data Entry in Forms
    • Organize Information with Tab Pages
    • Add a Command Button to a Form
    • Create a Subform
    • Display a Summary of Data in a Form
    • Change the Display of Data Conditionally
  • Lesson 5: Customizing Reports
    • Organize Report Information
    • Format Reports
    • Contrul Report Pagination
    • Summarize Report Information
    • Add a Subreport to an Existing Report
    • Create a Mailing Label Report
  • Lesson 6: Sharing Data Across Applications
    • Import Data into Access
    • Export Data to Text File Formats
    • Export Access Data to Excel
    • Create a Mail Merge

 
Duration: 8 Hours
Course Fee: INR.6,000 + Tax

Access 2010: Level 3

Course Outline

 

  • Lesson 1: Structuring Existing Data
    • Restructure the Data in a Table
    • Create a Junction Table
    • Improve the Table Structure
  • Lesson 2: Writing Advanced Queries
    • Create SubQueries
    • Create Unmatched and Duplicate Queries
    • Group and Summarize Records Using Criteria
    • Summarize Data Using a Crosstab Query
    • Create a PivotTable and a PivotChart
  • Lesson 3: Simplifying Tasks with Macros
    • Create a Macro
    • Attach a Macro
    • Restrict Records Using a Condition
    • Validate Data Using a Macro
    • Automate Data Entry Using a Macro
  • Lesson 4: Creating Effective Reports
    • Include a Chart in a Report
    • Print Data in Culumns
    • Cancel Printing of a Blank Report
    • Publish Reports as PDF
  • Lesson 5: Maintaining an Access Database
    • Link Tables to External Data Sources
    • Manage a Database
    • Determine Object Dependency
    • Document a Database
    • Analyze the Performance of a Database

 
Duration: 8 Hours
Course Fee: INR. 7,000 + Tax