Access 2000 MOUS MOS
|
Special Package Deal
|
|
Microsoft Access 2000 Proficient and Expert
|
$150.00
|
n72050d
|
|
|
Office 2000 Package (MOUS) - Includes All Office 2000 courses Access, Excel, Powepoint, Frontpage, Outlook and Word training
|
$299.00
|
n72021d
|
|
MOUS Access XP
Microsoft Access 2000 Training CD-ROM MOUS Certification
MS Access 2000 Proficient MOS MOUS Certification
 Our course packs over 25 hours of highly interactive self-paced
instruction through the following 2 titles:
- MS Access 2000 MOUS Certification Proficient
- MS Access 2000 MOUS Certification Expert
The course enables you to prepare for the MOUS: Microsoft Access 2000 MOUS Proficient Exam. Each title in this course is individually certified by Microsoft for depth and breadth of subject
matter coverage for the Microsoft certification exam.
MS Access 2000 Proficient teaches you to create a database and add tables and records to the database. You will also learn to retrieve data from a database using filters.
MS Access 2000 Expert User teaches you to create queries, forms and reports. You will also look at integrating data with other applications and exporting database objects to the Web.
Duration: 12-16 hours
Audience: This course is targeted at learners who plan to clear the Microsoft Access 2000 MOUS Core exam.
Benefits: After completing all the courses in the curriculum, the learner will be able to:
- Create a database using the Design view and the Database Wizard
- Create a table using the Datasheet view and the Table Wizard
- Add fields to a table and assign datatypes
- Create relationships between tables
- Add records to a table
- Retrieve data from tables using filters
- Create a query using the Simple Query Wizard and the Design view
- Specify multiple criteria in a query
- Create a form using the Autoform wizard and the Form Wizard
- Add controls to the form
- Create a report using the Autoreport wizard and the Report Wizard
- Add controls to a report
- Import, Link and Export data to other applications and the Web
- Backup, Restore and Compact data
Pre-requisites To benefit completely from this title, the learners should be familiar with the Windows interface and Windows terminology
Outline
- MS Office 2000: Access for Professionals - I
- Introducing Access 2000
- Working with Tables
- Retrieving Data
- MS Office 2000: Access for Professionals – II
- Implementing Queries
- Managing Forms
- Presenting Information
- Managing a Database
System Requirements
The minimum system requirements are:
- 80486 DX processor or higher
- 8 MB RAM (more RAM improves performance)
- VGA or higher monitor
- MS-Windows mouse
- 15 MB free disk space
- MS Windows 3.1 or higher
MS Access 2000 Expert MOS MOUS Certification
This course packs over 6 hours of highly interactive self-paced instruction through the following title:
The course enables you to prepare for the MOUS: Microsoft Access 2000 MOUS Expert Exam. Each title in this course is individually certified by Microsoft for depth and breadth of subject matter coverage
for the Microsoft certification exam.
MS Access 2000 Expert teaches you to create a table and update information in the table through queries, generate reports, create data access pages, and define macros. You will also learn to create
forms, to integrate data and implement security.
Duration: 6-8 hours
Audience: This course is targeted at learners who plan to clear the Microsoft Access 2000 MOUS Expert exam.
Benefits: After completing the titles in this course, the learner will be able to:
- Create a table using the Design view
- Add records to a table
- Update the records of a table through Action queries
- Create Select, Parameter, Total and Crosstab queries
- Create a form and add controls
- Create a report using the Autoreport wizard and the Report Wizard
- Add controls to a report
- Import, Link and Export data to other applications and the Web
- Backup, Restore and Compact data
- Generate reports
- Create data access pages
- Create macros and macro groups
- Import, link and export data to other applications
- Replicate a database
- Assign passwords and permissions
Pre-requisites
To benefit completely from this title, the audience should be a proficient user of Access.
The audience can acquire these skills from the VMM course that includes the following titles:
- Microsoft Office 2000: Access for Professionals – I
- Microsoft Office 2000: Access for Professionals - II
Outline
- MS Office 2000: Access for Experts - I
- Working with Tables
- Working with Queries
- Working with Forms
- MS Office 2000: Access for Experts – II
- Generating Reports
- Using Web Capabilities
- Enhancing Applications
- Administering Databases
- Implementing Database Security
System Requirements
The minimum system requirements are:
- 80486 DX processor or higher
- 8 MB RAM (more RAM improves performance)
- VGA or higher monitor
- MS-Windows mouse
- 15 MB free disk space
- MS Windows 3.1 or higher
Testing Information
Tests are administered through
Microsoft
|
