MS Access

Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on MS Access which gives you the opportunity to interact with a MS Access instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants. Design advanced queries, forms and reports Use macros to increase productivity and perform advanced functions Demonstrate an advanced understanding of Microsoft Access

Course Content


Office Workspace Basics

  • Basic Window Elements
  • Exploring Microsoft Office Backstage
  • Working with the Ribbon
  • Customizing the Quick Access Toolbar
  • Working with KeyTips
  • Using the Status Bar
  • Getting Help

Introduction to Access

  • What is an Access Database
  • Opening a Database File
  • Exploring Database Objects
  • Creating a Database
  • Changing Views
  • Printing Database Objects
  • Saving and Closing a Database File

Working with Tables

  • What is a Table?
  • Working with Datasheets
  • Moving Among Records
  • Updating Records
  • Adding Records to a Table
  • Selecting Rows and Columns
  • Finding Records
  • Sorting Records
  • Filtering Records
  • Using the PivotChart View
  • Saving and Closing a Table

Designing Tables

  • Adding a Table to a Database
  • Adding Fields to a Table
  • Adding a Lookup Field
  • Setting a Primary Key
  • Using the Input Mask Wizard
  • Saving Design Changes
  • Importing Data
  • Exporting Data
  • Performing Database Maintenance

Creating and Running Queries

  • What is a Query?
  • Creating a Query
  • Working with Queries
  • Saving and Running a Query
  • Creating Calculated Fields
  • Using Agregate Functions
  • Understanding Query Properties
  • Creating Multi-Table Select Queries
  • Joining Tables
  • Enforcing Referential Integrity

Using Forms

  • What is a Form?
  • Using the Form Tool
  • Creating a Form with the Form Wizard
  • Working in Design View
  • Changing the Form Layout
  • Using Calculated Controls
  • Working with Records on a Form

Generating Reports

  • What is a Report
  • What is a Report Tool
  • Previewing and Printing a Report
  • Saving a Report
  • Designing a Report
  • Changing a Report Layout
  • Understanding Controls
  • Using a Calculated Control
  • Analyzing Dependencies
  • Creating Mailing Labels

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234