Kurs 74050 - Microsoft Access 2002 Fundamentals - Online

Informationen über Kurs 74050 - Microsoft Access 2002 Fundamentals - Online

• 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.
• Anforderungen
  The 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).
• Titel
  Kurs 74050 - Microsoft Access 2002 Fundamentals
• Inhalt
  Deployment 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