Access Course in Gurgaon

Lecturer
admin
Category
0 Reviews

Course Description

The objective of the course is to train students in basic operations of the Microsoft Access database program for everyday activities and enhance their productivity. It gives the students the basic knowledge and methodologies required for using complex features like maintaining databases and utilizing program techniques that improve MS Access applications.

After the completion of the course, students will be able to recognize the basic modules of the MS Access database. They can also build the structure of the database; manage the data in table form, design forms, and generate reports.

Pre-Course Requirements

  • Basic Knowledge of Computer
  • Personal Laptop (if possible)
  • Positive Attitude
  • Know-How to serve on the internet
  • Self Learning Skill
  • Willing to learn Attitude

Course Objective:-

  • Setting up Tables and Fields
  • Building Table Relationships
  • Entering and Editing Data in Tables
  • Creating and Using Forms
  • Making Forms More Usable with Controls
  • Making Forms Attractive
  • Sorting Records
  • Filtering Records
  • Using Queries to Make Data Meaningful

Course Content Covered

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

What Will You Achieve

  • Improve the chances of success in getting a job
  • This practice techniques will enable you to tackle interviews question for jobs
  • This course will help to identify or understand the requirements of the recruiters
  • Help you to do research work
  • Help you to identify what questions you may be asked at the interview
  • This course will help you to understand how to approach answering different types of interview questions
  • These practice techniques will help you to understand your strengths, skills, and key selling points to tackle interviews with confidence
  • Help you to understand and tackle different types of interviews, from telephone and video interviews to non-standard interviews, and how to tackle them

Reviews

0
0 Ratings
stars 5
0%
0
stars 4
0%
0
stars 3
0%
0
stars 2
0%
0
stars 1
0%
0

There are no reviews yet.

Leave a Review

Be the first to review “Access Course in Gurgaon”



mothers day necklaces of birthstonesmothers day necklace with birthstonesmothers day necklace birthstonesmothers day birthstones necklacesatin pajamassilk scarfarmy bombbts army bombarmy bomb btsbts face maskcollier fete des meresmuttertagsgeschenk schmuckbangtan clothingkpopkpop merch