Microsoft Courses > Microsoft Access 2000 Level 1 Training Course
Microsoft Access 2000 Level 1 Course Outline
Course Description
Students will learn the basic skills necessary to begin using Access 2000. They will design and create databases, tables, queries, forms, and reports.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Access 2000: Level 2, the next course in this series, teaches students how to enhance their database designs by using the principles of normalisation and table relationships. Students also learn how to query multiple tables for data that is used in customised forms and reports. Students who want to learn advanced features can take the third course in this series, Access 2000: Advanced. In that course, students learn to create advanced queries, create more efficient forms and reports, and work with macros. The final course in this series, teaches students to create custom applications.
Course pre-requisites:
Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with terms such as computer memory, data files, and program files. Students should also be familiar with the components that make up the PC, including input, output, and storage devices. Students should also be fairly comfortable working in a Windows environment. No prior knowledge of databases or Access is assumed.
Topics covered on the 2 day Microsoft Access 2000 Level 1 course
Lesson 1: Overview of Access 2000
Introduction to database concepts and terminology
An introduction to Access 2000
Database planning and design
Lesson 2: Creating tables
Examining a table
Creating a table with the Table Wizard
Creating a table in Design View
Types of primary keys
Lesson 3: Working with tables
Adding records
Modifying the table design
Finding and editing records
Deleting, adding, and copying records and values
Filtering and sorting records
Lesson 4: Using select queries
Selecting fields and sorting records
Refining the results of a query
Using queries to perform calculations
Joining tables in a query
Lesson 5: Creating and using forms
Creating a form
Modifying the form design
Using a form to locate and organise information
Multiple-table forms
Lesson 6: Creating and using reports
Creating a report
Creating a report that contains totals
Lesson 7: Creating and maintaining a database
Creating a database
Managing a database and its objects
Database maintenance
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Course Fee = £410 (excl.VAT)
Scheduled course dates
| October 2008 |
November 2008 |
December 2008 |
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
Access 2003 Training SAVE IT Scheme
|