Ziele- Create an update query. - Create a delete query. - Create an append query. - Create a form in Design view. - Modify section properties in a form. - Create a subform with the Form Wizard. - Create a report in Design view. - Modify section properties of a report. - Add a chart to a report. - Modify a database by using the Compact and Repair tool. - Convert a database from a previous version to Access 2002 format. - Distribute a database as an MDE file.
AnforderungenThe intended audience for this course would include Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, and Database Administrators. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s).
TitelKurs 74052 - Microsoft Access 2002 Expert User
InhaltCourse Description
This course covers the more complex aspects of working with data using Access 2002. Assuming the learner is already proficient in Access, the course covers advanced features of database queries, and enhancing forms and reports.
Deployment Options
Self-Study
Total Learning Time
6 to 8 hours
Objectives
Unit 1: Advanced Queries
- Create an update query.
- Create a delete query.
- Create an append query.
- Create a make-table query.
- Create a parameter query.
- Create a crosstab query.
- Create a union query.
- Filter records with a query by using the OR criteria condition.
- Filter records with a query by using the AND criteria condition.
- Create a criterion query by using a form control.
- Change a join type in a query.
Unit 2: Forms Enhancements
- Create a form in Design view.
- Modify section properties in a form.
- Create a subform with the Form Wizard.
- Add a subform to an existing form.
- Create a switchboard form by using the Add-In tool.
- Identify database startup options for Microsoft Access 2002.
Unit 3: Report / Data Access Pages Enhancements
- Create a report in Design view.
- Modify section properties of a report.
- Add a chart to a report.
- Add a subreport to an existing report.
- Set sorting properties for a report.
- Set group properties for a report.
- Create a print preview command button.
- Create an option group for a report.
- Identify the syntax used when designing a report preview module.
- Create a data access page in Design view.
- Create a PivotTable on a data access page.
- Create a PivotChart on a data access page.
- Create a hyperlink on a data access page.
Unit 4: Access Tools
- Modify a database by using the Compact and Repair tool.
- Convert a database from a previous version to Access 2002 format.
- Distribute a database as an MDE file.
- Replicate a database by using the menu bar.
- Encrypt a database.
- Set a password for a database.
- Grant access permissions to a database.
- Identify the functions of the Database Splitter Wizard.
- Apply a Linked Table Manager to a database.
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
Ähnliche angebote die in bezug zu ihrer anfrage "microsoft" stehen