Access 2000 Essentials Advanced
Prentice-Hall (Verlag)
978-1-58076-302-8 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
For courses in Microsoft Office Professional for Windows and Access for Windows.
Essentials courseware is anchored in the practical and professional needs of all types of students. The series has been completely revamped as the result of extensive usability testing conducted by students with multiple levels of computer knowledge.
The Essentials series is conceived as a “learning system” that combines graphics, instructions, experience, reinforcement, and problem solving. It consists of modular lessons that are built around a series of numbered, step-by-step procedures that are clear, concise, and easy to review. Explanatory material is interwoven before each lesson and between the steps.
Additional features, tips, pitfalls, and other related information are provided at exactly the right place. They are easily recognizable elements that stand out from the main flow of the tutorial. Icons are designed to match the Microsoft Office theme.
The end-of-chapter exercises have been carefully graded from the routine Checking Concepts and Terms to tasks in the Discovery Zone that gently prod students into extending what they've learned into areas beyond the explicit scope of the lessons proper.
Project 1: Designing a Complex Database.
Lesson 1: Defining Desired Output. Lesson 2: Organizing the Fields into Several Tables. Lesson 3: Relating Tables Using One-to-One and One-to-Many Relationships. Lesson 4: Relating Two Tables Using a Third Table. Lesson 5: Refining the Design to Eliminate Redundant Fields. Lesson 6: Creating Queries and Testing the Design. Lesson 7: Documenting the Design.
Project 2: Making the Input Form User Friendly.
Lesson 1: Changing the Color of Text, Backgrounds, and Borders Using Buttons. Lesson 2: Using the Format Painter to Copy Formats Between Controls. Lesson 3: Formatting More Than One Control at a Time. Lesson 4: Changing Colors Using Properties. Lesson 5: Adding Status Bar Instructions in Form View. Lesson 6: Adding Customized ControlTips to Controls. Lesson 7: Creating a Custom Toolbar.
Project 3: Managing Changing Data.
Lesson 1: Replacing Data in a Table Using an Update Query. Lesson 2: Replacing Portions of Fields Using an Update Query. Lesson 3: Updating Tables Using a Calculated Expression. Lesson 4: Updating a Table Based on Values in Another Table. Lesson 5: Updating Linked Tables Automatically.
Project 4: Using Access Tools.
Lesson 1: Correcting Spelling with the Spell Checker. Lesson 2: Customizing Data Entry using AutoCorrect. Lesson 3: Analyzing a Table. Lesson 4: Analyzing Database Performance. Lesson 5: Using the Database Documenter. Lesson 6: Using OfficeLinks with Word and Excel.
Project 5: Analyzing and Reporting Data.
Lesson 1: Correcting Spelling with the Spelling Checker. Lesson 2: Customizing Data Entry Using AutoCorrect. Lesson 3: Analyzing a Table. Lesson 4: Analyzing Database Performance. Lesson 5: Updating the Database Using Name AutoCorrect. Lesson 6: Using Office Links to Analyze Data with Excel.
Project 6: Filtering Data in a Linked Table Using Parameters and Form Filters.
Lesson 1: Linking to a Large Table in Another Database. Lesson 2: Selecting Records Using Filter by Selection. Lesson 3: Selecting Records Using Filter by Form. Lesson 4: Using Parameters as Matching Criteria in a Query. Lesson 5: Using Parameters with Comparison Operators in a Query. Lesson 6: Using Parameters with Wildcards as Criteria in a Query.
Project 7: Sharing a Database with Others.
Lesson 1: Assigning a Password to Your Database. Lesson 2: Changing or Removing a Database Password. Lesson 3: Encrypting a Database. Lesson 4: Creating a Switchboard. Lesson 5: Setting Startup Parameters. Lesson 6: Setting Access Defaults.
Task Guide.
Glossary.
Index.
| Erscheint lt. Verlag | 10.12.1999 |
|---|---|
| Verlagsort | Harlow |
| Sprache | englisch |
| Maße | 219 x 275 mm |
| Gewicht | 538 g |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Informatik ► Office Programme ► Access | |
| ISBN-10 | 1-58076-302-2 / 1580763022 |
| ISBN-13 | 978-1-58076-302-8 / 9781580763028 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
