Sams Teach Yourself Microsoft Access 2000 in 21 Days with Cdrom PDF
Preview Sams Teach Yourself Microsoft Access 2000 in 21 Days with Cdrom
To access the contents, click the chapter and section titles. Sams Teach Yourself Microsoft Access 2000 in 21 Days (Publisher: Macmillan Computer Publishing) Author(s): Paul Cassel ISBN: 0672312921 Publication Date: 05/03/99 Brief Full Advanced Search this book: Search Search Tips Introduction About the Author PART 1—At a Glance Chapter 1—Understanding Relational Database Concepts Data Isn’t Information Changing Data into Information Getting Complex The Key to the Transformation Not Fun, but Necessary The Nature of Access Data The Theory of Database Structure The Practice of Database Structure Choosing the Primary Key Relationship Types Getting to Normalization Access’ Mission Microsoft Extends Access Hardware Requirements Maintaining Access Databases Repairing in Place Summary Q&A Workshop Quiz Chapter 2—From Idea to Project The Access User Interface Navigating the Database View Window Groups Views, Opening, and Closing Objects Just Like Everyday Windows Global Options The Parts of Access Tables Queries Forms Reports Pages Macros Modules Analysis of Your Project Don’t Be a Slave to Convention Don’t Worry Yet Getting Help—The Office Assistant Real Experts Shun Help—Ha! The Ways of Help What’s This? Toolbars Using the Database Wizard to Create an Application Summary Q&A Workshop Quiz Exercises Chapter 3—Exploring the Data Foundations—The Table The Nature of a Table Examining a Table Creating Your First Table Table Design Basics Using the Table Design Grid Using the Datasheet View to Make a Table The Table Wizard Analyzing the Wizard’s Table Flat Model Instead of Relational Possible Wrong Field Types Linking Fields—The Heart of the Relationship Shortcut to Data Entry The Outcome of a Relationship The Best Is Yet to Come Not Convinced? Seeing It Yourself Table and Field Properties Indexing and More on Key Fields Sorting and Filtering in Tables Sorting Filtering Finding Data Find Cautions Summary Q&A Workshop Quiz Exercises Chapter 4—Using Queries for Data Retrieval The Query in Access A First Query The Simple Query Wizard Filtering and Sorting in Queries Query Criteria Quick Query Facts Multitable Queries Multitable Queries Without Existing Links Intermediate Criteria Wildcards and Like Summary Q&A Workshop Quiz Exercises Chapter 5—Creating Simple Forms for Data Access The Purpose of Forms in a Database Control and Record Source Properties Creating a First Form Task: Using the Form Wizard Form Design View Task: Using the Form Design View Option Group Form Control Alignment Form Headers and Footers Other Form Format Properties Tab Order Finding, Filtering, and Sorting in Forms Summary Q&A Workshop Quiz Exercises Chapter 6—Generating Basic Reports Reports in Access The AutoReport Wizard Report Wizard Report Preview Details The Report Design View Grouping in Reports The Group Properties Mailing Labels Expression Details Explained Page Layout Settings Sums, Subtotals, and Running Sums Summary Q&A Workshop Quiz Exercises Chapter 7—Automating Your Access App: A Macro Primer Macros and Access And the Point Is? Elements of a Macro The Macro Design Grid A Very Simple Macro Deleting Macro Actions Macros and Events Commonly Used Macro Actions Further Actions Conditional Macros Summary Q&A Workshop Quiz Exercises PART 1—In Review PART 2—At a Glance Chapter 8—Data Access Pages Access and the Web The Problem and the Problem Solved Data Access Page Creation The Need for Data Access Pages The Design of Data Access Pages Applied Data Access Pages Summary Q&A Workshop Quiz Exercise Chapter 9—Refining Your Tables Tables and Data Integrity The Rule Data Validation in Tables Data Lookup in Tables Input Masks Using OLE Objects and Hyperlinks in Tables Inserting OLE Objects Hyperlinks The Hyperlink Edit Catch-22 Free-Floating Hyperlinks Saving Tables as HTML Summary The Millennium Bug Q&A Workshop Quiz Exercises Chapter 10—Designing Customized Forms Making Attractive Forms Using Colors in Forms Altering Object Color Form Object Pictures Command Buttons 3D Effects and Object Order Formats and System Tools Adding Artwork Summary Q&A Workshop Quiz Exercises Chapter 11—Sorting Data with Queries and Joins General Math in Queries Date and Time Math in Queries Out of Order Sorting Joins Self-Join Inner to Theta Joins Using Ranges in Queries Summary Q&A Workshop Quiz Exercises Chapter 12—Developing Reports with Graphics and Expressions Examining Complex Reports Exploring the Report Property Sheet Examining the Properties Box Tips for Adjusting Width Changing the Text Box’s Border Examining the Data Properties Introducing the Event and Other Properties Adding Images to Reports Adding a Repeating Image Using the Image Control Adding Images from a Table Adding a Chart Modifying the Properties Modifying the Chart Using Expressions in Reports Creating an Expression Using the Expression Builder Concatenating Fields with an Expression Evaluating Data with an Expression The Syntax for IIF Working with Subreports Creating a Subreport Creating the Main Report Integrating the Subreport Creating Reports with Multiple Columns Summary Q&A Workshop Quiz Exercises Chapter 13—Introducing VBA Understanding VBA Exploring Uses for VBA Introducing the Control Wizards Examining the Structure of VBA Understanding Modules Understanding Procedures Exploring the Visual Basic Editor Viewing Your Code Examining the Project Explorer Window The Code Window Examining the Properties Window Examining the Locals Window Examining the Watches Window and the Immediate Window Introducing Language Elements Examining the Control Wizard’s Results Understanding Declarations and Options Using Procedures Understanding Scope Understanding Error Handling Using Variables Declaring Variables Visual Basic Data Types Using Constants Understanding Methods Using Objects Getting Help Summary Q&A Workshop Quiz Exercises Chapter 14—Understanding SQL What Is SQL? Understanding the Structure and Syntax of SQL Exploring the Simple SELECT Statement Examining SELECT Examining FROM Examining Joins Examining IN Examining GROUP BY Examining HAVING Examining WHERE Examining ORDER BY Examining WITH OWNERACCESS OPTION Using the WHERE Clause Entering SQL Working with the Different Field Types Working with Operators Using a Comparison Operator Combining Expressions Using Logical Operators Using Between Using a Wildcard Working with Missing Data Understanding the Restrictions Summary Q&A Workshop Quiz Exercises PART 2—In Review PART 3—At a Glance Chapter 15—Examining Special-Use Queries Understanding Action Queries Using Update Queries Setting Up an Update Query Running an Update Query Using a Built-In Function with an Update Query Task: Changing the Case in a Field Examining the Update Query SQL Statement Using Append Queries Creating an Append Query Running an Append Query Examining the Append Query SQL Statement Using Delete Queries Creating a Delete Query Running a Delete Query Examining the Delete Query SQL Statement Using Make Table Queries Creating a Make Table Query Running a Make Table Query Examining the Make Table SQL Statement Using Crosstab Queries Using the Crosstab Query Wizard Examining the Crosstab Query SQL Statement Refining a Crosstab Query
Description:The list of books you might like
