You are previewing Microsoft Access 2013 Plain & Simple.
O'Reilly logo
Microsoft Access 2013 Plain & Simple

Book Description

Learn the simplest ways to get things done with Microsoft Access 2013

Get the full-color, visual guide that makes learning Microsoft Access 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to build a database and sort information.

Here’s WHAT you’ll learn:

  • Build and manage your own database

  • Apply professional designs across your databases

  • Create presentations and publish reports online

  • Secure your database with passwords and encryption

  • Exchange data with other databases and documents

  • Interact with your data easier using macros

  • Here’s HOW you’ll learn it:

  • Jump in wherever you need answers

  • Follow easy STEPS and SCREENSHOTS to see exactly what to do

  • Get handy TIPS for new techniques and shortcuts

  • Use TRY THIS! Exercises to apply what you learn right away

  • Table of Contents

    1. Dedication
    2. 1. About this book
      1. What’s new in Access 2013?
      2. A quick overview
      3. A few assumptions
      4. About the sample database
      5. Adapting task procedures for touchscreens
      6. A final word
    3. 2. Creating a custom Web App
      1. Starting Access
        1. Start Access
      2. Creating a custom Web App
        1. Create a custom Web App
      3. Adding a table template
        1. Add a table template
      4. Showing the navigation pane
        1. Show the navigation pane
      5. Adding a blank table
        1. Add a blank table
      6. Launching a Web App
        1. Launch a Web App
      7. Working with the List view
        1. Work with the List view
      8. Working with the Datasheet view
        1. Work with the Datasheet view
      9. Working with a summary view
        1. Work with a summary view
      10. Finding your site and navigating to the team site
        1. Find a site
      11. Creating a Web App using a template
        1. Create a Web App using a template
    4. 3. Modifying a Web App
      1. Importing from an Access desktop database
        1. Import an Access database
      2. Changing the design of a table
        1. Change the design of a table
      3. Creating a lookup/relationship
        1. Create a lookup
      4. Designing with a List Details view
        1. Create a List Details view
        2. Remove fields
        3. Add fields
      5. Designing with a Datasheet view
        1. Create a Datasheet view
        2. Format a field
      6. Designing with a summary view
        1. Create a summary view
      7. Designing with a blank view
        1. Create a blank view
      8. Open, rename, duplicate, or delete a view
        1. Change a table design when editing a view
      9. Creating a query
        1. Create a query
      10. Modifying the Table Selector
        1. Modify the Table Selector to hide or show a table
        2. Change a table icon
      11. Working with reports
        1. Create a report database
    5. 4. Creating a desktop database
      1. Creating a blank desktop database
        1. Create a blank desktop database
      2. Creating a table in design view
        1. Create a table
      3. Creating a table in layout view
        1. Create a table
        2. Change field captions and descriptions
      4. Working with data parts in layout view
        1. Add a data part
        2. Create a new data part
      5. Creating a table by using application parts
        1. Add an application part
      6. Adding a primary key
        1. Define a primary key in design view
      7. Improving performance by indexing data
        1. Create an index
      8. Validate that data in a field is of the correct type
        1. Make a field required and add an input mask
        2. Add a field validation rule and default
        3. Create a lookup based on values
      9. Comparing field values by using table validation
        1. Create a validation rule
      10. Formatting a field
        1. Format a field
      11. Recording changes to text and rich text formatting
        1. Append Only and Rich Text for Long Text data
      12. Creating relationships by using the Lookup Wizard
        1. Create a lookup
      13. Viewing relationships
        1. View relationships
      14. Deleting relationships
        1. Delete a relationship
      15. Adding relationships
        1. Add a relationship
    6. 5. Working with data in datasheets
      1. Changing Access database options
        1. Change the default database options
      2. Altering the presentation by ordering, hiding, and freezing fields
        1. Order columns
        2. Hide and unhide columns
        3. Freeze and unfreeze columns
      3. Moving between records and using Find And Replace
        1. Move between records
        2. Search through records
      4. Sorting datasheet rows
        1. Apply a sort on a column
        2. Remove a sort
      5. Filtering datasheet rows
        1. Apply a filter on a column
        2. Remove a filter on a column
        3. Filter by column title bar
      6. Filtering combinations of choices with Filter By Form
        1. Apply Filter By Form
        2. Save a filter as a query
      7. Filtering combinations of choices with Advanced Filter/Sort
        1. Apply Advanced Filter/Sort
      8. Inserting and updating records
        1. Edit and then save and undo changes to a saved record
        2. Insert a record
      9. Deleting records
        1. Delete a record
      10. Creating summary data for records
        1. Display totals for a datasheet
      11. Displaying related information with a subdatasheet
        1. Add a query as a subdatasheet to a table
      12. Adjusting column/row height and formatting
        1. Adjust row height
        2. Adjust column width
        3. Adjust row font
        4. Format rows and alternating rows
      13. Selecting data to copy and paste
        1. Select all displayed data
        2. Select a subset of all columns
        3. Select an area of data
      14. Displaying more information with the Zoom box
        1. Display information with a Zoom box
      15. Changing the datasheet presentation
        1. Change the datasheet options
    7. 6. Selecting data using queries
      1. Selecting all columns from a table
        1. Select all columns from a table
      2. Selecting individual columns from one or more tables
        1. Select individual columns
        2. Sort by selected columns
        3. Join multiple tables
      3. Joining tables to see unmatched or missing records
        1. Find unmatched child records
        2. Display all parent records with and without child records
      4. Filtering by single and multiple combinations of choices
        1. Filter to match similar text
        2. Add a second set of criteria
      5. Adding calculations with the expression builder
        1. Create an expression with the expression builder
      6. Returning the top matched records
        1. Return the top matched records
      7. Eliminating duplicate values
        1. Eliminate duplicate rows
      8. Creating a summary calculation
        1. Add a summary
      9. Prompting to filter data with parameters
        1. Prompt with query parameters
      10. Creating a crosstab query with the Query Wizard
        1. Create a crosstab query
      11. Simplifying a problem with a query by using other queries
        1. Create a query to combine data from a table and query
      12. Adding two sets of query results together
        1. Add two result sets together
      13. Resolving ambiguous outer joins
      14. Creating an additional query to resolve a problem with mixed joins
        1. Resolve join ambiguity
    8. 7. Modifying data using queries
      1. Creating a table by using a Make Table query
        1. Create a table by using a Make Table query
      2. Changing data in a table with an Update query
        1. Change data based on explicit values
        2. Change data based on data in another table
      3. Adding data to an existing table with an Append query
        1. Add data to an existing table
      4. Deleting data in tables with a Delete query
        1. Delete data in a table
      5. Updating a column based on an expression
        1. Update a column based on an expression
      6. Adding only new data that is not already in a table
        1. Add only new data
      7. Resetting an AutoNumber with an Append query
        1. Reset an AutoNumber
    9. 8. Improving presentations with forms
      1. Creating a continuous form with the multiple items template
        1. Create a multiple items form
      2. Creating a datasheet form with conditional formatting
        1. Create a datasheet form
      3. Creating a single record form with the Form Wizard
        1. Create a single record form
      4. Creating a split form
        1. Create a single split form
      5. Working with form views
        1. Change the default view
      6. Working with control layouts
        1. Remove a control layout
      7. Creating a parent/child form with the Form Wizard
        1. Create a parent/child form with a subform
      8. Altering link master and link child fields
        1. Alter master and child link fields
      9. Controlling editing and data entry in a form
        1. Change a form to data entry
      10. Changing the data source for a form
        1. Change the record source from a table to SQL
      11. Organizing your database with navigation forms
        1. Create a navigation form
      12. Adding fields to a form in design view
        1. Add a field to a single record form
        2. Add a field to a continuous form
      13. Adding fields to a form in layout view
        1. Add a field to a single record form
        2. Add a field to a continuous form
      14. Adding a subform to an existing form
        1. Add a subform in design view
    10. 9. Using controls effectively
      1. Creating labels and text boxes
        1. Create a label and an unbound text box
      2. Creating lines and rectangles
        1. Create a line and a rectangle
      3. Creating check boxes, option buttons, and toggle buttons
        1. Create an option button and toggle button
      4. Creating option groups
        1. Create an option group
      5. Creating list boxes
        1. Create a list box based on values
      6. Creating combo boxes
        1. Create a combo box based on a table
      7. Creating hyperlinks
        1. Create a hyperlink
      8. Creating logos and titles
        1. Create a logo and title
      9. Creating bound and unbound object frames
        1. Create a bound object frame
        2. Create an unbound object frame
      10. Creating image controls
        1. Create an image with the image control
        2. Create an image with the Image Gallery
      11. Creating attachments
        1. Create an attachment
      12. Creating web browser controls
        1. Create a web browser control
      13. Working with tab controls
        1. Work with a tab control
      14. Creating command buttons
        1. Create a command button
      15. Setting control defaults
        1. Set control defaults
      16. Applying Office themes
        1. Apply an Office theme
    11. 10. Preparing data to print using reports
      1. Creating a tabular report with multiple tables
        1. Create a tabular report
      2. Altering the presentation of controls on a page
        1. Alter the size and position of a control
      3. Working with controls and sections
        1. Move controls between sections
      4. Using the <span xmlns="" xmlns:epub="" xmlns:m="" xmlns:pls="" xmlns:ssml="" xmlns:svg="" class="emphasis"><em>Can Grow</em></span> and and <span xmlns="" xmlns:epub="" xmlns:m="" xmlns:pls="" xmlns:ssml="" xmlns:svg="" class="emphasis"><em>Can Shrink</em></span> Properties Properties
        1. Allow a section and controls to grow and shrink
      5. Adding a running sum
        1. Add a running sum
      6. Managing data and page breaks
        1. Force a new page
        2. Keep results together on the same page
      7. Adding sorting and grouping on reports
        1. Add a sort and group
      8. Avoiding blank pages
        1. Remove a blank page
      9. Adding conditional formatting
        1. Add conditional formatting
      10. Creating a single record report with the Report Wizard
        1. Create a single record report
      11. Creating a parent/child report
        1. Create a parent/child report
      12. Using labels and managing columns and rows
        1. Add a columns presentation
      13. Working with layout view, report view, and Print Preview
        1. Alter a report in layout view
        2. Switch between report view and Print Preview
    12. 11. Exchanging data
      1. Importing data and objects from Access
        1. Import data and objects from an Access database
      2. Linking to data in Access
        1. Link to data in an Access database
      3. Importing data from Excel
        1. Import data from Excel
      4. Linking to data in Excel
        1. Link to data in Excel
      5. Refreshing linked tables when files are changed
        1. Refresh linked tables
      6. Importing data from text files using specifications
        1. Import data from a text file
      7. Exporting data to Excel
        1. Export data to Excel
      8. Working with saved imports and exports
        1. Run an import/export operation
      9. Exporting data as PDF documents
        1. Save data as a PDF document
    13. 12. Introducing the power of macros
      1. Enabling macro commands and disabling Trusted Documents
        1. Disable Trusted Documents
      2. Linking together forms
        1. Create an embedded macro to open a form
      3. Linking a form to a query
        1. Link a form to a table or query
      4. Validating data entered in controls
        1. Validate data entered in a control
      5. Making controls change other controls
        1. Change other controls
      6. Processing data with action queries
        1. Empty and populate a table of data
      7. Executing a saved import/export
        1. Execute a saved import/export
    14. 13. Administrating a database
      1. Compacting and repairing your database
        1. Compact and repair a database
      2. Analyzing your database
        1. Document a database
        2. Analyze performance of a database
        3. Analyze a table
      3. Protecting your data
        1. Protect a database
      4. Viewing object dependencies
        1. View an object’s dependencies
    15. A. About the Author
    16. Index
    17. About the Author
    18. Copyright