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 personal who want to gain better product knowledge.

• Querying in Access
• Querying with SQL
• Relational databases
• Customising Reports and Forms
• Creating Charts
• Creating Pivot Tables And Pivot Charts
• Creating Pivot Tables Forms
• Creating Pivotchart Forms
• Object Linking and Embedding
• Protecting Data
• Creating and Using Macros
• Analyzing Databases

Course Duration: 12 hours

* All Schedules are correct at the injection date, the management reserved the right to change the schedule from time to time without prior notice. Kindly contact your Account Executive and/or Customer Service Executive for more information and queries.

Click here for Programme Enquiry

Informatics Professional Development Centre (IPDC) is an independent entity from Microsoft Corporation and is not affiliated with Microsoft Corporation in any manner. This course is not sponsored by, endorsed by, or affiliated with Microsoft Corporation. Window XP and Microsoft Office are trademarks or registered trademarks of Microsoft Corporation in the United States and certain other countries. All other trademarks are trademarks of their respective owners.