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

 

Certifications & Affiliations

Image

Why SAMYAK ?

• Registered LLC Company in Florida, USA
• Presence in Dubai & Many States / Cities across India.
• An ISO 9001:2015 Certified Company
• GOOGLE & HP Certification Partner
• Authorized Tally Institution of Learning from Tally Company (HO)
• Authorized Microsoft, AutoDesk, Adobe, Apple, EC-Council & Unity Testing & Certification Partner
• Pearson Testing Centre – Oracle, Cisco, Salesforce, AWS, RedHat & ALL IT Giant’s Certification Partner.
• 17+ Branches Worldwide & Growing ...
• Dedicated IT team of 200+ working on International Level Projects

International CERTIFICATIONS with Live Projects

• Samyak believes in employability and hence Samyak provides training with less theory and more of Practical work.

• Course modules are prepared by Expert IT Professionals & HR.

• 100% Placement Assistance. We have good track record of placements.

• Samyak has 450+ Computers, Switches, Routers, PLCs, Hardware and Software AND has enormous in-house projects to support the project based training.

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

• Highest Rating ( Google, Facebook, Justdial & Others) & Global Rewards in Education Sector.

Click To Fix An Appointment