Office Productivity Using MS Office Access 2007

Workshop Title: Office Productivity Using MS Office Access 2007

Date: July 21-22, 2011 | Time: 9:00 AM - 5:00 PM

Venue: EITSC Training Hub, 19th floor Philippine AXA Life Corporate Centre,       Sen. Gil Puyat Ave. Makati City, Metro Manila

Organizer: European Innovation, Technology & Science Center (EITSC)

Overview:

This course is designed for participants who may have some prior understanding of databases and even for those new to working with Microsoft Access. This hands-on workshop will be concluded with the participants' presentation of their automated MS Access database, with menu driven access to various functionalities of their application.

At the end of this course, each participant will be able to

• Set-up their own database
  
• Create user-friendly data entry forms
  
• Import data from other sources
  
• Export data to other formats (e.g. MS Excel)
  

Course Outline:

1. Understanding relational databases

• What is database?
  
• How are tables in a database related?
  
• Understanding primary keys
  
• Understanding table relationships using data normalization techniques
  

2. Creating your first database

3. Designing the tables in your database

• Understanding field names and properties
  
• Creating data entry validations
  
• Creating look-up fields
  
• Formatting fields
  

4. Inputting data into tables using DataView and user-friendly Form Means

• Understanding  and using DataView and FormView
  
• Customizing user forms
  

5. Extracting data from tables using reports

• Creating reports using report wizard
  
• Creating reports using report design view
  
• Add a calculated field(s) to a report
  
• Modify the format properties of a control
  
• AutoFormat a report
  

6. Updating data in tables using user-friendly Form Means

7. Working with two or more interrelated tables

8. Creating user-friendly multi-table forms (header and details)

9. Generating reports coming from multiple tables

10. Understanding the power of MS Access Query

11. Creating various queries

12. Viewing table relationships

13. Understanding data sheet views of tables with relationship

14. Generating analysis reports

• Using pivot tables
  
• Using pivot charts
  

15. Automating the workflow in access

16. Maintaining the database

17. Revalida

• Actual case study
  

Target Participants:

• Sales and marketing professionals
  
• Database solution makers
  
• IT personnel
  
• People who generate reports
  

Training Investment:

Regular rate: Php 10,450| Early-bird rate: Php 9,405

**To avail of the early bird discount, complete your registration 2-weeks before the training schedule.

Contact Details:

To register or know more about this event, please call us at 845-1324 local 224 or you may also email us at eitschub@globenet.com.ph or joana@eitsc.com.

*Pre-registration is required.

**Training fee is inclusive of snacks, lunch, drinks, seminar kit, handouts and certificate of attendance.

***Schedule may change without prior notice. Please call to confirm seminar schedule.

To know about EITSC and its other course offerings, please log on to www.eitsc.com