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

Samyak%20Computer%20Classes%20-%2025+%20Branches%20Worldwide
4.7
Based on 2306 reviews
faculty is good and i have good experience from this institution ...thanks to vikas sir to providing me such deep knowledge for Core PHP & Web Development....and also samyak classes...
satish C.
satish C.
09:53 12 Jan 17
nice faculty and good environment . i learn core java here and fully satisfied with teaching and successfully completed my internship
vikash C.
vikash C.
13:13 31 Jul 17
Best computer learning institute..I am the student of Tally Course and i find very convient and teaching is so good.
Kuldeep C.
Kuldeep C.
06:05 11 Oct 17
I have been working at The Coaching Institute full-timeProsi learned many things here with my teaching and probably feel like professor here are very nice.They always provide us with different opportunitiesConsno cons for this institute
Manish S.
Manish S.
06:22 30 Dec 18
i joined Samyak for Tally course .. My Faculty was good, staff behavior was also good. course was completed on time. practical practice was also helpful.......The punctuality of staff is good. Samyak is a good institute in Jaipur specially the way is teaching and explaining about the subject we are doing and the teacher is also well experienced here so the way of teaching is good.
tinku G.
tinku G.
11:15 15 Mar 18
I joined with Samyak , the classes of Spoken English..Faculty is too good..It was a great experience with Samyak.
DIPAK P.
DIPAK P.
09:33 17 Jan 18
Samyak is the best institute, the trainers are very good and co-operate with every students. Their teaching sense is very different that I like and for special learning, I will suggest Samyak classes.
Pinky R.
Pinky R.
05:50 15 May 17
I found Samyak to be a very great institution for learning various courses. It has one of the best faculties in all field. I am glad i was a part of this institute.
Shikha G.
Shikha G.
05:09 21 Nov 19
My name is Kajal Khan .samyak is best training institute for Practical Knowledge. autocad faculty is very good and all staff is nice
Kajal K.
Kajal K.
11:37 04 Feb 20
It was a very nice experience learning C/C++ course from Gaurav Sir. He teaches with a lot of patience and clears each and every doubt that arises in the students' mind. This course seemed a bit difficult to me but I learnt it with a lot of ease. I would recommend people to join Samyak for IT training, especially the programming courses
Shiv K.
Shiv K.
04:45 16 Mar 19
There teachers is so good everything is good.i feel good here..all staff is so nice..
Thankq Samyak
Anju Y.
Anju Y.
07:30 25 Jan 18
smayak classes better in the c,c++ language, its improved c,c++, i think smayak classes is better choice in computer language and many other courses.
Rajat K.
Rajat K.
06:37 24 Jan 17
i have done c++ and java and my experience till now is really good . the way sir teaches is also very good
Vishal S.
Vishal S.
10:37 22 Jan 18
It was a great experience studying at this institute. Mukesh Sir has expertise in this field, and he focuses on minute details. He starts with the very basic levels which help in clearing and building the foundation, later on, which helps a lot. The classes and the practical training was very well structured and provided according to the time needed. I started everything from beginning, and he helped me in learning . Overall I would recommend the Institute if you are starting from the scratch and want to become good in Tally accounting
Meenu K.
Meenu K.
08:05 30 Jan 18
SAMYAK computer education center is one of the computer training institute SAMYAK run more the 250 countres in the whole world SAMYAK reward a student with his best educational qualities SAMYAK teach very perfectly with all perctically those student they are going to get thier higher diploma in computer education for their carrier program I sugest them to join every student SAMYAK.
Dilasha G.
Dilasha G.
11:29 22 Jan 18
i am vishan singh from jhotwara. i joined samyak choching 15 day ago. i fell good because there faculty very good and communication also better. i felling better and satisfaction about tally and Excel course.
Bishan S.
Bishan S.
06:46 14 Oct 17
in my opinion the samyak classes is very well as well as personality development is also well .my spoken classes experience is very good.and other activity are like commutation and group discussion
POOJA S.
POOJA S.
11:46 04 Jan 20
I am student of SAMYAK classes Financial Accounting Tally course. It is best institute in all over jaipur . My experience was good with faculty and his behaviour is good . I have completed more than 90% course & ready to solve any kind of problem related to my course. Next I want to do Spoken English Classes from SAMYAK to increase my Interview Skills as well.
Harish D.
Harish D.
07:00 18 Jan 17
An institute which focuses on overall growth of a student in theory as well as practicals required in the future of I.T .
Amanpreet Kaur K.
Amanpreet Kaur K.
14:02 28 Aug 19
I am doing DTP course, fully satisfy , Trainer also gud teach me, Excellent Environment, Properly focus on students, no Doubts yet
B S S.
B S S.
08:15 23 Jan 18

Share This Info ...

Share on facebook
Share on twitter
Share on linkedin
Share on google
Share on whatsapp
Share on email

How May We Help You Today ?