PS Training Ltd

Printer-friendly document

Course Booking and enquiries: 01352 810443
enquiries@pstraining.co.uk

Prerequisites:
Attendees should have attended, or have knowledge equivalent to the Introductory Level course.

Duration:
This course can be delivered as a full day course or as individual half day modules

Advanced Queries

• Advanced select queries
• Top value queries
• Group & summary queries
• Conditional logic within queries
• Crosstab, find duplicates and find unmatched queries
• Action queries, i.e. update, delete, append and make table

Macros, Linking and Database Management

• Using macro groups
• Creating conditional macros
• Importing, exporting and linking data with other databases
• Importing & exporting with other packages
• Repair and compact feature
• Creating custom toolbars
• Use of the start-up options