corporates.training@gmail.com
Follow us on

Microsoft Access

2 Half Days Workshop In Microsoft Access

MS-Access (Office 356, Office 2016, Office 2013, Office 2010)

Microsoft Access is a software program used to build and run databases.Whether you are new to Access or an advanced user, this training will cover what you need to know as efficiently as possible.

Module 1: Introduction to MS-Access (Office 356, Office 2016, Office 2013, Office 2010)

  • 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 selection Criteria

  • Using totals, averages, and other calculations
  • Creating crosstab queries
  • Action queries

Module 6: Creating simple forms using Form Wizards

  • Main/sub forms

Module 7: Introduction to macros

  • Creating and runing 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
  • Creating a Word Mail Merge report

Module 9: Creating graphs from your data

  • Importing data from Excel and other data sources
  • Exporting data to Excel and other formats


    [google-reviews-pro place_name=’Corporate Training in Advanced Excel Courses & VBA Macros Courses in Mumbai’ place_id=ChIJBdnh4EbJ5zsRIKZnfZExwAo auto_load=true rating_snippet=true min_filter=2 write_review=true view_mode=slider nofollow_link=true lazy_load_img=true]

    Open chat