Microsoft Access 2000: Intermediate

About this class

This class is designed to take participants beyond the basics of Introduction. Students will learn how to create and format forms, subforms, and reports. In addition, the course will cover how to manage data, add controls on forms and reports, import and export data, and create switchboards and work in an automated database.

This training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

Users of Access who are skilled at the basics and want to learn develop custom forms and reports to manipulate, control, and present data.

Examination details

This course will prepare you for the following exams and certification tracks shown. Please note that the exam may not be included in the price shown: please contact us to check.

Microsoft® Certification Tracks  »
    Microsoft® Exams  »
       Exam access2000: MOS: Access 2000
       Elective (MOS - Master 2000)  »
          MOS: Access 2000
          MOS: Access 2000
          MOS- Access 2000  »
             Exam access2000: MOS: Access 2000

What prerequisites are required

Delegates should already know how to:

• Define database objects
• Create a database
• Plan and create tables
• Use primary keys
• Create, manage and modify table relationships
• Add records
• Create filters and queries
• Create basic forms and reports

Contents of this class

Delegates will learn how to

• Add and format controls on forms
• Create and use subforms
• Add and format controls on reports
• Create forms, and use forms to enter and manage data
• Manipulate data and make changes in Form view
• Create reports
• Import and export data
• Create switchboards and work in an automated database