MS Access Training Courses In Jaipur provides an introduction to the basic concepts of Microsoft Access.On completion of this course, the delegates are going to be ready to use an existing Access Database effectively and be ready to create and modify simple Tables, Queries,Forms and Reports.
Target Audience – MS Access Training Courses In Jaipur
MS Access Training Courses In Jaipur is suitable for delegates who wish to find out how to use databases effectively and to make simple databases for single-user use. No previous knowledge of Access is assumed, but delegates should be familiar with using one or more of the other programs within the Microsoft Office suite.
Prerequisites – MS Access Training Courses In Jaipur
Basic Computer
Basic Internet
Advanced Excel
Recommended Next Course
Commercial Accountant
Digital Marketing
MS Access Training Courses In Jaipur Contents
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 question
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 rearrange rows and columns
Freeze fields
Hide columns
Session 4 – Working with tables and fields – Objectives
