Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

MS Access

25 Reviews

Mathikere, Bangalore

Course ID: 13650

Mathikere, Bangalore

Students Interested 0 (Seats Left 0)

₹ 7,500

25 Reviews

Date and Time

Not decided yet.

iTAS

MBA

About iTAS

10+ Years of experience in Advance Excel, VBA, Macros, Access, Dashboard Designing, Automation, MS Word, MS PowerPoint, SAS, Analytics, Statistics
R

Ramesh Babu

Attended MS Access

" I have joined ITAS march 1st week on VBA and I got job 28th March. Its really good institution to teaching for students and faculty is supporting to teach very good to clarifying doubts of interview questions."

P

Pradeep Raj S

Attended MS Access

I did MS Access Training in iTech Analytic Solutions. Now I got job in HP. Thanks for iTech Analytic Solutions for preparing for Interviews. The instructor and manuals are wonderful. Thanks Once again.

A

Ashok

Attended MS Access

I completed my MS Access @ iTech Analytic Solutions. Very professional and real time examples. Thank you iTAS and team.

G

Geetha

Attended MS Access

I had joined Analytics & Reporting course @ iTAS. Overall training was really good and learnt a lot in Analytics & Reporting techniques. Training's are well structured, especially for freshers and teaching is also excellent. Sure I will refer my friends.

R

Raghavendra Pai M

Attended MS Access

I studied MS Access course in iTech Analytic Solutions last month. Training is really good. Practical oriented training. Thanks to iTAS Team for the quality training.

V

Vinay R

Attended MS Access

"Just dropped in to say that it was a pleasure to work with you in the excel classes in the past few weeks. The sessions were really smooth, well planned and well executed too. If you need to learn about core analysis or refresh / update your knowledge this is an excellent course "

G

Guruprasad V

Attended MS Access

"I did MS Access Training in iTech Analytic Solutions. Now I got job in HP. Thanks for iTech Analytic Solutions for preparing for Interviews. The instructor and manuals are wonderful. Thanks Once again."

K

Kiran Karkra B N

Attended MS Access

Advance Excel, VBA, MS Access Very Low Price / High Quality Trainers / Placement Support. This are the reasons everyone choosing iTAS. I went around 4 institutes to learn Advance Excel. I came to know iTech Analytics through my friend working in Accenture. He suggested me iTAS for Advance Excel.  I will rate 5/5 for the trainings and support.

N

Nagaraj S Bhavimani

Attended MS Access

Good professional Team to teach all aspects of Advance Excel, VBA, MS Access which practical classes which is more important. When I compare iTAS from other institute the major difference I found is Hands on training. Thank you very much iTech Analytic Solutions.

G

Gurudev A R

Attended MS Access

"I did MS Access Training in iTech Analytic Solutions. Now I got job in HP. Thanks for iTech Analytic Solutions for preparing for Interviews. The instructor and manuals are wonderful. Thanks Once again."

V

Vinod M N

Attended MS Access

I studied MS Access course in iTech Analytic Solutions last month. Training is really good. Practical oriented training. Thanks to iTAS Team for the quality training.

R

Raghavendra Ba

Attended MS Access

I studied MS Access course in iTech Analytic Solutions last month. Training is really good. Practical oriented training. Thanks to iTAS Team for the quality training.

P

Pradeep Raj S

Attended MS Access

"I did MS Access Training in iTech Analytic Solutions. Now I got job in HP. Thanks for iTech Analytic Solutions for preparing for Interviews. The instructor and manuals are wonderful. Thanks Once again."

R

Raghavendra

Attended MS Access

iTech Analytic Solutions, Bangalore is the nice place to Learn practical Advance Excel, VBA, MS Access courses . Trainers are Really professional and helpful. Thanks to iTAS and the trainers.

G

Ganesh N

Attended MS Access

This was one of the best workshops I have ever attended. I recommend this training to all analytic sectors interested in seeing real progress in their jobs. The venue, materials & facilitation was excellent. All the best iTech.

G

Ganesh N

Attended MS Access

This was one of the best workshops I have ever attended. I recommend this training to all analytic sectors interested in seeing real progress in their jobs. The venue, materials & facilitation was excellent. All the best iTech.

A

A Veerakumar

Attended MS Access

It would be the best move I have made for my career in Analytics and choose ITech Analytic Solutions. It is wonderful to learn something new and looking forward to build a career on the same.

M

Mahalakshmi C

Attended MS Access

Analytics from ITech Analytic Solutions is a Great experience both theoretically and practically. The Way of Teaching is excellent and practice after each Topic makes understand much better. Analytics is one of the unique domains where one can have a competitive edge and can withstand with the changing market environment.

A

Abhishek Holla

Attended MS Access

I have attended MS Access training. The faculty was very good and he explained all the concepts of SQL with real time scenario. I also got support in developing my own Project. Overall experience in iTech Analytic Solutions is very good.

P

Prashanth S

Attended MS Access

Really Happy to Share my MS Office Training Experience with all . I am from B.Com background previously. I learned MS Office in ITech Analytic Solutions. Training was very good and Practical Oriented. Now I got placed in Cannon . Thanks to ITech Analytic Solutions.

E

Eswara Chinnaswamy

Attended MS Access

Really Great Advance MS Office Training by iTech Analytics . Really practical oriented only. About the fee, Training Fee also very less when compare to other institutes. Thanks for ITech Analytic Solutions for providing wonderful opportunity.

S

Spandana S

Attended MS Access

I did MS Access Training in iTech Analytic Solutions. Now I got job in HP. Thanks for iTech Analytic Solutions for preparing for Interviews. The instructor and manuals are wonderful. Thanks once again.

Y

Yogesh Damle

Attended MS Access

I studied MS Access course in iTech Analytic Solutions last month. Training is really good. Practical oriented training. Thanks to iTAS Team for the quality training.

P

Pavan B S

Attended MS Access

"We really enjoyed your training session and got very good Analytic Skills along with MIS Reporting. Thanks to iTAS"

B

Bhanu Prakash

Attended MS Access

The ITAS has given me the confidence to move ahead in my career. It gave me the opportunity to step back and reflect on what I do, how well I do it and where I can improve together with the toolkit to progress. It has given me a much greater sense of appreciation for what it is to become strategically focused. But ultimately, it was the opportunity to apply my existing skillset coupled with those skills learned on Business Analytics in my own workplace that has proved most rewarding.

View more Reviews

About the Course

With our MS Access training courses, you will gain the required knowledge to create, maintain and process
large amounts of data easily. We have expert MS Access trainers to show how to make use of all the
powerful tools.
Depending on your current Access knowledge, you might want to attend a standard course, e.g. Access
Introduction or Access Advanced. Alternatively, we also run bespoke MS Access training courses, e.g.
Queries Only, or Form Development. This is what makes us different. We can tailor any part of the courses to
suit your needs.

Topics Covered

Access basics
? Familiarity with access screen
? Ribbon and toolbar explanations
? Prebuilt database template access and creation
Database Terms Planning
? An explanation of databases in general, database objects within access and terminology
? Plan your Database (Tables, Queries, Forms, Reports, Macros, Pages and Modules)
Plan a database structure. (tables) (normalisation Techniques)
? Create a new database file
Working with Tables
? Design a Table, Conventions for entering Naming objects and fields (Design View)
? Create a table in datasheet view and edit field names
? Select data types and enter field descriptions
? Set a Primary Key
? Remove a Primary Key
? Define Field Properties (Default values, Input masks, Validation rules and format options)
? Insert, Delete, Move and Rename Fields (design view and datasheet view)
? Create a Table with a Wizard
? Using the ribbon to set field properties
Entering and Editing Data
? Accessing objects through the navigation pane
? Switch between object Tabs
? Switch Views in Access (design, layout and data entry)
? Entering and Editing Data (Records & Fields)
? Navigating the datasheet
? Working in Data Entry Mode
? Sorting Data, Finding & Replacing Data
? Hiding and Un hiding Fields
? Create multiple tables to normalise data
Relationships
? Relationships explained?
? Different types of relationships (one to many etc.)
? Conditions needed for setting up a relationship
? Ensuring Referential Integrity
? Printing Relationships in a Report
? Insert Sub Datasheets into a table
? Change or remove Sub Datasheets from a table
? Expand and Contract Sub Datasheets
? Enter data in related tables
Queries & Filters
? Create a filter by selection
Create a filter by form
? Use AND/ OR options
? Save a filter as a select query
? Run a Select Query
? Build a query from the create ribbon
? Creating a query using a wizard
? Build a query using the Query Design Window
? Adding fields to a query, choose which fields to show
? Removing fields from a query
? Sort data in a select query
? Enter Text, numeric, date, and logic criteria
? Enter sub string searches using wild Card Characters
? Use the BETWEEN, AND, OR, NOT, NULL criteria in your query
? Calculate a field
? Concatenate text
? Save and name a query
? Rename, edit or delete a query
Multi Table Queries
? Build a query across more than one table
? Joining Tables for a query (more relationships)
? Setting Join Properties - Inner and Outer Joins
? Find Unmatched records Query Wizard
? Find Duplicate records Query Wizard
Creating Forms
? Create a Form using the Auto Form tool Tabular/Datasheet/Pivot Form wizard
? Create a Form using the Form Wizard
? Create a form in design view
? Create a form in layout view
? Understand the views and switch between them
? Setting data source for a form
? Setting the data source using SQL source code
? The Field List
? Resizing Forms
? Control types
Adding controls
? Resize and Move Controls
? Changing control properties
? Selecting Controls
? Formatting Controls
? Use the Format Painter and AutoFormat
? Set basic form properties
? Data Entry in Forms
? Navigation in data entry view
? Add, edit, delete a record in form view
Reports
? Standard Reports using Wizard
? Insert, Move, Size and delete controls
? Editing record source
? Page setup
? Print your report
Advanced Tables
? Input mask
? Applying validation
? Validation text
? Calculating a field
? Multiple primary keys
? Lookup fields
? Formatting a field
? Link to external data source
Recap and More on Relationships
? Why create relationships between tables?
? Different types of relationships
? Adding tables to the relationship window
? Creating, editing and deleting relationships
? Conditions for setting up a relationship
? Understanding Referential Integrity
? Using the Cascade Update option
? Using the Cascade Delete option
? Saving relationships
Advanced & Action Queries
? Creating Calculated fields
? Creating Parameter Queries
? Creating Summary Queries
? Creating a Crosstab Query
? Editing a Crosstab Query
? Use the Top Values option in a Query
? Create and use a Make Table Query
? Create and use an Append Query
? Create and use a Delete Query
? Create and use an Update Query
Advanced Forms
? Main Form and sub forms
? Exploring Layout View
? Split forms
? Using Checkboxes & toggle buttons
? Using combo boxes
? Adding Option group controls
? Adding Command button Controls
? Setting more form properties
? Calculation in a Form
? Concatenating Text Values
? Changing the data source options
? Setting the Tab Order
? Adding and Removing Filters (Selection and Forms)
? Defining Validation Rules
? Using advanced controls
? Template Forms
Advanced Reports
? Customise your Report
? Format the controls
? Using Expressions
? Adding Sub Reports
? Parameter reports
? Report Templates
? The Keep Together property
? Mailing Labels
? Grouping interval properties
? Group Headers/footers calculations
? Page setup
? Page breaks
Importing & Linking Data
? Importing from Access and Excel
? Linking to an external Access Database Table
? Linking to an Excel Workbook
? Renaming and Copying Tables
? Linked table manager
? Export to various formats
? Charts and Pivots
? Create a PivotChart / PivotTable
? Edit PivotTable options
? Formatting a chart
? Changing the chart type
? Parameter chart
? Chart based on single record

Who should attend

Freshers looking for Access or database jobs jobs
Professionals planning to improve word skills
Anyone who want to improve in MS Office applications

Pre-requisites

No previous experience of Access is required to attend this course. You must have good basic Windows
skills, e.g. Mouse and Keyboard

What you need to bring

Laptops (if available, else will be provided)

Key Takeaways

knowledge on advance access reporting, forms and database management

Reviews (25) See all Reviews

R

Ramesh Babu

Attended MS Access

" I have joined ITAS march 1st week on VBA and I got job 28th March. Its really good institution to teaching...

P

Pradeep Raj S

Attended MS Access

I did MS Access Training in iTech Analytic Solutions. Now I got job in HP. Thanks for iTech Analytic...

A

Ashok

Attended MS Access

I completed my MS Access @ iTech Analytic Solutions. Very professional and real time examples. Thank you iTAS and team.

G

Geetha

Attended MS Access

I had joined Analytics & Reporting course @ iTAS. Overall training was really good and learnt a lot in...

R

Raghavendra Pai M

Attended MS Access

I studied MS Access course in iTech Analytic Solutions last month. Training is really good. Practical...

V

Vinay R

Attended MS Access

"Just dropped in to say that it was a pleasure to work with you in the excel classes in the past few...

Gallery (2)

Discussions

Students Interested 0 (Seats Left 0)

₹ 7,500

Post your requirement and let us connect you with best possible matches for MS Office Software Training Post your requirement now
₹ 7,500 Enquire

Enquire

Submit your enquiry for MS Access

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With iTech Analytic Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer