Access 2000: Using An Existing Database
Send A Message
Description and objective: This one-day hands-on course will provide delegates with a brief overview into how relational databases are constructed but concentrates more on techniques employed for data entry, the application of existing forms, using and creating queries to interrogate an existing database and to generate effective reports
Skills required prior to the course
To fully benefit from this course, attendees are expected to be familiar with Windows (95/8/2000 or NT4) and use of the keyboard and mouse. Knowledge of a previous relational database package would be useful, although not essential
What you will learn
On completion of the course, delegates will be able to:
· Understand database concepts and the terminology used in Access 2000
· Filter, view, find and edit records
· Sort and filter records using specific criteria
· Be able to create and run queries that can be recalled and repeated
· Create simple forms which link tables to view and query related data
· Generate and print reports
Who should attend
New or inexperienced users of Microsoft Access 2000, those upgrading from a previous version of Access or migration from another relational database package wanting to work with an existing database application
Course size
Maximum 6 delegates
Related courses
Windows 95/8/2000 or NT4 Foundation
Access 2000 Creating Databases
Access 2000 Power User
Duration
One day
Topics
Getting Started
Using Online Help
Working with Tables
Editing Tables
Finding and Filtering Data
Printing Data
Creating Basic Forms
Using Simple Queries
Modifying Query Results
Using Operators in Queries
Designing Advanced Queries
Creating Basic Reports
For further details of topics covered in this outline please refer to our web site at:
www.laidlaw-constable.co.uk
Contact Laidlaw and Constable Ltd
| Phone | 0207 436 4411 When calling be sure to mention Training Pages
| Fax | 020 7436 8533 |
|
Send a Message
Back to Top