Cancel

MS Access Training Courses in Jaipur

 

 

Course Name – MS Access Training Courses

Duration – 1 Month

 

MS Access Training Courses In Jaipur provides an introduction to the basic concepts of Microsoft Access.On completion of this course, the delegates are going to be ready to use an existing Access Database effectively and be ready to create and modify simple Tables, Queries,Forms and Reports.

 

Target Audience – MS Access Training Courses In Jaipur

 

MS Access Training Courses In Jaipur is suitable for delegates who wish to find out how to use databases effectively and to make simple databases for single-user use. No previous knowledge of Access is assumed, but delegates should be familiar with using one or more of the other programs within the Microsoft Office suite.

 

Prerequisites – MS Access Training Courses In Jaipur

 

  • Basic Computer

  • Basic Internet

  • Advanced Excel

 

Recommended Next Course

 

  • Commercial Accountant

  • Digital Marketing

 

MS Access Training Courses In Jaipur Contents

 

Session 1 – the fundamentals – Objectives

 

  • Describe the seven main Access 2003 objects

  • Start Access and open a database

  • Understand the Access Program Screen

  • Add, Edit and Delete Records in Table View

  • Add, Edit and Delete records in Forms

  • Open and run a question 

  • Open and run a report

  • Close down and exit Access

 

Session 2 – Creating and working With A Database – Objectives

 

  • Understand Primary Keys

  • Understand data types

  • Create a database

  • Create a table

  • Create a query

  • Create a form

  • Use the form wizard

  • Create a report using the report wizard

 

Session 3 – Finding, filtering and formatting data – Objectives

 

  • Find and replace information

  • Sort records

  • Filter records

  • Adjust and rearrange rows and columns

  • Freeze fields

  • Hide columns

 

Session 4 – Working with tables and fields – Objectives

 

  • Understand field properties

  • Index a field

  • Change a field’s data type

  • Apply formats to number and text fields

  • Set default values and apply field validation

  • Create input masks

  • Create and modify lookup fields

  • Create value lists

 

Session 5 – Creating Relational Databases – Objectives

 

  • Understand table relationships

  • Create relationships between tables

  • Understand referential integrity

  • Implement and test referential integrity

  • Understand relationship types