This course is as an extension to the fundamentals in Microsoft Office Access. It will be looking at advanced topics for the use of a database. Establishing relationships, working with subreports & subforms, switchboards, building expressions, and working with pivot tables and charts will be covered to ensure the participant understands the different components which make up the product.

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

• Normalize tables, set table relationships, and implement referential integrity between related tables.
• Create a Lookup list field, modify Lookup field properties, and use a subdatasheet to add data to related tables.
• Create join queries, create calculated fields in a query, and use queries to view summarized and grouped data.
• Add unbound controls, graphics, calculated fields, and a combo box to a form.
• Add headers and footers in a report, use functions to add calculated values in a report, and embed a subreport in a report.
• Create and modify charts in forms and reports.
• Create a PivotTable, modify a PivotTable, and create a PivotChart.
• Create and use hyperlink fields and data access pages.
• Create and use macros.
• Analyzing Database

General public and industry specific personel who want to gain better product knowledge.

1.   Querying in Access
2.   Querying with SQL
3.   Relational databases
4.   Customising Reports and Forms
5.   Creating Charts
6.   Creating Pivot Tables And Pivot Charts
7.   Creating Pivot Tables Forms
8.   Creating Pivotchart Forms
9.   Object Linking and Embedding
10. Protecting Data
11. Creating and Using Macros
12. Analyzing Databases

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