loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for MS Access

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid 10 digit Phone Number

Note: Please enter the phone number that you want to receive a call on.

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

Share

course photo

MS Access

Mathikere, Bangalore

7,000

23 Reviews
0 Interested

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
Gallery
Reviews

Ashok

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

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Ashok

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

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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 " "

attended MS Access


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." "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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." "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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." "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


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. "

attended MS Access


Pavan B S

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

attended MS Access


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. "

attended MS Access


Date and Time

Not decided yet.

About the Trainer

iTAS

MBA


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

Students Interested 0

Course Id: 13650