You are previewing Microsoft® Access® 2010: Step by Step.
O'Reilly logo
Microsoft® Access® 2010: Step by Step

Book Description

Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office documents; creating data-entry forms; using filters and queries; designing reports; using conditional formatting; preventing data corruption and unauthorized access; and other core topics.

Table of Contents

  1. Microsoft® Access® 2010: Step by Step
  2. A Note Regarding Supplemental Files
  3. Introducing Microsoft Access 2010
    1. New Features
      1. If You Are Upgrading from Access 2007
      2. If You Are Upgrading from Access 2003
    2. Let’s Get Started!
  4. Modifying the Display of the Ribbon
    1. Dynamic Ribbon Elements
    2. Changing the Width of the Ribbon
    3. Adapting Exercise Steps
  5. Features and Conventions of This Book
  6. Using the Practice Files
  7. Getting Help
    1. Getting Help with This Book
    2. Getting Help with Access 2010
    3. More Information
  8. I. Simple Database Techniques
    1. 1. Explore an Access 2010 Database
      1. Working in Access 2010
      2. Understanding Database Concepts
      3. Exploring Tables
      4. Exploring Forms
      5. Exploring Queries
      6. Exploring Reports
      7. Previewing and Printing Access Objects
      8. Key Points
    2. 2. Create Databases and Simple Tables
      1. Creating Databases from Templates
      2. Creating Databases and Tables Manually
      3. Manipulating Table Columns and Rows
      4. Refining Table Structure
      5. Creating Relationships Between Tables
      6. Key Points
    3. 3. Create Simple Forms
      1. Creating Forms by Using the Form Tool
      2. Changing the Look of Forms
      3. Changing the Arrangement of Forms
      4. Key Points
    4. 4. Display Data
      1. Sorting Information in Tables
      2. Filtering Information in Tables
      3. Filtering Information by Using Forms
      4. Locating Information That Matches Multiple Criteria
      5. Key Points
    5. 5. Create Simple Reports
      1. Creating Reports by Using a Wizard
      2. Modifying Report Design
      3. Previewing and Printing Reports
      4. Key Points
  9. II. Relational Database Techniques
    1. 6. Maintain Data Integrity
      1. Restricting the Type of Data
      2. Restricting the Amount of Data
      3. Restricting the Format of Data
      4. Restricting Data by Using Validation Rules
      5. Restricting Data to Values in Lists
      6. Restricting Data to Values in Other Tables
      7. Key Points
    2. 7. Create Custom Forms
      1. Modifying Forms Created by Using a Wizard
      2. Adding Controls
      3. Adding Subforms
      4. Using E-Mail Forms to Collect Data
      5. Key Points
    3. 8. Create Queries
      1. Creating Queries by Using a Wizard
      2. Creating Queries Manually
      3. Using Queries to Summarize Data
      4. Using Queries to Perform Calculations
      5. Using Queries to Update Records
      6. Using Queries to Delete Records
      7. Key Points
    4. 9. Create Custom Reports
      1. Creating Reports Manually
      2. Modifying Report Content
      3. Adding Subreports
      4. Key Points
  10. III. Database Management and Security
    1. 10. Import and Export Data
      1. Importing Information
        1. Importing from Other Access Databases
        2. Importing from Excel Worksheets
        3. Importing from Text Files
        4. Importing from Other Database Programs
        5. Importing from Outlook Folders
        6. Importing from SharePoint Lists
        7. Importing from HTML Files
        8. Importing from XML Files
      2. Exporting Information
        1. Exporting to Other Access Databases
        2. Exporting to Excel Worksheets
        3. Exporting to Word Documents
        4. Exporting to Text Files
        5. Exporting to PDF and XPS Files
        6. Exporting to SharePoint Lists
        7. Exporting to HTML Files
        8. Exporting to XML Files
      3. Copying to and from Other Office Programs
      4. Key Points
    2. 11. Make Databases User Friendly
      1. Creating Navigation Forms
      2. Creating Custom Categories
      3. Controlling Which Features Are Available
      4. Key Points
    3. 12. Protect Databases
      1. Assigning Passwords to Databases
      2. Splitting Databases
      3. Securing Databases for Distribution
      4. Preventing Database Problems
      5. Key Points
    4. 13. Customize Access
      1. Changing Default Program Options
      2. Customizing the Ribbon
      3. Customizing the Quick Access Toolbar
      4. Key Points
  11. Glossary
  12. A. Keyboard Shortcuts
    1. General Shortcut Keys
      1. Work with Global Access Keys
        1. Opening Databases
        2. Printing and Saving
        3. Using a Combo Box or List Box
        4. Finding and Replacing Text or Data (Datasheet View or Form View)
        5. Working in Design View
        6. Editing Controls in Form and Report Design View
        7. Working with Windows
        8. Working with Wizards
        9. Miscellaneous
      2. Work with the Navigation Pane
        1. Editing and Navigating the Object List
        2. Navigating and Opening Objects
      3. Work with Menus
      4. Work in Windows and Dialog Boxes
        1. Using a Program Window
        2. Using a Dialog Box
        3. Editing in a Text Box
      5. Work with Property Sheets
        1. Using a Property Sheet with a Form or Report in Design View
        2. Using a Property Sheet with a Table or Query
        3. Working with the Field List Pane
      6. Work with the Help Window
    2. Keys for Working with Text and Data
      1. Select Text and Data
        1. Selecting Text in a Field
        2. Selecting a Field or Record
        3. Extending a Selection
        4. Selecting and Moving a Column in Datasheet View
      2. Edit Text and Data
        1. Moving the Cursor in a Field
        2. Copying, Moving, or Deleting Text
        3. Undoing Changes
        4. Entering Data in Datasheet or Form View
        5. Refreshing Fields with Current Data
    3. Keys for Navigating Records
      1. Navigate in Design View
      2. Navigate in Datasheet View
        1. Going to a Specific Record
        2. Navigating Between Fields and Records
        3. Navigating to Another Screen of Data
      3. Navigate in Subdatasheets
        1. Going to a Specific Record
        2. Expanding and Collapsing a Subdatasheet
        3. Navigating Between the Datasheet and Subdatasheet
      4. Navigate in Form View
        1. Going to a Specific Record
        2. Navigating Between Fields and Records
        3. Navigating in Forms with More Than One page
        4. Navigating Between the Main Form and Subform
      5. Navigate in Print Preview
        1. Working with Dialog Boxes and Windows
        2. Viewing Different Pages
        3. Navigating in Print Preview
      6. Navigate in the Database Diagram Window
      7. Navigate in the Query Designer
        1. Any Pane
        2. Diagram Pane
        3. Grid Pane
        4. SQL Pane
      8. Work with PivotTable Views
        1. PivotTable View
          1. Selecting Elements
          2. Carrying Out Commands
          3. Keys for Displaying, Hiding, Filtering, or Sorting Data
          4. Adding Fields and Totals and Changing the Layout
            1. Working with the Field List Pane
            2. Adding Fields and Totals
            3. Changing the Layout
          5. Formatting Elements
        2. PivotChart View
          1. Selecting Items in a Chart
          2. Working with Properties and Options
          3. Working with Fields
          4. Working with the Fields List Pane
    4. Keys for Working with the Ribbon
    5. Keys for Working with Online Help
    6. Keys for Basic Office Tasks
      1. Display and Use Windows
      2. Move Around in Text or Cells
      3. Move Around in and Work in Tables
      4. Access and Use Task Panes
      5. Use Dialog Boxes
      6. Use Edit Boxes Within Dialog Boxes
  13. B. About the Authors
    1. Joyce Cox
    2. Joan Lambert
    3. The Team
    4. Online Training Solutions, Inc. (OTSI)
  14. Index
  15. About the Authors
  16. Copyright