Microsoft Office Access 2007

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.

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

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

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

Go To Top

Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can Claim SDF Funding, subject to SSG Eligibility Criteria.

Applicable for Company Sponsored Singaporeans & PRs.

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 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 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, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!