|
| Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the National Qualifications Framework Act, 2008. |
|
|
|
| All Front Foot Microsoft workshop presenters are Certified Microsoft Application Specialists. |
|
|
| DETAILS |
Date and Venue:
No future dates have been scheduled for this workshop. Please contact us for more information. |
Maps:
Click Here |
Time:
08:30 AM |
Duration:
1 Day |
Cost Per Delegate:
| R2 180.00 |
ex VAT |
| R2 485.00 |
incl VAT |
|
Surcharges:
R50 (incl VAT) per delegate, per day for Strictly Halaal and Kosher Meals |
Group Bookings:
Bookings of 2 or more delegates qualify for a 10% discount. |
Out-of-town Delegates:
If you are flying in from out-of-town in order to attend, we will give you a 15% discount on the cost of the workshop.
Contact us to find out more. |
|
|
|
| IN HOUSE |
This workshop is also available under Front Foot’s in-house menu.
Front Foot is proud to offer you a comprehensive array of customised in-house training solutions that are focused on your unique business needs. For more information in this regard, please contact us. |
|
|
|
| BUILD AND ANALYSE REPORTS SIMPLY |
This course is especially formulated for the user who is not interested in designing and building a database, but needs to query and report on existing databases. The main focus of the course will therefore be querying and building reports based on existing databases.
The course is designed to accommodate both Access 2003 and 2007 users.
Please note: In order to maximise the benefit of this course, delegates are required to already have a good working knowledge of Microsoft Access. Where delegates do not meet this criterion, Front Foot offers comprehensive training on Microsoft Access. |
|
REGISTER NOW
|
|
| WHO SHOULD ATTEND |
 |
Financial Managers |
|
Database Managers |
|
Office Administrators |
|
Personal Assistants |
|
Marketing Managers |
|
Anyone who needs to keep a list – such as of clients, telephone lists, stock items, inventories, catalogue of products – or any other data that needs to be stored and retrieved quickly and efficiently using their own criteria, will find this course extremely interesting. |
|
| ONE DAY WORKSHOP OUTLINE |
| The Database structure |
 |
Database components |
|
Table relationships |
|
Linking to existing databases |
|
Importing from existing databases |
|
| Query Basics |
|
Create a query |
|
Run a query |
|
Use criteria to filter query results |
|
Use calculated fields in queries |
|
Use record grouping |
|
| Query Joins |
|
Explore query joins |
|
Link unrelated tables in a query |
|
Use self joins |
|
| Action Queries |
|
Manipulate query properties |
|
Use parameters in queries |
|
Explore action queries |
|
Building Reports
|
|
Use the Auto report feature |
|
Use the Report Wizard |
|
Change the report data source |
|
Report Formatting |
|
Report pagination |
|
Summarising information in a report |
|
Use calculated fields in a report
|
|
Use sup-reports
|
|
Use mailing labels |
|
Add charts to reports |
|
| MS Office Integration |
|
Import from MS Excel |
|
Export To MS Excel |
|
Export to MS Word |
|
|
| OTHER WORKSHOPS YOU MIGHT ENJOY |
|
|
|
Recommend this workshop on Facebook
