Microsoft access
Learn how to manipulate data and create reports on Microsoft 2007 and 2010.
Attend this exciting workshop and discover how Microsoft Access can make anything you do with databases child's play; and uncover the many practical features of Access that can be incorporated into your everyday work enviroment. Access data files more simply than ever before.
With emphasis on the creation of queries and reports, you will learn everything you need to know to manipulate records - in fact everything you need to know to master the uses of Microsoft Access.
What will be Covered on this Two-Day Workshop:
Understand RDBMS
Tour Access
Access Forms
Add and Delete Records
Sort Records
Display Record sets
Update Records
Run a Report
Table Relationships
Primary and Foreign keys
Subdata sheets
Create select queries
Add criteria to queries - comparison and conditional operators
Calculated fields
Record Grouping and Calculations
AutoForm
Form Wizards
Modify the design of forms
Auto reports
Reports wizard
Calculated fields
Auto Format Report Width
Plan a database
Normalization
Database templates and wizards
Table wizard
Table relationships (one-one and one-many)
Field properties
Input masks
Input masks
Table filters
Query joins (inner and outer joins)
Calculated fields
Unrelated tables
Self join
Time: 09:00 - 16:15
Venue: Benvenuto Conference Centre in Randburg, Johannesburg
Cost: R4 700.00 excl VAT
More info:
Benvenuto Conference Centre in Randburg
Date: 21 November 2012 to 22 November 2012
Time: 09:00 - 16:15
Venue: Benvenuto Conference Centre in Randburg, Johannesburg
Cost: R4 700.00 excl VAT
More info:
Benvenuto Conference Centre in Randburg