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)

25 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

Date and Time

Not decided yet.

Gallery (2)

About the Trainer

5 Avg Rating

1379 Reviews

1398 Students

18 Courses

iTAS

MBA

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

Student Feedback

5.0

Average Rating

100%
0%
0%
0%
0%

Reviews

R

Ramesh Babu

" 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

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

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

G

Geetha

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

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

"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

"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

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

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

"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

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

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

"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

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

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

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

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

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

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

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

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

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

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

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

B

Bhanu Prakash

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.

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for MS Office Software Training Post your requirement now

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 the OTP sent to your registered mobile number.

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

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more