- Price: $170.50
Access 2003 - Using a Database will provide new users with the skills to use an existing database. Upon completion of this course you will be able to open and close Access, Identify parts of the Access screen, identify parts of a Database, add and modify records, use shortcuts to move around a table, delete records, create basic queries, create basic reports and print reports.
What is a Virtual Online Classroom?
The Virtual online classroom is a new innovative classroom available with just a simple Internet connection.
You will learn at the comfort of your desk with the experience and value of interacting with others.
The virtual classroom is a real-time, web-based classroom environment for distant learning. The live classroom adds live discussion and dynamic interaction to your training.
It engages students, promotes active learning and improves performance. The live classroom eliminates expensive, inconvenient travel and teleconferencing - while maintaining the effectiveness of face-to-face meeting and training.
Training is conducted by professional trainers, using hands on exercises and user practise to consolidate concepts.
Windows Getting Started course or equivalent. Participants must have good mouse skills.
- What is a database?
- What is a Relationship Database?
- Starting Access
- Exiting Access
- Database Window
- Closing a Database
- Database container (tables, queries, forms, reports, macros and modules)
Analysing an Existing Database
- Discovering the structure
- Relationships (an overview)
- The Relationship Window
- Commonly used Database terminology
- Adding records
- Adjusting Column width
- Moving around tables
- Editing records
- Deleting records
- Showing and hiding columns
- Finding records
- Filtering by selection
- Automatic saving
Creating Basic Queries
Creating Basic Reports