Microsoft Access 2010 Training

9612 Learners

Microsoft Access 2010 Training enables the participant to use this relational database application to enter, store, and retrieve data for referencing and creating reports. This Microsoft 2010 Office Suite application can handle large amount of data. The training delivers the knowledge and skills to input data into forms and tables, retrieve results through queries, and present data in the form of reports. The graphical interface facilitates the user to import or link data stored in different databases and application.

The candidates undergoing the training inculcate the following skills:

  • Understand database management concepts
  • Explore tables, forms, queries, reports
  • Build a database either manually or from templates
  • Define table structure and build relationship among tables
  • Create and customize easy-to-use data entry forms
  • Write queries to extract, filter, manipulate, and delete data from tables either through wizard or manually
  • Design basic to advanced reports to summarize data in effective ways
  • Restrict data in terms of data, its type, format, and validation rules
  • Working with Access tables, relationships, keys and constraints
  • Import data from other databases and documents
  • Create and design Access database solutions
  • Maintain security by assigning password to the database
  • Split database and protect it for distribution
Target audience

The course is intended for the students and professionals who want to build or enhance their skillset in organizing data using Microsoft Access.

Prerequisites

While there is no formal prerequisite for this training, however candidates with basic computer knowledge can undergo this training.

Microsoft Access 2010 Training enables the participant to use this relational database application to enter, store, and retrieve data for referencing and creating reports. This Microsoft 2010 Office Suite application can handle large amount of data. The training delivers the knowledge and skills to input data into forms and tables, retrieve results through queries, and present data in the form of reports. The graphical interface facilitates the user to import or link data stored in different databases and application.

The candidates undergoing the training inculcate the following skills:

  • Understand database management concepts
  • Explore tables, forms, queries, reports
  • Build a database either manually or from templates
  • Define table structure and build relationship among tables
  • Create and customize easy-to-use data entry forms
  • Write queries to extract, filter, manipulate, and delete data from tables either through wizard or manually
  • Design basic to advanced reports to summarize data in effective ways
  • Restrict data in terms of data, its type, format, and validation rules
  • Working with Access tables, relationships, keys and constraints
  • Import data from other databases and documents
  • Create and design Access database solutions
  • Maintain security by assigning password to the database
  • Split database and protect it for distribution
Target audience

The course is intended for the students and professionals who want to build or enhance their skillset in organizing data using Microsoft Access.

Prerequisites

While there is no formal prerequisite for this training, however candidates with basic computer knowledge can undergo this training.

Microsoft Access 2010 Training Course Content

1: Explore an Access 2010 Database

  • Working in Access 2010
  • Understanding Database Concepts
  • Exploring Tables
  • Exploring Forms
  • Exploring Queries
  • Exploring Reports
  • Previewing and Printing Access Objects

2: Create Databases and Simple Tables

  • Creating Databases from Templates
  • Creating Databases and Tables Manually
  • Manipulating Table Columns and Rows
  • Refining Table Structure
  • Creating Relationships Between Tables

3: Create Simple Forms

  • Creating Forms by Using the Form Tool
  • Changing the Look of Forms
  • Changing the Arrangement of Forms

4: Display Data

  • Sorting Information in Tables
  • Filtering Information in Tables
  • Filtering Information by Using Forms
  • Locating Information That Matches Multiple Criteria

5: Create Simple Reports

  • Creating Reports by Using a Wizard
  • Modifying Report Design
  • Previewing and Printing Reports

6: Maintain Data Integrity

  • Restricting the Type of Data
  • Restricting the Amount of Data
  • Restricting the Format of Data
  • Restricting Data by Using Validation Rules
  • Restricting Data to Values in Lists
  • Restricting Data to Values in Other Tables

7: Create Custom Forms

  • Modifying Forms Created by Using a Wizard
  • Adding Controls
  • Adding Subforms
  • Using E-Mail Forms to Collect Data

8: Create Queries

  • Creating Queries by Using a Wizard
  • Creating Queries Manually
  • Using Queries to Summarize Data
  • Using Queries to Perform Calculations
  • Using Queries to Update Records
  • Using Queries to Delete Records

9: Create Custom Reports

  • Creating Reports Manually
  • Modifying Report Content
  • Adding Subreports

10: Import and Export Data

  • Importing Information
  • Exporting Information
  • Copying to and from Other Office Programs

11: Make Databases User Friendly

  • Creating Navigation Forms
  • Creating Custom Categories
  • Controlling Which Features Are Available

12: Protect Databases

  • Assigning Passwords to Databases
  • Splitting Databases
  • Securing Databases for Distribution
  • Preventing Database Problems

13: Customize Access

  • Changing Default Program Options
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar

Drop Us a Query

+91 95550 06479

Available 24x7 for your queries

Free Microsoft Access 2010 Training Assessment

This assessment tests understanding of course content through MCQ and short answers, analytical thinking, problem-solving abilities, and effective communication of ideas.

Try it Now customize time
customize time

Microsoft Access 2010 Corporate Training & Certification Program

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Learn from the experts

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Learn from the experts

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

Learn from the experts

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learn from the experts

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

+91 9555006479

Available 24x7