Technology Course

Microsoft Access 2007

Course Type: Certification | Study Mode: Full-Time
Keywords: Microsoft Office | Microsoft access | Microsoft courses
Course Provider:
INR 6000.00
(Excluding taxes)

Course Detail

Introduction
Introduction-

 

 

 

  • Introduction to databases
  • Becoming familiar with Access
  • Designing databases
  • Creation of a table in the datasheet view
  • Table design view
  • Special field types
  • Working with a table
  • Looking up and editing records
  • Filtering and sorting records
  • Fields selection and records sorting with a query
  • Working with criteria for the select query
  • Creating calculated items
  • Linked tables in queries
  • Analysis of relationships between tables
  • Relationships and referential integrity
  • Lookup column
  • Overviews
  • Queries with parameters
  • Action queries
  • Crosstab query

Intermediate

  • Joins and their properties
  • Functions and Expression Builder
  • Aggregate functions
  • Data normalization
  • Create queries
  • Field indexing and data validation
  • Creating a form by using the wizard
  • Working with forms
  • Creating a form in design view
  • Working with form controls
  • Calculated items in the form
  • A combo box in the form
  • Buttons in the form
  • Organizing fields in the form
  • Creating a form with a subform by using wizard
  • Inserting subforms in the design view
  • A form as a user interface

Advanced

  • Joins and their properties
  • Functions and Expression Builder
  • Aggregate functions
  • Data normalization
  • Create queries
  • Field indexing and data validation
  • Creating a form by using the wizard
  • Working with forms
  • Creating a form in design view
  • Working with form controls
  • Calculated items in the form
  • A combo box in the form
  • Buttons in the form
  • Organizing fields in the form
  • Creating a form with a subform by using wizard
  • Inserting subforms in the design view
  • A form as a user interface
Advanced
This course focuses on the creation of reports, data access pages and macros. You will also learn about the options for database management, for data import and export and also about SQL language.

List of Lessons:
  • Dependent objects and property inheritance
  • Creating reports
  • Reports with calculations
  • Graphic adjustments in reports
  • Pivot table and chart
  • How to work with macros
  • Matching macros and buttons
  • Verifying data by means of macros
  • Evaluating data by means of macros
  • Print and database documenter
  • Importing objects and splitting the database
  • Data export
  • Automatic import and export
  • XML Format
  • Navigation in databases
  • Database security and administration
  • SQL language