Essentials

Access 2002 Level 1 (Color Edition)

Dawn Parrish Wood (Autor)

Buch | Softcover

258 Seiten

2002
Pearson (Verlag)
978-0-13-100901-1 (ISBN)

Infos

The Essentials Series for Microsoft Office XP Color Edition has be rewritten and redesigned to meet the needs of today's classroom. These hands-on tutorials with a project orientation are designed to give students a thorough knowledge of software applications. Extensive end-of-project exercises emphasize hands-on skill development.

Inhalt

PROJECT 1. GETTING STARTED WITH ACCESS.

Lesson 1. Creating a New Database Using the Database Wizard.
Lesson 2. Copying and Renaming a Database File.
Lesson 3. Opening and Closing a Database.
Lesson 4. Opening and Closing a Database Table.
Lesson 5. Learning about the Access Window.
Lesson 6. Getting Help.
Lesson 7. Exiting Access and Windows.
PROJECT 2. CREATING A DATABASE.

Lesson 1. Creating a New Database.
Lesson 2. Creating a New Table Using the Table Design Wizard.
Lesson 3. Adding Fields.
Lesson 4. Editing Fields.
Lesson 5. Moving Fields.
Lesson 6. Deleting Fields.
Lesson 7. Creating a New Primary Key.
PROJECT 3. ENTERING AND EDITING DATA.

Lesson 1. Adding Records.
Lesson 2. Moving Among Records.
Lesson 3. Editing Records.
Lesson 4. Inserting and Deleting Records.
Lesson 5. Adjusting Column Widths and Hiding Columns.
Lesson 6. Finding Records.
Lesson 7. Selecting Records Using Filter by Selection.
Lesson 8. Selecting Records Using Filter by Form.
Lesson 9. Sorting Records.
PROJECT 4. QUERYING YOUR DATABASE.

Lesson 1. Creating a New Query Using the Simple Query Wizard.
Lesson 2. Editing the Query.
Lesson 3. Changing Field Order and Sorting Query.
Lesson 4. Matching Criteria.
Lesson 5. Saving the Query with a New Name and Opening Multiple Queries.
Lesson 6. Creating a Calculated Field.
Lesson 7. Formatting the Results of a Calculated Field.
PROJECT 5. CREATING AND USING FORMS.

Lesson 1. Creating an AutoForm.
Lesson 2. Entering and Editing Data Using a Form.
Lesson 3. Saving, Closing, and Opening a Form.
Lesson 4. Creating a New Form Using the Form Wizard.
Lesson 5. Adding Fields to Forms.
Lesson 6. Moving and Resizing Fields in Forms.
Lesson 7. Adding a Form Header and Label.
PROJECT 6. CREATING AND PRINTING REPORTS.

Lesson 1. Printing the Table Data.
Lesson 2. Creating a Report Using a Report Wizard.
Lesson 3. Printing and Renaming a Report.
Lesson 4. Modifying a Report Design.
Lesson 5. Saving the Report with a New Name.
Lesson 6. Adding Labels to Reports.
PROJECT 7. CUSTOMIZING FIELDS AND TABLES.

Lesson 1. Modifying a Table Design.
Lesson 2. Entering a Default Value.
Lesson 3. Changing a Field Type and Selecting a Format.
Lesson 4. Changing a Field Size.
Lesson 5. Working with More Than One Table.
Lesson 6. Creating Table Relationships.
Lesson 7. Creating a Multiple-Table Query.
PROJECT 8. INTEGRATING ACCESS WITH OTHER SOURCES OF DATA AND THE INTERNET.

Lesson 1. Converting a Database from a Previous Version of Access.
Lesson 2. Linking an Access Table to a Form Letter in Word.
Lesson 3. Merging an Access Table with a Form Letter.
Lesson 4. Importing a Table from Excel.
Lesson 5. Creating a Data Access Page Using the Page Wizard.
Lesson 6. Using a Browser to Interact with the Database.

Produkt-Details

• Erscheint lt. Verlag: 2.7.2002
• Sprache: englisch
• Maße: 216 x 276 mm
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Informatik ► Office Programme ► Access
• ISBN-10: 0-13-100901-X / 013100901X
• ISBN-13: 978-0-13-100901-1 / 9780131009011
• Zustand: Neuware