By the end of the course you will be able to :

• Create switchboard forms
• Create Macros to help automate tasks
• Manage the database

PivotTables and Pivot Charts

• Create a PivotTable
• Modify a PivotTable
• Working with a PivotChart

Creating Advanced Forms

• Designing a form based on joined tables
• Automating data entry
• Grouped control
• How to improve the user interface
• Command buttons
• Setting form properties
• Modal and Pop up forms
• Designing subforms
• Creating a Switchboard

Macros

• Create and run macros
• Attach macros to events of database objects
• Assigning macros to the switchboard
• Creating conditional Macros
• Create macros to provide user interaction
• Create macros requiring user decision
• Use AutoKeys and AutoExec macros

Exploring Access SQL

• How to identify different clauses in an SQL statement
• Writing SQL statements Attach an SQL statement to database- objects

Integrating the Internet

• Work with hyperlink fields
• Work with data access pages

Managing Databases

• Work with database utilities to optimise -resources
• Secure data by database replication
• Security Fundamentals
• Protect databases