This course is to introduce the participants to the basics of Microsoft Access and what can be expected of this daabase software. It will familiarise the user to the Access interface and basic editing and formatting functions.The participants will also learn on Access essentials such as using the Query, Reports, Forms and adding images.

At the end of this course participants should be able to:

• Organize data efficiently by using a database management system; start Access and open Access databases; and use the Help feature.
• Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
• Modify a table's design; use the Find feature and the spelling checker; and sort, filter, and delete records.
• Set field properties; create input masks; set validation rules; and create single- and multiple-field indexes.
• Create queries, and sort and filter the results; modify queries; and perform operations in queries.
• Create, modify, and work with forms; and use them to find, sort, and filter records.
• Create reports by using AutoReport, the Report Wizard, Design view, and queries; and modify and print reports.

General public. No prior background is needed.

1. Using the office assistant
2. Using menus and toolbars
3. Exploring the Access environment
4. Table design
5. Entering and editing table data
6. File procedures
7. Querying data
8. Working with forms
9. Working with reports

Informatics Campus
10 & 12 Science Centre Road, Singapore 609080

Course Enquiry Hotline: (65) 6580 4555
Email: enquiry@informaticseducation.com
SMS: +65 91072222

Opening Hours:
Monday - Friday : 9.00am to 9.00pm
Saturday : 9.00am to 5.00pm
Closed on Sunday and Public Holidays