info@takeoffprojects.com
Logo
CORPORATE TRANING ON MS ACCESS

Topics Covered
Advance Features of Ms-Access. This course also enables the student to utilize, the advance features taught in this course in an office environment with maximum efficiency.


Microsoft Access
Module 1: Introduction to Ms-Access
  • Getting Started
  • Creating a Database

Module 2: Creating Tables
  • Data types and sizes
  • Field properties
  • Creating indexes
  • Entering data
  • Editing and deleting data
  • Datasheet view and from view

Module 3: Creating Tables
  • Copying and moving data
  • Sorting data
  • Creating filters on data
  • Specifying relationships between tables

Module 4: Creating Simple Queries using QBE grid
  • Queries involving multiple tables
  • Creating lookup queries

Module 5: Prompting for selected Criteria
  • Using totals, averages, and other calculations
  • reating crosstab queries
  • Action queries

Module 6: Creating simple forms using Form Wizards
  • Main/sub forms

Module 7: Introduction to macros
  • Creating and running simple macros
  • Attaching macros to forms

Module 8: Creating Reports
  • Single-column reports
  • Tabular reports
  • Mailing label reports
  • Creating summary reports
  • Creating groups / totals reports

Module 9: Creating graphs from your data
  • Importing data from Excel and other data sources
  • Exporting data to Excel and other formats

Call us : (+91) 9030333433 / 08772261612
Mail us : takeoffstudentprojects@gmail.com
Mail us : info@takeoffprojects.com
Call us : (+91) 9030333433 / 08772261612
Mail us : takeoffstudentprojects@gmail.com
Mail us : info@takeoffprojects.com