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 queondemand.com to gain access to:
• Workshops and related files
• Keyboard shortcuts
Visit the author site: perspection.com
Table of contents
- About This eBook
- Title Page
- Copyright Page
- Acknowledgments
- Contents
- Introduction
-
1. Getting Started with Access
- Introduction
- Understanding How Databases Store Data
- Starting Access
- Using the Ribbon
- Choosing Commands
- Working with the Ribbon and Toolbars
- Choosing Dialog Box Options
- Using the Status Bar
- Creating a Database
- Opening a Database
- Converting an Existing Database
- Viewing the Access Window
- Arranging Windows
- Using Task and Window Panes
- Getting Help While You Work
- Saving a Database
- Saving a Database with Different Formats
- Working with Accounts
- Working with Online Storage
- Closing a Database and Exiting Access
-
2. Touring Access Databases
- Introduction
- Opening a Sample Database
- Warnings About Macros and Add-Ins
- Using a Switchboard
- Changing Database Display Options
- Viewing Database Objects
- Working with Database Objects
- Grouping and Hiding Database Objects
- Touring a Table
- Touring a Form
- Entering Data
- Touring a Query
- Touring a Report
- Switching Views
-
3. Planning and Creating a Custom Database
- Introduction
- Creating a Custom Database Template
- Using a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating an Application Part Using a Template
- Importing Data into Tables
- Linking to Data in Tables
- Working with Table Records
- Working with a Table in Design View
- Specifying a Primary Key in Design View
- Planning Table Relationships
- Defining Table Relationships
- Creating and Printing a Table Relationship Report
- Ensuring Referential Integrity
- Identifying Object Dependencies
- Modifying Object Dependencies
-
4. Working with Fields
- Introduction
- Inserting Fields
- Working with Fields
- Specifying Data Types and Field Properties
- Viewing Field Properties
- Changing Field Properties
- Updating Field Properties
- Setting Field Size
- Formatting Text Values
- Formatting Long Text with Rich Text
- Formatting Date and Time Values
- Formatting Number and Currency Values
- Performing a Total Calculation
- Creating Input Masks
- Creating Indexed Fields
- Specifying Required Fields and Default Values
- Adding a Caption to a Field
- Validating Field Values
- Creating a Lookup Field
- Setting Lookup Properties
- Creating a Multivalued Field
- Attaching Files to Field Records
- Creating a Field Data Type Template
- Setting Table Properties
-
5. Working with Tables
- Introduction
- Working with Tables
- Repairing Renaming Errors
- Managing Linked Tables
- Working with the Clipboard
- Editing Text
- Entering Data Accurately with AutoCorrect
- Finding and Replacing Text
- Checking Spelling
- Using Custom Dictionaries
- Formatting a Datasheet
- Arranging Field Columns
- Changing the Size of Field Columns
- Managing Fields Columns
- Sorting Records
- Viewing a Subdatasheet
- Filtering Out Records
- Creating Complex Filters Using Forms
-
6. Locating Specific Information Using a Query
- Introduction
- Understanding Types of Queries
- Creating a Query in Design View
- Getting Information with a Query
- Modifying a Query in Design View
- Creating a Query Using a Wizard
- Changing the Query Fields
- Specifying Criteria for a Single Field
- Specifying Criteria for Multiple Fields
- Creating Queries with Comparison and Logical Operators
- Performing Calculations in Queries
- Creating a Parameter Query
- Finding Duplicate Fields
- Finding Unmatched Records
- Creating New Tables with a Query
- Adding Records with a Query
- Deleting Records with a Query
- Updating Records with a Query
- Summarizing Values with a Crosstab Query
- Creating SQL-Specific Queries
-
7. Simplifying Data Entry with Forms
- Introduction
- Creating Forms
- Working with Form Controls
- Creating a Form
- Creating a Blank Form
- Creating a Form Using the Form Wizard
- Creating a Navigation Form
- Creating a Multiple Items Form
- Creating a Datasheet Form
- Creating a Dialog Form
- Creating a Split Form
- Entering and Editing Data in a Form
- Working with a Form in Layout View
- Working with a Form in Design View
- Modifying a Form
- Adding Existing Fields
- Adding and Modifying Controls
- Adding Controls with a Wizard
- Creating a Subform
- Enhancing a Form
- Working with Themes on Forms
- Using Windows Themes on Forms
-
8. Creating Reports to Convey Information
- Introduction
- Exploring Different Ways to Create a Report
- Creating a Report
- Creating a Blank Report
- Creating Mailing Labels
- Using Sections in Design View
- Working with Controls
- Creating and Modifying a Report in Design View
- Using Buttons and Controls
- Arranging Information
- Inserting a Title, Page Numbers, or the Date and Time
- Inserting a Picture as a Logo
- Setting Properties
- Performing Calculations in Reports
- Grouping and Sorting in Reports
- Inserting a Header or Footer
- Assigning a Shortcut Key to a Control
- Checking for Errors in Reports and Forms
- Changing the Page Setup
- Previewing Information
- Printing Information
-
9. Improving the Appearance of Forms and Reports
- Introduction
- Applying a Theme to a Form or Report
- Creating a Custom Theme
- Formatting a Form or Report
- Adding Lines and Rectangles
- Changing Line or Border Thickness and Style
- Changing Colors
- Applying Styles, Shapes, and Effects
- Applying Special Effects
- Applying the Format Painter
- Applying Conditional Formatting
- Changing Tabbing Order
- Resizing and Moving Controls
- Aligning Controls
- Positioning Controls
- Grouping and Ungrouping Controls
- Changing Gridlines
- Creating a Tabular or Stacked Layout
- Changing Control Margins and Padding
- Changing Control Rows and Columns
- Sharing Information Among Documents
- Copying and Pasting Objects
- Inserting a New Object
- Inserting an Object from a File
- Inserting a Picture
- Inserting Excel Charts and Worksheets
- Inserting a Graph Chart
- Formatting Chart Objects
- Moving and Resizing an Object
- Setting OLE Options
-
10. Connecting to Information on the Web
- Introduction
- Integrating Access and the Internet
- Creating a Hyperlink Field
- Inserting a Hyperlink to a File or Web Page
- Building a Hyperlink with Expressions
- Linking to an Object in a Database
- Creating a Hyperlink to an E-mail Address
- Navigating Hyperlinks
- Working with Hyperlinks
- Inserting a Web Browser Control
- Exporting Database Objects to HTML
- Importing or Linking to an HTML File
- Creating a Table Using SharePoint
- Importing or Linking to SharePoint Data
- Exporting Data to SharePoint
- Moving Data to SharePoint
- Working with SharePoint Data Offline
- Publishing a Database to SharePoint
-
11. Importing and Exporting Information
- Introduction
- Importing and Linking Data
- Saving Import and Export Settings
- Importing or Linking Data from an Access Database
- Importing or Linking Data from Excel
- Importing or Linking Data from a Mail Program
- Getting Data from Other Sources
- Importing and Exporting XML Data
- Exporting Data to Other Programs
- Merging Data with Word
- Exporting Data to Excel
- Creating a PDF Document
- Creating an XPS Document
- Saving a Database Object
- 12. Managing a Database
-
13. Protecting and Securing a Database
- Introduction
- Adding Security Encryption to a Database
- Creating a Digital Certificate
- Adding a Digital Signature to a Database
- Packaging and Digitally Signing a Database
- Avoiding Harmful Attacks
- Using the Trust Center
- Selecting Trusted Publishers and Locations
- Setting Document Related Security Options
- Setting ActiveX Security Options
- Setting Add-In Security Options
- Setting Macro Security Options
- Changing Message Bar Security Options
- Setting Privacy Options
- Locking a Database
- Locking Database Records
-
14. Customizing Access
- Introduction
- Setting Current Database Options
- Setting Object Designers Options
- Setting Database File Options
- Setting Editing Options
- Changing Datasheet Formatting Options
- Setting Office Options
- Setting General Options
- Working with Touch Screens
- Accessing Commands Not in the Ribbon
- Using Multiple Languages
- Working with Office Tools
- Maintaining and Repairing Office
-
15. Automating and Extending a Database
- Introduction
- Automating a Database with Macros
- Creating or Editing a Macro
- Running and Testing a Macro
- Creating a Macro Group
- Creating a Macro Condition
- Adding Comments to a Macro
- Creating a Message Box
- Assigning a Macro to an Event
- Assigning a Macro to a Button
- Assigning a Macro to a Toolbar
- Extending a Database with VBA
- Creating a Module
- Viewing the Visual Basic Editor
- Creating a Sub Procedure
- Writing VBA Commands
- Running a Sub Procedure
- Copying Commands from the Object Browser
- Creating a Custom Function
- Running a Custom Function
- Creating a Class Module for a Form or Report
- Setting Project Properties
- Debugging a Procedure
- Identifying VBA Debugging Tools
- Optimizing Performance with an ACCDE File
-
16. Creating a Web App with Access
- Introduction
- Creating a Web App
- Opening a Web App
- Adding Tables and Data to a Web App
- Viewing and Editing Data in a Web App
- Creating a View in a Web App
- Modifying a Web App
- Changing Properties in a Web App
- Creating Actions in a Web App
- Creating Database Objects in Web Apps
- Using the Navigation Pane with Web Apps
- Launching a Web App in a Web Browser
- Packaging a Web App
- Working with a Web App on SharePoint
- Changing Web App Settings on SharePoint
- Adding a Web App from the SharePoint Store
-
17. Working Online with Office Documents
- Introduction
- Working Online with SharePoint and SkyDrive
- Signing in to SharePoint or SkyDrive
- Saving and Opening on SharePoint or SkyDrive
- Accessing Documents on SharePoint
- Syncing Documents on SharePoint
- Sharing Documents on SkyDrive
- Accessing Documents on SkyDrive
- Managing Documents on SkyDrive
- Downloading or Uploading Documents on SkyDrive
- Creating Office Documents on SkyDrive
- Sending Links to Documents on SkyDrive
- Comparing the Office Desktop App to the Web App
- Working with Office Web Apps
- Saving or Printing Documents in Office Web Apps
- Co-authoring Documents with Office Web Apps
- Blocking Co-authoring Documents
- New! Features
- Microsoft Office Specialist
- Index
- Online Workshop
Product information
- Title: Access® 2013 on Demand
- Author(s):
- Release date: May 2013
- Publisher(s): Que
- ISBN: 9780133352955
You might also like
book
Microsoft® Access® 2013 Step by Step
Experience learning made easy—and quickly teach yourself how to build your own database with Access 2013. …
book
Access 2007: The Missing Manual
Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. …
book
Using Microsoft® Visio® 2010
Using Microsoft Visio 2010 is a customized, media-rich learning experience designed to help new users master …
book
Professional Access 2013 Programming
Authoritative and comprehensive coverage for building Access 2013 Solutions Access, the most popular database system in …