25+ Branches Worldwide | +91 977.227.1081

MS Access Training Course

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.

Duration

2.5 Months including Lab

Eligibility

Undergraduates, Graduates
Post-Graduates
Job Aspirants
School Going Students

Pre-requisites

Advanced Excel

Deep Dive into MS Access Training Course

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

Targeted International Certifications After this Course

Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program. Holding a MOS certification can earn an entry-level business employee as much as Rs 600000 more in annual salary

Samyak IT Solutions Pvt Ltd is an ISO 9001:2008 Certified Company and has international level acceptance for its certifications. Students from Samyak are given preference in placements as they have proper hands on job related knowledge already, that any industry needs these days.

PLACEMENT OF SAMYAKites

8678 SAMYAKites making waves in the industry.

What Our Students Say

Share This Info ...

Share on facebook
Share on twitter
Share on linkedin
Share on google
Share on whatsapp
Share on email
Scroll to Top

How May We Help You Today ?