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

Book Description

Experience learning made easy—and quickly teach yourself how to build your own database with Access 2013. With Step by Step, you set the pace—building and practicing the skills you need, just when you them! Includes downloadable practice files and a companion eBook.

  • Build a database from scratch or ready templates

  • Create easy-to-use data-entry forms

  • Write queries to extract and manipulate data

  • Design reports to summarize data in effective ways

  • Import data from other databases and documents

  • Table of Contents

    1. Introduction
      1. Who this book is for
      2. How this book is organized
      3. Download the practice files
      4. Your companion ebook
      5. Get support and give feedback
        1. Errata
        2. We want to hear from you
        3. Stay in touch
    2. I. Simple database techniques
      1. 1. Explore Microsoft Access 2013
        1. Identifying new features of Access 2013
          1. If you are upgrading from Access 2010
          2. If you are upgrading from Access 2007
          3. If you are upgrading from Access 2003
        2. Working in the Access 2013 user interface
          1. Identifying program window elements
          2. Working with the ribbon
        3. Understanding database concepts
        4. Exploring tables
        5. Exploring forms
        6. Exploring queries
        7. Exploring reports
        8. Previewing and printing database objects
        9. 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. Defining relationships between tables
        6. Key points
      3. 3. Create simple forms
        1. Creating forms by using the Form tool
        2. Formatting forms
        3. Arranging the layout 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
    3. II. Relational database techniques
      1. 6. Maintain data integrity
        1. Specifying the type of data
        2. Setting the field size
        3. Restricting the format of data
        4. Validating the data
        5. Allowing only values in lists
        6. Allowing only values in other tables
        7. Key points
      2. 7. Create queries
        1. Creating queries by using a wizard
        2. Creating queries manually
        3. Summarizing data by using queries
        4. Calculating by using queries
        5. Updating records by using queries
        6. Deleting records by using queries
        7. Key points
      3. 8. Create custom forms
        1. Modifying forms created by using a wizard
        2. Adding controls
        3. Displaying subforms
        4. Key points
      4. 9. Create custom reports
        1. Creating reports manually
        2. Modifying report content
        3. Adding subreports
        4. Key points
    4. 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. Designing 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. Work in Access more efficiently
        1. Changing default program options
        2. Customizing the ribbon
        3. Manipulating the Quick Access Toolbar
        4. Key points
    5. A. Glossary
    6. B. Keyboard shortcuts
      1. Access 2013 keyboard shortcuts
        1. Open, save, and print databases
        2. Work in Design, Layout, or Datasheet view
        3. Work in the Navigation pane
        4. Work in the Property Sheet pane
        5. Work in the Field List pane
        6. Edit controls in forms or reports in Design view
        7. Work with combo boxes or list boxes
        8. Set properties for a table in Design view
        9. Work with text and data
          1. Select text in a field
          2. Select a field or record
          3. Extend a selection
          4. Move a column in Datasheet view
          5. Move the cursor in a field
          6. Enter data in Datasheet or Form view
          7. Refresh fields with current data
          8. Find and replace text or data (Datasheet view or Form view)
      2. Navigate records
        1. Navigate in Design view
        2. Navigate in Datasheet view
          1. Navigate between fields and records
          2. Navigate to another screen of data
          3. Navigate in subdatasheets
        3. Navigate in Form view
          1. Navigate between fields and records
          2. Navigate in forms with more than one page
        4. Navigate in Print Preview
        5. Navigate in the Query Designer
          1. Navigate in the top pane
          2. Navigate in the query design grid
          3. Navigate in the SQL pane
      3. Access web app keyboard shortcuts
        1. Customize a web app in Access
        2. Work with a web app in a web browser
      4. Office 2013 keyboard shortcuts
        1. Work with menus
        2. Use Open and Save As in the Backstage view
        3. Use the Open and Save As dialog boxes
        4. Display and use windows
        5. Navigate on the ribbon
        6. Move around in text or cells
        7. Work with text
        8. Move around in and work in tables
        9. Work with panes
        10. Work with wizards
        11. Work with dialog boxes
        12. Use edit boxes within dialog boxes
        13. Use the Help window
    7. C. About the authors
      1. Joyce Cox
      2. Joan Lambert
      3. The team
      4. Online Training Solutions, Inc. (OTSI)
    8. Index
    9. About the Authors
    10. Copyright