Microsoft Office Access 2007 Training in Singapore

Course Description:
Microsoft® Office Access 2007 teaches students how to create simple databases, create and modify database objects including tables, forms, reports and queries. You will use a variety of commands, functions, and Microsoft Office Access 2007 capabilities. It is designed for computer users who are new to database programs or who only plan to use Access occasionally.

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Course Objectives

After completing this course, you will be able to:

identify parts of the Access screen
define fields, data types and tables
create a database using templates, create a blank database, open, save and close databases
create a table using Datasheet View or Design View
insert, delete and modify data in a table
add, modify and remove primary key fields
insert, modify and delete a field
add a total row to a table
format, rename and delete tables
save database items in a variety of file formats
import or export data from or to other applications
find and replace data using exact or partial matches, case sensitive and wildcard searches
sort and filter data
create, save, close, or run a query using the wizard or in Design View
create query criteria using comparison, wildcard, AND, OR operators, or calculated fields
change queries field properties and apply aliases
create one-to-one, one-to-many and many-to-many relationships
use the table analyzer
perform maintenance on databases
identify object dependencies
open a database exclusively or with shared access
use the Database Documenter
create a form using the Form tool or the Form wizard
create a form in design or layout view
add, move, resize, delete, formatting, space, anchor or group controls
creating datasheet forms, multiple item forms, split forms, and PivotTable forms
create a report using the Report Tool and Report Wizard
modify a report in design or layout view
print and preview forms and reports
create mailing labels
use input masks, validation rules, or indexed fields
use the lookup wizard or create lookup fields manually
work with query joins
create parameter, unique, unmatched and duplicate select queries
create summary, action, and sub queries
use embedded macros in forms or reports
create and modify charts
create a subform or subreport using the wizard or the subform/subreport too

Go To Top

Target Audience

Lesson 1: Introducing Access

Overview
Planning a Database
Designing the Database
Creating a Database Using a Template
Moving Around a Database
Creating a Blank Database
Organizing Files

Lesson 2: Creating and Modifying Tables

Creating Tables using Datasheet View
Moving Around a Table
Inserting, Deleting and Modifying Data in a Table
Creating Tables using Table Templates
Creating Tables Based on Existing Tables
Creating a Table in Design View
Modifying Data Types
Modifying Field Properties
Adding and Removing Primary Keys
Adding and Removing Multiple Primary Keys

Lesson 3: Manipulating a Table

Restructuring Tables
Formatting Tables
Modifying Tables
Printing and Distributing Tables
Saving a Table as a Web Page
Exporting as PDF or XPS Format

Lesson 4: Data Manipulations

Inserting and Deleting Records
Importing and Exporting Data
Exporting Data to Other Applications
Finding and Replacing Data

Lesson 5: Sorting and Filtering

Sorting Records
Filtering Records

Lesson 6: Select Questions

What is Query?
Creating a Query using the Wizard
Creating a Query in Design View
Saving, Closing and Running Queries
Adjusting Queries
Adding, Modifying, Deleting and Changing the Order of Fields
Sorting Fields
Showing and Hiding Fields
Applying Criteria
Using Comparison Operators
Using Wildcard Characters

Functions and Calculated Fields
Changing Field Properties
Working with Aliases
Filtering Query Data

Lesson 7: Relating Multiple Tables

Establishing Table Relationships
Enforced Referential Integrity
Print Relationships
Using the Table Analyzer

Lesson 8: Maintaining Databases

Database Maintenance
Opening Databases
Modify Database Options
Modifying Database Documenter
Saving a Database to a Previous Version
Saving a Database with a Password
Splitting Databases

Lesson 9: Working with Forms

What is a Form?
Creating a Form
Using Forms
Sorting Data
Filtering Data
Printing Forms
Exporting as PDF or XPS Format
Creating and Modifying a Form in Layout View
Creating and Modifying a Form in Design View
Creating Datasheet Forms
Creating Multiple Items Forms
Creating Split Forms
Creating Pivot Table Forms

Lesson 10: Working with Reports

What is a Report?
Creating a Report using the Report Tool
Creating a Report using the Report Wizard
Creating and Modifying Reports in Layout View
Creating and Modifying Reports in Design View
Adding and Modifying Calculated Controls
Print Preview and Print Reports
Exporting as PDF or XPS Format
Creating Mailing Labels

Lesson 11: Advanced Table Design

Advanced Field Properties

Using Input Masks
Using Validation Rules
Default Values and Required Fields
Indexed Fields

Using Lookup Fields

Using the Lookup Wizard
Entering Lookup Data Manually
Using Multivalued Fields
Using the Calendar on Date/Time Fields

Linking Tables

Using the Linked Table Manager

Go To Top

Course Outline

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse.

Go To Top

Pre-Requisites

Go To Top

How To Register

Register for the 2 Day Microsoft Access 2007. 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 6250-3575.

To claim SDF Funding of $32 for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals – only available if you apply through your company.

Call us at +65 6250-3575 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.