Microsoft Office 2000 - Advanced Access Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
To provide an introduction to the core concepts of Microsoft Access 2000 and the skill areas of modifying and enhancing a table, a form, working with Access tools, and integrating Access with the Web
Target Audience
End-users seeking to become familiar with Microsoft Access 2000; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2000 at Core level
Prerequisites
Some knowledge of basic word processing and computing; familiarity with a Microsoft Windows environment
Expected Duration (hours)
4.9
Lesson Objectives Microsoft Office 2000 - Advanced Access
define and generate relationships between tables.
use a junction table to create a many-to-many relationship between two tables.
create a validation rule and its associated error message.
create a validation rule and associated validation text.
list the standard data types provided by Access and select appropriate data types to customize a field.
create a form and specify its control, section, and image properties.
customize headers and footers, control properties, and format properties in a form.
create a form in Design view, specify form header visibility, and insert a date text box in the form footer.
define a subform, add a subform to a form, and link forms.
use the Subform Wizard to specify the content of a subform and link the subform to the main form.
create and edit a switchboard using Switchboard Manager.
designate startup options in Access and assign a database password.
open a database and assign it a password.
list the database analysis tools available in Access 2000, assess data optimization, and create a report from a database object.
replicate, encrypt, and decrypt a database.
create and run macros.
create and save a macro.
define, create, and customize a data access page in Access.
create a data access page using the Page Wizard.
define hyperlinks and insert a hyperlink in a table or form.
create a hyperlink field and insert a link to an image.
Course Number: 111354_eng