Ziele- Identify advantages of a relational database. - Identify the basics of a relational database. - Sequence the steps for planning a relational database. - Create a table in Datasheet view. - Identify features of the Table Wizard - Create a table in Design view. - Identify features of relationships between tables. - Create a one-to-many relationship between tables. - Sequence the steps to define a many-to-many relationship between two tables.
AnforderungenThe intended audiences for this course are Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, Database Administrators. Access 2002 Fundamentals doesn't require any previous database knowledge. Its audience could include a range of other job types such as Junior Secretarial, Customer Service etc. 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 74050 - Microsoft Access 2002 Fundamentals
InhaltDeployment Options
Self-Study
Total Learning Time
6 to 8 hours
Objectives
Unit 1: Basics of Access 2002
- Identify advantages of a relational database.
- Identify the basics of a relational database.
- Sequence the steps for planning a relational database.
- Open a database by using Microsoft Access.
- Match database objects with their features.
- Identify the functions of each database object view.
- Create a blank database.
- Identify the options available when creating a database by using a database template.
- Get help by using the Office Assistant.
- Identify features of the Help Window.
Unit 2: Table Creation and Modification
- Create a table in Datasheet view.
- Identify features of the Table Wizard.
- Create a table in Design view.
- Create a field for a table in Design view.
- Move a field in a table in Datasheet view.
- Modify a field property in a table in Design view.
- Create an input mask in a table field.
- Delete a field from a table in Design view.
- Set a field as a primary key in Design view.
- Set an index for a field in a table.
- Match optimum field data types with their features.
- Customize an input mask for a field in a table in Design view.
- Identify features of the Lookup Wizard.
- Identify the functions of Lookup field properties.
- Enter data into a table in Datasheet view.
- Edit data in a table in Datasheet view.
- Delete data from a table in Datasheet view.
- Add a hyperlink to a table in Datasheet view.
- Sort table data by a single field.
- Copy data into fields from other Office applications by using Office Clipboard.
- Match the record navigation controls with their functions.
- Locate a record in a datasheet by using the Find command.
- Filter by selecting a value in Datasheet view.
- Filter by excluding a selected value in Datasheet view.
- Filter by form in Datasheet view.
- Filter for input by entering specific criteria in a Filter For box.
- Filter a record by using the Advanced Filter/Sort window.
- Resize a column in Datasheet view.
- Format a datasheet.
Unit 3: Table Relationships and Data Integrity
- Identify features of relationships between tables.
- Create a one-to-many relationship between tables.
- Sequence the steps to define a many-to-many relationship between two tables.
- Print a relationship report of a database.
- Identify features of a subdatasheet.
- Validate data integrity in a table.
- Identify features of the Required property used to ensure data integrity.
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