You are previewing Sams Teach Yourself Microsoft® Office Access 2003 in 24 Hours.
O'Reilly logo
Sams Teach Yourself Microsoft® Office Access 2003 in 24 Hours

Book Description

In just 24 sessions of one hour or less, the reader picks up all the skills needed to increase the effectiveness and reliability of Access applications. Using a straightforward, step-by-step approach, each lesson builds upon the previous one, allowing the reader to quickly learn the essentials of Access programming from the ground up. The book helps the reader to understand the fundamentals of the Access architecture, gain fast knowledge of the new features that Access offers, learn how to effectively use the latest tools and features of Access by following practical, real-world examples, and get expert tips from the best-selling author, Alison Balter. This book is designed for the way readers learn. They can go through each step-by-step chapter or just choose the lessons that interest them the most.

Table of Contents

  1. Copyright
    1. Dedication
  2. About the Author
  3. Acknowledgments
    1. We Want to Hear from You!
  4. Introduction
    1. Conventions Used in This Book
  5. I. Introduction to Relational Databases and Access 2003
    1. 1. Relational Databases and Office Access 2003 Introduced
      1. What Is a Relational Database?
      2. What Types of Things Can I Do with Microsoft Access?
        1. Access as a Development Platform for Personal Applications
        2. Access as a Development Platform for Small-Business Applications
        3. Access as a Development Platform for Departmental Applications
        4. Access as a Development Platform for Corporationwide Applications
        5. Access as a Front End for Enterprisewide Client/Server Applications
        6. Access as a Development Platform for Intranet/Internet Applications
      3. Starting Microsoft Access
      4. Opening an Existing Database
      5. The Access Desktop
      6. The Database Window
      7. A Preview of the Database Components
        1. Tables: A Repository for Data
        2. Relationships: Tying the Tables Together
        3. Queries: Stored Questions or Actions You Apply to Data
        4. Forms: A Means of Displaying, Modifying, and Adding Data
        5. Reports: Turning Data into Information
        6. Pages: Forms Viewed in a Browser
        7. Macros: A Means of Automating a System
        8. Modules: The Foundation of the Application Development Process
      8. Closing an Access Database
      9. Summary
      10. Q&A
      11. Workshop
        1. Quiz
        2. Activities
  6. II. Working with Existing Databases and Objects
    1. 2. Tables Introduced
      1. Viewing and Navigating Table Data
        1. Opening an Access Table
        2. Navigating Around a Table
        3. Closing a Table
      2. Editing Table Data
        1. Modifying Table Data
        2. Deleting Field Contents
        3. Undoing Changes
          1. Undoing Changes Made to the Current Field
          2. Undoing Changes After You Move to Another Field
          3. Undoing Changes After You Save a Record
      3. Adding Records to a Table
      4. Deleting Records
        1. Selecting One or More Records
        2. Deleting Records
      5. Finding and Replacing Records
        1. Finding a Record That Meets Specific Criteria
        2. Replacing Data in a Table
      6. Filtering Table Data
        1. Filtering by Selection
        2. Removing Filters
      7. Modifying the Appearance of a Datasheet
        1. Changing the Appearance of Text
        2. Changing Column Widths
        3. Changing Row Height
        4. Freezing Columns
        5. Modifying the Appearance of a Datasheet
        6. Hiding and Unhiding Columns
        7. Expanding to Show the Subdatasheet Data
      8. Correcting Errors by Using Spell Check and AutoCorrect
        1. Using the Spell Check Feature
        2. Using AutoCorrect
      9. Summary
      10. Q&A
      11. Workshop
        1. Quiz
        2. Activities
    2. 3. Queries Introduced
      1. What Is a Query and When Should You Use One?
      2. Opening a Query in Datasheet View
      3. Opening a Query in Design View
        1. Viewing the Design of a Query from the Database Window
        2. Viewing the Design of a Query While in Datasheet View
      4. Running a Query
      5. Adding and Removing Fields
        1. Adding a Field Between Other Fields
        2. Adding a Field to the End of the Query Grid
        3. Adding a Group of Contiguous Fields to the Query Grid
        4. Adding a Group of Noncontiguous Fields to the Query Grid
      6. Modifying the Sort Order of a Query
        1. Sorting on a Single Field
        2. Sorting on More Than One Field
        3. Moving a Field on the Query Grid
      7. Working with Simple Criteria
        1. Using an Exact Match Query
        2. Creating Criteria Based on Multiple Conditions
          1. Using the And Condition on Multiple Fields
          2. Using the And Condition in a Single Field
        3. Using Wildcards in a Query
        4. Using Comparison Operators in a Query
        5. Using the Or Condition on a Single Field
        6. Using the Or Condition on Multiple Fields
      8. Modifying the Datasheet View of a Query
      9. Saving a Query
      10. Printing Query Results
      11. Closing a Query
        1. Task: Working with Queries
      12. Summary
      13. Q&A
      14. Workshop
        1. Quiz
        2. Activities
    3. 4. Forms Introduced
      1. Uses for Forms
      2. Opening a Form
      3. Working with Data in a Form
        1. Moving from Record to Record in a Form
        2. Editing the Data Underlying a Form
        3. Deleting Field Contents Within a Form
        4. Undoing Changes Made Within a Form
          1. Undoing Changes Made to the Current Control
          2. Undoing Changes After You Move to Another Control
          3. Undoing Changes After You Save the Record
        5. Using a Form to Add New Records to a Table
        6. Using a Form to Delete Records from a Table
        7. Selecting One or More Records
        8. Deleting Records from Within a Form
        9. Copying Records Within a Form
        10. Finding a Record That Meets Specific Criteria
        11. Replacing Data in the Table Underlying a Form
      4. Sorting Records
      5. Filtering the Data Underlying a Form
        1. Using the Filter by Form Feature
        2. Removing a Filter
        3. Using Multiple Filter Criteria
      6. Viewing the Design of a Form
      7. Closing a Form
      8. Using the AutoForm Feature
        1. Creating a Form by Using the AutoForm Feature
        2. Saving a Form
      9. Using the Form Wizard to Build a Form
      10. Using the Conditional Formatting Feature of a Form
        1. Task: Creating, Filtering, and Saving Forms
      11. Summary
      12. Q&A
      13. Workshop
        1. Quiz
        2. Activities
    4. 5. Reports Introduced
      1. Opening and Viewing a Report
        1. Moving from Page to Page
        2. Zooming In and Out
        3. Viewing Multiple Pages
      2. Printing a Report
        1. Sending Reports to a Printer
      3. The AutoReport Feature and the Report Wizard
        1. Using the AutoReport Feature
        2. Creating a Report by Using the Report Wizard
      4. Viewing the Design of a Report
      5. Closing a Report
      6. Printing Database Objects
        1. Printing Table Datasheets
        2. Printing Queries
        3. Printing Forms
          1. Task: Working with Reports
          2. Task: Printing Database Objects
      7. Summary
      8. Q&A
      9. Workshop
        1. Quiz
        2. Activities
  7. III. Creating Your Own Database and Objects
    1. 6. Using Wizards to Create a Database
      1. Using a Database Template to Create a Database
      2. Creating a Database from Scratch
      3. Building a Table by Using a Wizard
      4. Building a Query by Using a Wizard
      5. Building a Form by Using a Wizard
      6. Building a Report by Using a Wizard
      7. Summary
      8. Q&A
      9. Workshop
        1. Quiz
        2. Activities
    2. 7. Designing Databases
      1. Task Analysis
      2. Data Analysis and Design
        1. Database Terms Introduced
        2. Normalization Introduced
      3. Prototyping
      4. Testing
      5. Implementation
      6. Maintenance
      7. Summary
      8. Q&A
      9. Workshop
        1. Quiz
        2. Activities
    3. 8. Creating Tables
      1. Building a New Table
        1. Building a Table from a Datasheet
        2. Designing a Table from Scratch
      2. Selecting the Appropriate Field Type for Data
        1. Text Fields: The Most Common Field Type
        2. Memo Fields: For Long Notes and Comments
        3. Number Fields: For When You Need to Calculate
        4. Date/Time Fields: For Tracking When Things Happened
        5. Currency Fields: For Storing Money
        6. AutoNumber Fields: For Unique Record Identifiers
        7. Yes/No Fields: For When One of Two Answers Is Correct
        8. OLE Object Fields: For Storing Just About Anything
        9. Hyperlink Fields: For Linking to the Internet
      3. The All-Important Primary Key
      4. Summary
      5. Q&A
      6. Workshop
        1. Quiz
        2. Activities
    4. 9. Creating Relationships
      1. Introduction to Relational Database Design
        1. The History of Relational Database Design
        2. Goals of Relational Database Design
        3. Rules of Relational Database Design
          1. The Rules of Tables
          2. The Rules of Uniqueness and Keys
          3. The Rules of Foreign Keys and Domains
        4. Normalization and Normal Forms
          1. First Normal Form
          2. Second Normal Form
          3. Third Normal Form
        5. Denormalization: Purposely Violating the Rules
        6. Integrity Rules
          1. Overall Integrity Rules
          2. Database-Specific Integrity Rules
        7. The Types of Relationships
          1. One-to-Many Relationships
          2. One-to-One Relationships
          3. Many-to-Many Relationships
      2. Establishing Relationships in Access
        1. Establishing a Relationship Between Two Tables
        2. Following Guidelines for Establishing Relationships
        3. Modifying an Existing Relationship
          1. Task: Establishing Relationships
      3. Establishing Referential Integrity
        1. The Cascade Update Related Fields Option
        2. The Cascade Delete Related Records Option
          1. Task: Working with Referential Integrity
          2. Task: Working with Cascade Update Related Fields and Cascade Delete Related Records
      4. The Benefits of Relationships
      5. Summary
      6. Q&A
      7. Workshop
        1. Quiz
        2. Activities
    5. 10. Creating Queries
      1. Query Basics
        1. Adding Tables to Queries
        2. Adding Fields to Queries
        3. Removing a Field from the Query Design Grid
        4. Inserting a Field After a Query Is Built
        5. Moving a Field to a Different Location on the Query Design Grid
        6. Saving and Naming Queries
          1. Task: Creating a Simple Query
      2. Ordering Query Results
        1. Sorting by More Than One Field
          1. Task: Ordering Query Results
      3. Refining a Query by Using Criteria
        1. Working with Dates in Criteria
          1. Task: Adding Criteria to a Query
      4. Updating Query Results
      5. Building Queries Based on Multiple Tables
        1. Pitfalls of Multitable Queries
        2. AutoLookup in Multitable Queries
          1. Task: Working with Multitable Queries
      6. Creating Calculated Fields
        1. Task: Adding a Calculation to a Query
      7. Getting Help from the Expression Builder
      8. Summary
      9. Q&A
      10. Workshop
        1. Quiz
        2. Activities
    6. 11. Creating Forms
      1. Creating a Form in Design View
      2. Working with the Form Design Window
        1. Understanding and Working with the Form Design Tools
          1. Toggling the Tools to Get What You Want
        2. Adding Fields to a Form
        3. Selecting, Moving, Aligning, and Sizing Form Objects
          1. Selecting Form Objects
          2. Moving Things Around
          3. Aligning Objects to One Another
            1. Snap to Grid
          4. Sizing Controls
          5. Controlling Object Spacing
        4. Modifying Object Tab Order
      3. Selecting the Correct Control for the Job
        1. Labels
        2. Text Boxes
        3. Combo Boxes
        4. List Boxes
        5. Check Boxes
        6. Option and Toggle Buttons
        7. Option Groups
      4. Conditional Formatting
      5. What Form Properties Are Available, and Why Should You Use Them?
        1. Working with the Properties Window
        2. Working with the Important Form Properties
          1. The Format Properties of a Form
            1. Caption
            2. Default View
            3. Allow Form View
            4. Allow Datasheet View
            5. Allow PivotTable View
            6. Allow PivotChart View
            7. Scroll Bars
            8. Record Selectors
            9. Navigation Buttons
            10. Dividing Lines
            11. Auto Resize
            12. Auto Center
            13. Border Style
            14. Control Box
            15. Min Max Buttons
            16. Close Button
            17. Whats This Button
            18. Width
            19. Picture, Picture Type, Picture Size Mode, Picture Alignment, and Picture Tiling
            20. Grid X and Grid Y
            21. Layout for Print
            22. SubdatasheetHeight
            23. SubdatasheetExpanded
            24. Palette Source
            25. Orientation
            26. Moveable
          2. The Data Properties of a Form
            1. Record Source
            2. Filter
            3. Order By
            4. Allow Filters
            5. Allow Edits, Allow Deletions, and Allow Additions
            6. Data Entry
        3. More About Form and Control Properties
      6. Summary
      7. Q&A
      8. Workshop
        1. Quiz
        2. Activities
    7. 12. Creating Reports
      1. Types of Reports
        1. Detail Reports
        2. Summary Reports
        3. Reports Containing Graphics and Charts
        4. Reports Containing Forms
        5. Reports Containing Labels
      2. The Anatomy of a Report
      3. Creating a Report in Design View
      4. Working with the Report Design Window
        1. Understanding the Report Design Tools
        2. Adding Fields to a Report
        3. Selecting, Moving, Aligning, and Sizing Report Objects
          1. Selecting Report Objects
          2. Moving Report Objects
          3. Aligning Objects with One Another
          4. Using Snap to Grid
          5. Using Power-Sizing Techniques
          6. Controlling Object Spacing
      5. Selecting the Correct Control for the Job
        1. Labels
        2. Text Boxes
        3. Lines
        4. Rectangles
        5. Bound Object Frames
        6. Unbound Object Frames
        7. Image Controls
        8. Other Controls
      6. Report Properties and Why to Use Them
        1. Working with the Properties Window
        2. The Format Properties of a Report
          1. Caption
          2. Auto Resize
          3. Auto Center
          4. Page Header and Page Footer
          5. Grp Keep Together
          6. Border Style
          7. Control Box
          8. Min Max Buttons
          9. Close Button
          10. Width
          11. Picture, Picture Type, Picture Size Mode, Picture Alignment, Picture Tiling, and Picture Pages
          12. Grid X and Grid Y
          13. Layout for Print
          14. Palette Source
          15. Orientation
          16. Moveable
        3. The Report's Data Properties
          1. Record Source
          2. Filter
          3. Filter On
          4. Order By
          5. Order By On
      7. Summary
      8. Q&A
      9. Workshop
        1. Quiz
        2. Activities
    8. 13. Creating Macros
      1. The Basics of Creating a Macro
        1. Macro Actions
        2. Action Arguments
        3. Macro Names
        4. Macro Conditions
      2. Running an Access Macro
        1. Running a Macro from the Macro Design Window
        2. Running a Macro from the Macros Tab
        3. Triggering a Macro from a Form or Report Event
          1. Task: Creating a Macro
      3. Modifying an Existing Macro
        1. Inserting New Macro Actions
        2. Deleting Macro Actions
        3. Moving Macro Actions
        4. Copying Macro Actions
      4. Documenting a Macro: Adding Comments
      5. Testing a Macro
        1. Task: Stepping Through a Macro
      6. When You Should Use Macros and When You Shouldn't
      7. Converting a Macro to VBA Code
      8. Creating an AutoExec Macro
      9. Creating an AutoKeys Macro
        1. Task: Creating an AutoExec Macro
      10. Summary
      11. Q&A
      12. Workshop
        1. Quiz
        2. Activities
  8. IV. Power Access Techniques
    1. 14. Power Table Techniques
      1. Working with Field Properties
        1. The Field Size Property: Limiting What the User Enters into a Field
          1. Task: Working with the Field Size Property
        2. The Format Property: Determining How Access Displays Data
          1. Task: Working with the Format Property
        3. The Caption Property: Providing Alternatives to the Field Name
        4. The Default Value Property: Saving Data-Entry Time
          1. Task: Working with the Default Value Property
        5. The Validation Rule and Validation Text Properties: Controlling What the User Enters in a Field
          1. Task: Working with the Validation Rule Property
        6. The Required Property: Making the User Enter a Value
          1. Task: Working with the Required Property
        7. The Allow Zero Length Property: Accommodating for Situations with Nonexistent Data
          1. Task: Working with the Allow Zero Length Property
        8. The Input Mask Property: Determining What Data Goes into a Field
          1. Task: Working with the Input Mask Property
        9. The Lookup Wizard
      2. Working with Table Properties
      3. Using Indexes to Improve Performance
        1. Task: Combining Your Skills
      4. Summary
      5. Q&A
      6. Workshop
        1. Quiz
        2. Activities
    2. 15. Power Query Techniques
      1. Adding Calculated Fields to Select Queries
        1. Task: Creating a Calculation Field
        2. Getting Help from the Expression Builder
      2. Applying Advanced Filters
      3. Creating and Running Parameter Queries
        1. Task: Building a Parameter Query
        2. Task: Building a Parameter Query That Groups by Client
      4. Creating and Running Action Queries
        1. Creating and Running Update Queries
        2. Creating and Running Delete Queries
        3. Creating and Running Append Queries
        4. Creating and Running Make Table Queries
      5. Using Aggregate Functions to Summarize Numeric Data
        1. Task: Building a Query to Summarize and Total Data
      6. Working with Outer Joins
      7. Refining Queries with Field, Field List, and Query Properties
        1. Field Properties: Changing the Behavior of a Field
        2. Field List Properties: Changing the Properties of the Field List
        3. Query Properties: Changing the Behavior of the Overall Query
          1. The Top Values Property
          2. The Unique Values Property
          3. The Unique Records Property
      8. Summary
      9. Q&A
      10. Workshop
        1. Quiz
        2. Activities
    3. 16. Power Form Techniques
      1. The Other Properties of a Form
        1. Pop Up
        2. Modal
        3. Cycle
        4. Menu Bar
        5. Toolbar
        6. Shortcut Menu and Shortcut Menu Bar
        7. Fast Laser Printing
        8. Help File and Help Context ID
        9. Tag
        10. Has Module
        11. Allow Design Changes
      2. Control Properties and Why to Use Them
        1. The Format Properties of a Control
          1. Format
          2. Decimal Places
          3. Caption
          4. Hyperlink Address
          5. Hyperlink SubAddress
          6. Visible
          7. Display When
          8. Scroll Bars
          9. Can Grow and Can Shrink
          10. Left, Top, Width, and Height
          11. Back Style and Back Color
          12. Special Effect
          13. Border Style, Border Color, and Border Width
          14. Fore Color, Font Name, Font Size, Font Weight, Font Italic, and Font Underline
          15. Text Align
          16. Reading Order
          17. Keyboard Language
          18. Scroll Bar Align
          19. Numerical Shape
          20. Left Margin, Top Margin, Right Margin, and Bottom Margin
          21. Line Spacing
          22. Is Hyperlink
        2. The Data Properties of a Control
          1. Control Source
          2. Input Mask
          3. Default Value
          4. Validation Rule and Validation Text
          5. Enabled
          6. Locked
          7. Filter Lookup
        3. The Other Properties of a Control
          1. Name
          2. IME Hold, IME Mode, and IME Sentence Mode
          3. Status Bar Text
          4. Enter Key Behavior
          5. Allow AutoCorrect
          6. Vertical
          7. Auto Tab
          8. Default
          9. Cancel
          10. Auto Repeat
          11. Status Bar Text
          12. Tab Stop
          13. Tab Index
          14. Shortcut Menu Bar
          15. ControlTip Text
          16. Help Context ID
          17. Tag
      3. Bound, Unbound, and Calculated Controls
      4. Using Expressions to Enhance Forms
      5. The Command Button Wizard: Programming Without Typing
      6. Building Forms Based on More Than One Table
        1. Creating One-to-Many Forms
          1. Building a One-to-Many Form by Using the Form Wizard
          2. Building a One-to-Many Form by Using the SubForm Wizard
        2. Working with Subforms
      7. Basing Forms on Queries: The Why and How
        1. Embedding SQL Statements Versus Stored Queries
      8. Summary
      9. Q&A
      10. Workshop
        1. Quiz
        2. Activities
    4. 17. Power Report Techniques
      1. Other Properties of a Report
        1. Record Locks
        2. Date Grouping
        3. Pop Up
        4. Modal
        5. Menu Bar
        6. Toolbar
        7. Shortcut Menu Bar
        8. Fast Laser Printing
        9. Help File and Help Context ID
        10. Tag
        11. Has Module
      2. Control Properties and Why to Use Them
        1. The Format Properties of a Control
          1. Format
          2. Caption
          3. Hyperlink Address
          4. Hyperlink SubAddress
          5. Decimal Places
          6. Visible
          7. Hide Duplicates
          8. Can Grow and Can Shrink
          9. Left, Top, Width, and Height
          10. Back Style and Back Color
          11. Special Effect
          12. Border Style, Border Color, and Border Width
          13. Fore Color
          14. Font Color, Font Name, Font Size, Font Weight, Font Italic, and Font Underline
          15. Text Align
          16. Reading Order
          17. Scroll Bar Align
          18. Numeral Shapes
          19. Left Margin, Top Margin, Right Margin, and Bottom Margin
          20. Line Spacing
          21. Is Hyperlink
        2. The Data Properties of a Control
          1. Control Source
          2. Input Mask
          3. Running Sum
        3. The Other Properties of a Control
          1. Name
          2. Vertical
          3. Tag
      3. Inserting Page Breaks
      4. Bound, Unbound, and Calculated Controls
      5. Using Expressions to Enhance Reports
      6. Building Reports Based on More Than One Table
        1. Creating One-to-Many Reports
          1. Building a One-to-Many Report by Using the Report Wizard
          2. Building a Report Based on a One-to-Many Query
          3. Building a One-to-Many Report with the SubReport Wizard
        2. Working with Subreports
          1. Subreport Properties
            1. Source Object
            2. Link Child Fields
            3. Link Master Fields
          2. Modifying Subreports
      7. Working with Sorting and Grouping
        1. Adding Sorting and Grouping to a Report
        2. Sorting and Grouping Properties
          1. Group Header
          2. Group Footer
          3. Group On
          4. Group Interval
          5. Keep Together
        3. Group Header and Footer Properties and Why to Use Them
          1. Force New Page
          2. New Row or Col
          3. Keep Together
          4. Visible
          5. Can Grow and Can Shrink
          6. Repeat Section
      8. Basing Reports on Stored Queries or Embedded SQL Statements
      9. Summary
      10. Q&A
      11. Workshop
        1. Quiz
        2. Activities
  9. V. Advanced Topics
    1. 18. Sharing Data with Other Applications
      1. Importing, Linking, and Opening Files: When and Why
        1. Determining Whether to Import or Link
        2. Looking at Supported File Formats
      2. Exporting to Another Access Database
      3. Exporting to an Excel Spreadsheet
        1. Exporting to an Excel Spreadsheet
        2. Exporting to an Excel Spreadsheet Using Drag and Drop
        3. Exporting to an Excel Spreadsheet by Using OfficeLinks
      4. Exporting to ASCII
      5. Importing from Another Access Database
      6. Importing Spreadsheet Data
      7. Importing ASCII Data
      8. Linking to Tables in Another Access Database
      9. Linking to Another Type of Database
        1. Linking to Excel Spreadsheets
        2. Linking to Other Databases
      10. The Linked Table Manager
        1. Task: Linking Tables from One Database to Another and Exporting Data to Other Databases
      11. Summary
      12. Q&A
      13. Workshop
        1. Quiz
        2. Activities
    2. 19. Access and the Internet
      1. Saving Database Objects as HTML
        1. Saving Table Data as HTML
        2. Saving Query Results as HTML
        3. Saving Forms as HTML
        4. Saving Reports as HTML
      2. Linking to HTML Files
      3. Importing HTML Files
      4. Exporting Data to XML
      5. Importing XML Data into Access
      6. Creating and Modifying Data Access Pages
        1. Creating a Data Access Page by Using the AutoPage Feature
        2. Creating a Data Access Page Using a Wizard
        3. Creating a Data Access Page from Scratch
      7. Saving PivotTables and PivotCharts to Data Access Pages
      8. Summary
      9. Q&A
      10. Workshop
        1. Quiz
        2. Activities
    3. 20. Database Administration
      1. Backing Up a Database
      2. Compacting and Repairing a Database
        1. Using the User Interface to Compact a Database
        2. Using a Shortcut to Compact a Database
        3. Compacting Whenever a Database Closes
      3. Encrypting and Decrypting a Database
      4. Converting a Database to Another Version
        1. Task: Compacting, Repairing, and Converting a Database into Another Version
      5. Creating an MDE File
      6. Using the Database Splitter
      7. Summary
      8. Q&A
      9. Workshop
        1. Quiz
        2. Activities
    4. 21. Database Documentation
      1. Preparing an Application to Be Self-Documenting
        1. Documenting Tables
        2. Documenting Queries
        3. Documenting Forms
        4. Documenting Reports
        5. Documenting Macros
        6. Documenting Modules
        7. Using Database Properties to Document an Overall Database
      2. Using the Documenter
        1. Using the Documenter Options
        2. Producing Documentation in Other Formats
      3. The Object Dependencies Feature
      4. Summary
      5. Q&A
      6. Workshop
        1. Quiz
        2. Activities
    5. 22. Security Introduced
      1. Implementing Share-Level Security: Assigning a Database Password
      2. Establishing User-Level Security
        1. Step 1: Creating a Workgroup
          1. Understanding Workgroups: The System.mdw File
          2. Establishing a Workgroup
          3. Joining a Different Workgroup
        2. Step 2: Changing the Password for the Admin User
        3. Step 3: Creating an Administrative User
        4. Step 4: Making the Administrative User a Member of the Admins Group
        5. Step 5: Exiting Access and Logging On as the System Administrator
        6. Step 6: Removing the Admin User from the Admins Group
        7. Step 7: Assigning a Password to the System Administrator
        8. Step 8: Opening the Database You Want to Secure
        9. Step 9: Running the Security Wizard
        10. Step 10: Creating Users and Groups
          1. Adding Groups
          2. Adding Users
          3. Assigning Users to the Appropriate Groups
        11. Step 11: Assigning Rights to Users and Groups
      3. Summary
      4. Q&A
      5. Workshop
        1. Quiz
        2. Activities
    6. 23. VBA Introduced
      1. VBA Explained
      2. Access Class Modules, Standard Modules, Form Modules, and Report Modules
        1. Where Do You Write VBA Code?
        2. The Anatomy of a Module
          1. Using the Option Explicit Statement
        3. Creating Event Procedures
        4. Creating Functions and Subroutines
          1. Creating a User-Defined Routine in a Code Module
          2. Creating a User-Defined Routine in a Form or Report Class Module
        5. Calling Event and User-Defined Procedures
        6. The Scope and Lifetime of Procedures
          1. Public Procedures
          2. Private Procedures
          3. Scope Precedence
      3. Working with Variables
        1. Declaring Variables
        2. VBA Data Types
        3. Scope and Lifetime of Variables: Exposing Variables as Little as Possible
          1. Local Variables
          2. Static Variables
          3. Private Variables
          4. Public Variables
      4. Adding Comments to Code
      5. Using the Line Continuation Character
      6. Using the VBA Control Structures
        1. If...Then...Else
        2. Immediate If (IIf)
        3. Select Case
        4. Looping
        5. For...Next
        6. With...End With
      7. Passing Parameters and Returning Values
      8. The DoCmd Object: Performing Macro Actions
      9. Working with Built-in Functions
        1. Built-in Functions
          1. The Format Function
          2. The Instr Function
          3. The InStrRev Function
          4. The Left Function
          5. The Right Function
          6. The Mid Function
          7. The UCase Function
          8. The DatePart Function
          9. The DateDiff Function
          10. The DateAdd Function
          11. The Replace Function
          12. The StrRev Function
          13. The MonthName Function
        2. Functions Made Easy with the Object Browser
      10. Summary
      11. Q&A
      12. Workshop
        1. Quiz
        2. Activities
    7. 24. Finishing Touches
      1. Adding Custom Menu Bars, Toolbars, and Shortcut Menus
        1. Designing a Menu Bar, Toolbar, or Shortcut Menu
          1. Associating a Command with a Menu Item
          2. Deleting and Renaming Menus
      2. Creating an Application Switchboard
      3. Setting Startup Options
      4. Summary
      5. Q&A
      6. Workshop
        1. Quiz
        2. Activities