You are previewing Access® 2013 on Demand.
O'Reilly logo
Access® 2013 on Demand

Book Description

Need answers quickly? Access 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.

Inside the Book

• Create desktop databases or web apps for traditional and online users to gather, organize, and share data

• Use professional templates to help you create desktop databases or web apps

• Create web apps on SharePoint Team Services to collaborate and share information

• Use tools for building a database or web app that makes information easier to find and use

• Import data from other programs, HTML, XML files, and other databases

• Use forms, filters, queries, and reports to capture and analyze data

• Organize information and add impact with themes, pictures, tables, and charts

• Add hyperlinks and web pages to forms and reports to use content on the Internet

• Use macros and Visual Basic for Applications (VBA) to automate and add functionality to databases

• Prepare for the Microsoft Office Specialist (MOS) exam

Numbered Steps guide you through each task

See Also points you to related information in the book

Did You Know? alerts you to tips and techniques

Illustrations with matching steps

Tasks are presented on one or two pages

Register your book at to gain access to:

• Workshops and related files

• Keyboard shortcuts

Visit the author site:

Table of Contents

  1. About This eBook
  2. Title Page
  3. Copyright Page
  4. Acknowledgments
    1. About the Author
    2. We Want to Hear from You!
  5. Contents
  6. Introduction
    1. How This Book Works
    2. What’s New
    3. Keyboard Shortcuts
    4. Step-by-Step Instructions
    5. Real World Examples
    6. Workshops
    7. Microsoft Office Specialist
    8. Get More on the Web
  7. 1. Getting Started with Access
    1. Introduction
    2. Understanding How Databases Store Data
    3. Starting Access
    4. Using the Ribbon
    5. Choosing Commands
    6. Working with the Ribbon and Toolbars
    7. Choosing Dialog Box Options
    8. Using the Status Bar
    9. Creating a Database
    10. Opening a Database
    11. Converting an Existing Database
    12. Viewing the Access Window
    13. Arranging Windows
    14. Using Task and Window Panes
    15. Getting Help While You Work
    16. Saving a Database
    17. Saving a Database with Different Formats
    18. Working with Accounts
    19. Working with Online Storage
    20. Closing a Database and Exiting Access
  8. 2. Touring Access Databases
    1. Introduction
    2. Opening a Sample Database
    3. Warnings About Macros and Add-Ins
    4. Using a Switchboard
    5. Changing Database Display Options
    6. Viewing Database Objects
    7. Working with Database Objects
    8. Grouping and Hiding Database Objects
    9. Touring a Table
    10. Touring a Form
    11. Entering Data
    12. Touring a Query
    13. Touring a Report
    14. Switching Views
  9. 3. Planning and Creating a Custom Database
    1. Introduction
    2. Creating a Custom Database Template
    3. Using a Custom Database Template
    4. Planning Tables
    5. Creating Tables in a Database
    6. Creating a Table by Entering Data
    7. Creating an Application Part Using a Template
    8. Importing Data into Tables
    9. Linking to Data in Tables
    10. Working with Table Records
    11. Working with a Table in Design View
    12. Specifying a Primary Key in Design View
    13. Planning Table Relationships
    14. Defining Table Relationships
    15. Creating and Printing a Table Relationship Report
    16. Ensuring Referential Integrity
    17. Identifying Object Dependencies
    18. Modifying Object Dependencies
  10. 4. Working with Fields
    1. Introduction
    2. Inserting Fields
    3. Working with Fields
    4. Specifying Data Types and Field Properties
    5. Viewing Field Properties
    6. Changing Field Properties
    7. Updating Field Properties
    8. Setting Field Size
    9. Formatting Text Values
    10. Formatting Long Text with Rich Text
    11. Formatting Date and Time Values
    12. Formatting Number and Currency Values
    13. Performing a Total Calculation
    14. Creating Input Masks
    15. Creating Indexed Fields
    16. Specifying Required Fields and Default Values
    17. Adding a Caption to a Field
    18. Validating Field Values
    19. Creating a Lookup Field
    20. Setting Lookup Properties
    21. Creating a Multivalued Field
    22. Attaching Files to Field Records
    23. Creating a Field Data Type Template
    24. Setting Table Properties
  11. 5. Working with Tables
    1. Introduction
    2. Working with Tables
    3. Repairing Renaming Errors
    4. Managing Linked Tables
    5. Working with the Clipboard
    6. Editing Text
    7. Entering Data Accurately with AutoCorrect
    8. Finding and Replacing Text
    9. Checking Spelling
    10. Using Custom Dictionaries
    11. Formatting a Datasheet
    12. Arranging Field Columns
    13. Changing the Size of Field Columns
    14. Managing Fields Columns
    15. Sorting Records
    16. Viewing a Subdatasheet
    17. Filtering Out Records
    18. Creating Complex Filters Using Forms
  12. 6. Locating Specific Information Using a Query
    1. Introduction
    2. Understanding Types of Queries
    3. Creating a Query in Design View
    4. Getting Information with a Query
    5. Modifying a Query in Design View
    6. Creating a Query Using a Wizard
    7. Changing the Query Fields
    8. Specifying Criteria for a Single Field
    9. Specifying Criteria for Multiple Fields
    10. Creating Queries with Comparison and Logical Operators
    11. Performing Calculations in Queries
    12. Creating a Parameter Query
    13. Finding Duplicate Fields
    14. Finding Unmatched Records
    15. Creating New Tables with a Query
    16. Adding Records with a Query
    17. Deleting Records with a Query
    18. Updating Records with a Query
    19. Summarizing Values with a Crosstab Query
    20. Creating SQL-Specific Queries
  13. 7. Simplifying Data Entry with Forms
    1. Introduction
    2. Creating Forms
    3. Working with Form Controls
    4. Creating a Form
    5. Creating a Blank Form
    6. Creating a Form Using the Form Wizard
    7. Creating a Navigation Form
    8. Creating a Multiple Items Form
    9. Creating a Datasheet Form
    10. Creating a Dialog Form
    11. Creating a Split Form
    12. Entering and Editing Data in a Form
    13. Working with a Form in Layout View
    14. Working with a Form in Design View
    15. Modifying a Form
    16. Adding Existing Fields
    17. Adding and Modifying Controls
    18. Adding Controls with a Wizard
    19. Creating a Subform
    20. Enhancing a Form
    21. Working with Themes on Forms
    22. Using Windows Themes on Forms
  14. 8. Creating Reports to Convey Information
    1. Introduction
    2. Exploring Different Ways to Create a Report
    3. Creating a Report
    4. Creating a Blank Report
    5. Creating Mailing Labels
    6. Using Sections in Design View
    7. Working with Controls
    8. Creating and Modifying a Report in Design View
    9. Using Buttons and Controls
    10. Arranging Information
    11. Inserting a Title, Page Numbers, or the Date and Time
    12. Inserting a Picture as a Logo
    13. Setting Properties
    14. Performing Calculations in Reports
    15. Grouping and Sorting in Reports
    16. Inserting a Header or Footer
    17. Assigning a Shortcut Key to a Control
    18. Checking for Errors in Reports and Forms
    19. Changing the Page Setup
    20. Previewing Information
    21. Printing Information
  15. 9. Improving the Appearance of Forms and Reports
    1. Introduction
    2. Applying a Theme to a Form or Report
    3. Creating a Custom Theme
    4. Formatting a Form or Report
    5. Adding Lines and Rectangles
    6. Changing Line or Border Thickness and Style
    7. Changing Colors
    8. Applying Styles, Shapes, and Effects
    9. Applying Special Effects
    10. Applying the Format Painter
    11. Applying Conditional Formatting
    12. Changing Tabbing Order
    13. Resizing and Moving Controls
    14. Aligning Controls
    15. Positioning Controls
    16. Grouping and Ungrouping Controls
    17. Changing Gridlines
    18. Creating a Tabular or Stacked Layout
    19. Changing Control Margins and Padding
    20. Changing Control Rows and Columns
    21. Sharing Information Among Documents
    22. Copying and Pasting Objects
    23. Inserting a New Object
    24. Inserting an Object from a File
    25. Inserting a Picture
    26. Inserting Excel Charts and Worksheets
    27. Inserting a Graph Chart
    28. Formatting Chart Objects
    29. Moving and Resizing an Object
    30. Setting OLE Options
  16. 10. Connecting to Information on the Web
    1. Introduction
    2. Integrating Access and the Internet
    3. Creating a Hyperlink Field
    4. Inserting a Hyperlink to a File or Web Page
    5. Building a Hyperlink with Expressions
    6. Linking to an Object in a Database
    7. Creating a Hyperlink to an E-mail Address
    8. Navigating Hyperlinks
    9. Working with Hyperlinks
    10. Inserting a Web Browser Control
    11. Exporting Database Objects to HTML
    12. Importing or Linking to an HTML File
    13. Creating a Table Using SharePoint
    14. Importing or Linking to SharePoint Data
    15. Exporting Data to SharePoint
    16. Moving Data to SharePoint
    17. Working with SharePoint Data Offline
    18. Publishing a Database to SharePoint
  17. 11. Importing and Exporting Information
    1. Introduction
    2. Importing and Linking Data
    3. Saving Import and Export Settings
    4. Importing or Linking Data from an Access Database
    5. Importing or Linking Data from Excel
    6. Importing or Linking Data from a Mail Program
    7. Getting Data from Other Sources
    8. Importing and Exporting XML Data
    9. Exporting Data to Other Programs
    10. Merging Data with Word
    11. Exporting Data to Excel
    12. Creating a PDF Document
    13. Creating an XPS Document
    14. Saving a Database Object
  18. 12. Managing a Database
    1. Introduction
    2. Backing Up a Database
    3. Compacting and Repairing a Database
    4. Changing Database Properties
    5. Documenting a Database
    6. Analyzing a Database
    7. Working with Add-Ins
    8. Setting Database Application Options
    9. Splitting a Database
  19. 13. Protecting and Securing a Database
    1. Introduction
    2. Adding Security Encryption to a Database
    3. Creating a Digital Certificate
    4. Adding a Digital Signature to a Database
    5. Packaging and Digitally Signing a Database
    6. Avoiding Harmful Attacks
    7. Using the Trust Center
    8. Selecting Trusted Publishers and Locations
    9. Setting Document Related Security Options
    10. Setting ActiveX Security Options
    11. Setting Add-In Security Options
    12. Setting Macro Security Options
    13. Changing Message Bar Security Options
    14. Setting Privacy Options
    15. Locking a Database
    16. Locking Database Records
  20. 14. Customizing Access
    1. Introduction
    2. Setting Current Database Options
    3. Setting Object Designers Options
    4. Setting Database File Options
    5. Setting Editing Options
    6. Changing Datasheet Formatting Options
    7. Setting Office Options
    8. Setting General Options
    9. Working with Touch Screens
    10. Accessing Commands Not in the Ribbon
    11. Using Multiple Languages
    12. Working with Office Tools
    13. Maintaining and Repairing Office
  21. 15. Automating and Extending a Database
    1. Introduction
    2. Automating a Database with Macros
    3. Creating or Editing a Macro
    4. Running and Testing a Macro
    5. Creating a Macro Group
    6. Creating a Macro Condition
    7. Adding Comments to a Macro
    8. Creating a Message Box
    9. Assigning a Macro to an Event
    10. Assigning a Macro to a Button
    11. Assigning a Macro to a Toolbar
    12. Extending a Database with VBA
    13. Creating a Module
    14. Viewing the Visual Basic Editor
    15. Creating a Sub Procedure
    16. Writing VBA Commands
    17. Running a Sub Procedure
    18. Copying Commands from the Object Browser
    19. Creating a Custom Function
    20. Running a Custom Function
    21. Creating a Class Module for a Form or Report
    22. Setting Project Properties
    23. Debugging a Procedure
    24. Identifying VBA Debugging Tools
    25. Optimizing Performance with an ACCDE File
  22. 16. Creating a Web App with Access
    1. Introduction
    2. Creating a Web App
    3. Opening a Web App
    4. Adding Tables and Data to a Web App
    5. Viewing and Editing Data in a Web App
    6. Creating a View in a Web App
    7. Modifying a Web App
    8. Changing Properties in a Web App
    9. Creating Actions in a Web App
    10. Creating Database Objects in Web Apps
    11. Using the Navigation Pane with Web Apps
    12. Launching a Web App in a Web Browser
    13. Packaging a Web App
    14. Working with a Web App on SharePoint
    15. Changing Web App Settings on SharePoint
    16. Adding a Web App from the SharePoint Store
  23. 17. Working Online with Office Documents
    1. Introduction
    2. Working Online with SharePoint and SkyDrive
    3. Signing in to SharePoint or SkyDrive
    4. Saving and Opening on SharePoint or SkyDrive
    5. Accessing Documents on SharePoint
    6. Syncing Documents on SharePoint
    7. Sharing Documents on SkyDrive
    8. Accessing Documents on SkyDrive
    9. Managing Documents on SkyDrive
    10. Downloading or Uploading Documents on SkyDrive
    11. Creating Office Documents on SkyDrive
    12. Sending Links to Documents on SkyDrive
    13. Comparing the Office Desktop App to the Web App
    14. Working with Office Web Apps
    15. Saving or Printing Documents in Office Web Apps
    16. Co-authoring Documents with Office Web Apps
    17. Blocking Co-authoring Documents
  24. New! Features
    1. Microsoft Access 2013
  25. Microsoft Office Specialist
    1. About the MOS Program
    2. What Does This Logo Mean?
    3. Preparing for a MOS Exam
    4. Taking a MOS Exam
    5. Getting More Information
  26. Index
  27. Online Workshop