Microsoft Office

Microsoft Access 2010® Fundamentals

Master your Database Applications Using Microsoft Access 2010®

Duration: 3 Days

 

Who Should Attend:

  • IT Professionals who provide tech support
  • Business Users with database requirements

Course Objectives

  • An overview of the features available in Microsoft Access 2010®
  • Learn how to use an Access 2010® database
  • Learn how to create databases and simple tables
  • Learn how to build data-entry forms
  • Learn how to display data and produce reports.

What will you gain?

By the end of this course you will be able to: 
  • Gain proficiency in the basic features of Microsoft Access and use it effectively to organise information
  • Manage your data by creating simple databases and relational databases
  • Construct simple and complex tables
  • Create queries to filter and sort data, and join data from different tables
  • Design and format the look and appearance of forms
  • Get the know-how to create and present reports based on the data entered
  • Acquaint yourself with the various printing options available in Access and use them to print different objects.

Course Content

  • Work in Access 2010
  • Understand database concepts
  • Explore tables
  • Explore forms
  • Explore queries
  • Explore reports
  • Preview and print Access objects
  • Create databases from templates
  • Create databases and tables manually
  • Manipulate table columns and rows
  • Refine table structure
  • Create relationships between tables
  • Create forms by using the Form tool
  • Change the look of forms
  • Change the arrangement of forms
  • Sort information in tables
  • Filter information in tables
  • Filter information by using forms
  • Locate information that matches multiple criteria.
 
ILM Programmes
 


Our Clients

Downloads

English

Company Brochure
Company Brochure
Public Calendar
Public Calendar
Nationals Development
Nationals Development English

عربي

Arabic Profile
Arabic Profile
ﺑﺮﺍﻣﺞ ﺗﻄﻮﻳﺮ ﺍﻟﻜﻮﺍﺩﺭﺍﻟﻮﻃﻨﻴﺔ
ﺑﺮﺍﻣﺞ ﺗﻄﻮﻳﺮ ﺍﻟﻜﻮﺍﺩﺭ ﺍﻟﻮﻃﻨﻴﺔ