Microsoft Access 2010

Microsoft Access 2010 Training teaches you how to design data tables, select appropriate data types and relate tables logically.

You will create and modify database objects including tables, forms, reports, queries and macros, and will apply intermediate skills to streamline data entry, ensure data integrity, automate tasks and analyze data.

You will also use advanced form controls to locate information and restrict data entry, and will set form properties that respond to events.

We also offer

Microsoft Access 2016 Training Courses in Singapore

Microsoft Access 2013 Training Courses in Singapore

Learn Access 2010 @Intellisoft
Learn Access 2010 @Intellisoft

The key objective is to teach the student the most important aspect of using Microsoft Access 2010 for simple to more complex projects.

  • Students learn to create optimized databases, create tables, store data, and create Forms and Applications that allow for Create/Update/Read/Delete operations easily using the excellent and powerful functionality of Microsoft Access.

You will learn how to:

  • Retrieve Data from Access 2010 Database
  • Work with Forms to allow for add / edit / deletion of data from Access databases
  • Design Reports for Easier analysis in Microsoft Access 2010.

This course is for the people who want to create their own database on Windows and learn to manage their own data.

In this training course you will learn: how to create, update and delete the data in database tables.

Microsoft Access 2010 Training at Intellisoft
Microsoft Access 2010 Training at Intellisoft

 Lesson 1: Exploring the Access 2010 Environment

  • Environment
  • An Introduction to Databases
  • What is Access?
  • Database Objects
  • Components of the Access 2010
  • User Interface
  • Looking at the Screen
  • The Access Startup Screen
  • Managing Database Files
  • Using the Navigation Pane
  • Setting Access Options
  • Lesson Summary
  • Review Questions
Lesson 2: Building Tables 
  • Table Basics
  • Data Types
  • Creating Tables in Design View
  • Modifying Tables in Design View
  • Primary Keys
  • Creating Tables in Datasheet View
  • Reusing Design Elements
  • Entering Records in Datasheet View
  • Importing Data
  • Working with Records
  • Table Relationships
  • Viewing Related Data
  • Lesson Summary
  • Review Questions
Lesson 3: Retrieving the Data You Want 
  • Retrieving Data
  • Finding Records
  • Sorting Records
  • Filtering Records
  • Creating Queries
  • Modifying Queries
  • Adding Query Criteria
  • Working with Joined Tables
  • Performing Calculations in Queries
  • Creating Action Queries
  • Creating Crosstab Queries
  • Lesson Summary
  • Review Questions
Lesson 4: Working with Forms 
  • Why Use Forms?
  • Form Types
  • Form Views
  • Creating Forms Using Automated
  • Form Tools
  • Subforms
  • Using the Form Wizard
  • Creating Forms from Scratch
  • Modifying Forms
  • Lesson Summary
  • Review Questions
Lesson 5: Designing Reports 
  • What is a Report?
  • Report Views
  • Creating Reports
  • Creating a Report Using the Report
  • Wizard
  • Creating a Blank Report
  • Working with Reports in Layout View
  • Working with Reports in Design View
  • Adding Finishing Touches to Reports
  • Sorting and Filtering Records for
  • Reporting
  • Previewing and Printing Reports
  • Lesson Summary
  • Review Questions

There are no specific pre-requisites for attending this course. You should be familiar with Windows operating system, have the Access software on your computer, and must have a desire to learn Access and create some kind of database management system. If you have a good idea of what you want kind of forms or reports you want to build using Microsoft Access, then this workshop can be of immense help.

Laptops with the required software will be provided for use in the workshop.

Learn Access 2010 @Intellisoft
Learn Access 2010 @Intellisoft

The key objective is to teach the student the most important aspect of using Microsoft Access 2010 for simple to more complex projects.

  • Students learn to create optimized databases, create tables, store data, and create Forms and Applications that allow for Create/Update/Read/Delete operations easily using the excellent and powerful functionality of Microsoft Access.

You will learn how to:

  • Retrieve Data from Access 2010 Database
  • Work with Forms to allow for add / edit / deletion of data from Access databases
  • Design Reports for Easier analysis in Microsoft Access 2010.

Go To Top

This course is for the people who want to create their own database on Windows and learn to manage their own data.

In this training course you will learn: how to create, update and delete the data in database tables.

Go To Top

Microsoft Access 2010 Training at Intellisoft
Microsoft Access 2010 Training at Intellisoft

 Lesson 1: Exploring the Access 2010 Environment

  • Environment
  • An Introduction to Databases
  • What is Access?
  • Database Objects
  • Components of the Access 2010
  • User Interface
  • Looking at the Screen
  • The Access Startup Screen
  • Managing Database Files
  • Using the Navigation Pane
  • Setting Access Options
  • Lesson Summary
  • Review Questions
Lesson 2: Building Tables 
  • Table Basics
  • Data Types
  • Creating Tables in Design View
  • Modifying Tables in Design View
  • Primary Keys
  • Creating Tables in Datasheet View
  • Reusing Design Elements
  • Entering Records in Datasheet View
  • Importing Data
  • Working with Records
  • Table Relationships
  • Viewing Related Data
  • Lesson Summary
  • Review Questions
Lesson 3: Retrieving the Data You Want 
  • Retrieving Data
  • Finding Records
  • Sorting Records
  • Filtering Records
  • Creating Queries
  • Modifying Queries
  • Adding Query Criteria
  • Working with Joined Tables
  • Performing Calculations in Queries
  • Creating Action Queries
  • Creating Crosstab Queries
  • Lesson Summary
  • Review Questions
Lesson 4: Working with Forms 
  • Why Use Forms?
  • Form Types
  • Form Views
  • Creating Forms Using Automated
  • Form Tools
  • Subforms
  • Using the Form Wizard
  • Creating Forms from Scratch
  • Modifying Forms
  • Lesson Summary
  • Review Questions
Lesson 5: Designing Reports 
  • What is a Report?
  • Report Views
  • Creating Reports
  • Creating a Report Using the Report
  • Wizard
  • Creating a Blank Report
  • Working with Reports in Layout View
  • Working with Reports in Design View
  • Adding Finishing Touches to Reports
  • Sorting and Filtering Records for
  • Reporting
  • Previewing and Printing Reports
  • Lesson Summary
  • Review Questions

Go To Top

There are no specific pre-requisites for attending this course. You should be familiar with Windows operating system, have the Access software on your computer, and must have a desire to learn Access and create some kind of database management system. If you have a good idea of what you want kind of forms or reports you want to build using Microsoft Access, then this workshop can be of immense help.

Laptops with the required software will be provided for use in the workshop.

Go To Top

Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can claim from the Skills Development Fund.

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

How To Register

Register for the 2 Day Microsoft Access Class Today. Simply fill the Course Registration form on the top, and book your seat today. Or send an online enquiry for any questions. You can call us at +65 6296-2995.

Call us at +65 6296-2995 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class. We have regular public classes each month, and Custom Corporate Trainingscan be arranged at your office too.

Some of the companies that experienced our trainings

Learn Microsoft Access
&
Advance Your Career

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!