MS Access Training Courses In Jaipur

Course Name : MS Access
Duration : 20 Hours

MS Access Training Courses In Jaipur provides an introduction to the basic concepts of Microsoft Access.On completion of this course, the delegate will be able to use an existing Access Database effectively and be able 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 learn to use databases effectively and to create 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 in the Microsoft Office suite.

Pre-requisites – 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 query
  • 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 re-arrange 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

 

Why SAMYAK ?

1. Registered LLC Company in Florida, USA
2. An ISO Certified Company
3. Corporate Division, Working on International Level Projects
4. HP Software University Partner
5. RKCL's (Rajasthan Govt) Training Partner
6. Govt. Approved Courses Provider
7. Authorized Microsoft Testing Centre
8. Authorized AutoDesk Testing Centre
9. Authorized Adobe Testing Centre
10. 10 Branches & Growing ...
11. Most Preferred Vendor working on Projects

Live Projects Based Professional Training

1. Samyak believes in employability and hence Samyak provides training with less theory and more of Practicals.

2. Samyak has 150+ Computers, Switches, Routers, PLCs, Hardware and supporting Software AND has enormous in-house projects to support the project based studies.

3. Students of Samyak get opportunity to avail internship and placements in and at partner companies of Samyak (in and out of India).

4. Samyak students have exclusive portal for placement, where companies exclusively request the quality students from SAMYAK only.

5. Being in multiple locations across the Globe, Samyak allows students to take transfer in needed circumstances.

6. Check student's reviews online at Justdial, Sulekha, Facebook, Google Pages etc.

7. Samyak is the fastest growing company in education / training domain, and provides all solutions through cutting edge technologies.

I want to meet SAMYAK Counselor & Faculty