Home > Store

Access 2013 on Demand

Register your product to gain access to bonus material or receive a coupon.

Access 2013 on Demand

eBook (Watermarked)

  • Your Price: $19.19
  • List Price: $23.99
  • Includes EPUB and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    Adobe Reader PDF The popular standard, used most often with the free Acrobat® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.


  • Copyright 2013
  • Dimensions: 7-1/2" x 9-1/8"
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-335294-3
  • ISBN-13: 978-0-13-335294-8

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

Sample Content

Table of Contents

Introduction    xvii

1 Getting Started with Access    1

Understanding How Databases Store Data    2

Starting Access    4 New!

Using the Ribbon    6

Choosing Commands    7 New!

Working with the Ribbon and Toolbars    8

Choosing Dialog Box Options    10

Using the Status Bar    11

Creating a Database    12 New!

Opening a Database    14 New!

Converting an Existing Database    16

Viewing the Access Window    17

Arranging Windows    18

Using Task and Window Panes    19

Getting Help While You Work    20 New!

Saving a Database    22

Saving a Database with Different Formats    24

Working with Accounts    25 New!

Working with Online Storage    26 New!

Closing a Database and Exiting Access    28 New!

2 Touring Access Databases    29

Opening a Sample Database    30

Warnings About Macros and Add-Ins    31

Using a Switchboard    32

Changing Database Display Options    33

Viewing Database Objects    34

Working with Database Objects    36

Grouping and Hiding Database Objects    38

Touring a Table    40

Touring a Form    42

Entering Data    43

Touring a Query    44

Touring a Report    45

Switching Views    46

3 Planning and Creating a Custom Database    49

Creating a Custom Database Template    50 New!

Using a Custom Database Template    52 New!

Planning Tables    54

Creating Tables in a Database    55

Creating a Table by Entering Data    56

Creating an Application Part Using a Template    57

Importing Data into Tables    58

Linking to Data in Tables    59

Working with Table Records    60

Working with a Table in Design View    62

Specifying a Primary Key in Design View    63

Planning Table Relationships    64

Defining Table Relationships    66

Creating and Printing a Table Relationship Report    68

Ensuring Referential Integrity    70

Identifying Object Dependencies    71

Modifying Object Dependencies    72

4 Working with Fields    73

Inserting Fields    74

Working with Fields    76

Specifying Data Types and Field Properties    78 New!

Viewing Field Properties    79

Changing Field Properties    80

Updating Field Properties    82

Setting Field Size    83

Formatting Text Values    84

Formatting Long Text with Rich Text    85 New!

Formatting Date and Time Values    86

Formatting Number and Currency Values    88

Performing a Total Calculation    89

Creating Input Masks    90

Creating Indexed Fields    92

Specifying Required Fields and Default Values    94

Adding a Caption to a Field    95

Validating Field Values    96

Creating a Lookup Field    98

Setting Lookup Properties    100

Creating a Multivalued Field    101

Attaching Files to Field Records    102

Creating a Field Data Type Template    104

Setting Table Properties    106

5 Working with Tables    107

Working with Tables    108

Repairing Renaming Errors    110

Managing Linked Tables    111

Working with the Clipboard    112

Editing Text    114

Entering Data Accurately with AutoCorrect    116

Finding and Replacing Text    118

Checking Spelling    120

Using Custom Dictionaries    122

Formatting a Datasheet    123

Arranging Field Columns    124

Changing the Size of Field Columns    126

Managing Field Columns    127

Sorting Records    128

Viewing a Subdatasheet    130

Filtering Out Records    132

Creating Complex Filters Using Forms    134

6 Locating Specific Information Using a Query    135

Understanding Types of Queries    136

Creating a Query in Design View    137

Getting Information with a Query    138

Modifying a Query in Design View    139

Creating a Query Using a Wizard    140

Changing the Query Fields    142

Specifying Criteria for a Single Field    144

Specifying Criteria for Multiple Fields    145

Creating Queries with Comparison and Logical Operators    146

Performing Calculations in Queries    148

Creating a Parameter Query    150

Finding Duplicate Fields    152

Finding Unmatched Records    153

Creating New Tables with a Query    154

Adding Records with a Query    155

Deleting Records with a Query    156

Updating Records with a Query    157

Summarizing Values with Crosstab Query    158

Creating SQL-Specific Queries    160

7 Simplifying Data Entry with Forms    161

Creating Forms    162

Working with Form Controls    163

Creating a Form    164

Creating a Blank Form    165

Creating a Form Using the Form Wizard    166

Creating a Navigation Form    168

Creating a Multiple Items Form    169

Creating a Datasheet Form    170

Creating a Dialog Form    171

Creating a Split Form    172

Entering and Editing Data in a Form    174

Working with a Form in Layout View    176

Working with a Form in Design View    178

Modifying a Form    180

Adding Existing Fields    182

Adding and Modifying Controls    184

Adding Controls with a Wizard    186

Creating a Subform    188

Enhancing a Form    190

Working with Themes on Forms    192

Using Windows Themes on Forms    194

8 Creating Reports to Convey Information    195

Exploring Different Ways to Create a Report    196

Creating a Report    198

Creating a Blank Report    200

Creating Mailing Labels    201

Using Sections in Design View    202

Working with Controls    203

Creating and Modifying a Report in Design View    204

Using Buttons and Controls    206

Arranging Information    208

Inserting a Title, Page Numbers, or the Date and Time    210

Inserting a Picture as a Logo    212

Setting Properties    213

Performing Calculations in Reports    214

Grouping and Sorting in Reports    216

Inserting a Header or Footer    218

Assigning a Shortcut Key to a Control    219

Checking for Errors in Reports and Forms    220

Changing the Page Setup    222

Previewing Information    224

Printing Information    225

9 Improving the Appearance of Forms and Reports    227

Applying a Theme to a Form or Report    228

Creating a Custom Theme    230

Formatting a Form or Report    232

Adding Lines and Rectangles    234

Changing Line or Border Thickness and Style    235

Changing Colors    236

Applying Styles, Shapes, and Effects    238

Applying Special Effects    240

Applying the Format Painter    241

Applying Conditional Formatting    242

Changing Tabbing Order    244

Resizing and Moving Controls    246

Aligning Controls    248

Positioning Controls    250

Grouping and Ungrouping Controls    252

Changing Gridlines    253

Creating a Tabular or Stacked Layout    254

Changing Control Margins and Padding    256

Changing Control Rows and Columns    257

Sharing Information Among Documents    258

Copying and Pasting Objects    259

Inserting a New Object    260

Inserting an Object from a File    261

Inserting a Picture    262

Inserting Excel Charts and Worksheets    264

Inserting a Graph Chart    266

Formatting Chart Objects    268

Moving and Resizing an Object    270

Setting OLE Options    271

10 Connecting to Information on the Web    273

Integrating Access and the Internet    274

Creating a Hyperlink Field    276

Inserting a Hyperlink to a File or Web Page    277

Building a Hyperlink with Expressions    278

Linking to an Object in a Database    280

Creating a Hyperlink with an E-mail Address    282

Navigating Hyperlinks    283

Working with Hyperlinks    284

Inserting a Web Browser Control    286

Exporting Database Objects to HTML    288

Importing or Linking to an HTML File    289

Creating a Table Using SharePoint    290

Importing or Linking to SharePoint Data    292

Exporting Data to SharePoint    294

Moving Data to SharePoint    295

Working with SharePoint Data Offline    296

Publishing a Database to SharePoint    297

11 Importing and Exporting Information    299

Importing and Linking Data    300

Saving Import and Export Settings    302

Importing or Linking Data from an Access Database    304

Importing or Linking Data from Excel    306

Importing or Linking Data from a Mail Program    307

Getting Data from Other Sources    308

Importing and Exporting XML Data    310

Exporting Data to Other Programs    312

Merging Data with Word    314

Exporting Data to Excel    316 New!

Creating a PDF Document    318

Creating an XPS Document    319

Saving a Database Object    320

12 Managing a Database    321

Backing Up a Database    322

Compacting and Repairing a Database    323

Changing Database Properties    324

Documenting a Database    325

Analyzing a Database    326

Working with Add-Ins    328

Setting Database Application Options    330

Splitting a Database    332

13 Protecting and Securing a Database    333

Adding Security Encryption to a Database    334

Creating a Digital Certificate    336

Adding a Digital Signature to a Database    337

Packaging and Digitally Signing a Database    338

Avoiding Harmful Attacks    340

Using the Trust Center    342

Selecting Trusted Publishers and Locations    343

Setting Document Related Security Options    344

Setting ActiveX Security Options    345

Setting Add-In Security Options    346

Setting Macro Security Options    348

Changing Message Bar Security Options    349

Setting Privacy Options    350

Locking a Database    351

Locking Database Records    352

14 Customizing Access    353

Setting Current Database Options    354

Setting Object Designers Options    356

Setting Database File Options    358 New!

Setting Editing Options    359

Changing Datasheet Formatting Options    360

Setting Office Options    361 New!

Setting General Options    362 New!

Working with Touch Screens    363 New!

Accessing Commands Not in the Ribbon    364

Using Multiple Languages    365

Working with Office Tools    366 New!

Maintaining and Repairing Office    368 New!

15 Automating and Extending a Database    369

Automating Databases with Macros    370

Creating or Editing a Macro    372

Running and Testing a Macro    374

Creating a Macro Group    376

Creating a Macro Conditional    377

Adding Comments to a Macro    378

Creating a Message Box    379

Assigning a Macro to an Event    380

Assigning a Macro to a Button    382

Assigning a Macro to a Toolbar    383

Extending a Database with VBA    384

Creating a Module    386

Viewing the Visual Basic Editor    387

Creating a Sub Procedure    388

Writing VBA Commands    389

Running a Sub Procedure    390

Copying Commands from the Object Browser    391

Creating a Custom Function    392

Running a Custom Function    393

Creating a Class Module for a Form or Report    394

Setting Project Properties    395

Debugging a Procedure    396

Identifying VBA Debugging Tools    397

Optimizing Performance with an ACCDE File    398

16 Creating a Web App with Access    399

Creating a Web App    400 New!

Opening a Web App    402 New!

Adding Tables and Data to a Web App    404 New!

Viewing and Editing Data from a Web App    406 New!

Creating a View in a Web App    408 New!

Modifying a Web App    410 New!

Changing Properties in a Web App    412 New!

Creating Actions in a Web App    414 New!

Creating Database Objects in a Web App    416 New!

Using the Navigation Pane with Web Apps    417 New!

Launching a Web App in a Web Browser    418 New!

Packaging a Web App    420 New!

Working with a Web App on SharePoint    421 New!

Changing Web App Settings on SharePoint    422 New!

Adding a Web App from the SharePoint Store    423 New!

17 Working Online with Office Documents    425

Working Online with SharePoint and SkyDrive    426 New!

Signing in to SharePoint or SkyDrive    428 New!

Saving and Opening on SharePoint or SkyDrive    430 New!

Accessing Documents on SharePoint    432 New!

Syncing Documents on SharePoint    434 New!

Sharing Documents on SkyDrive    436 New!

Accessing Documents on SkyDrive    438 New!

Managing Documents on SkyDrive    440

Downloading or Uploading Documents on SkyDrive    442

Creating Office Documents on SkyDrive    443

Sending Links to Documents on SkyDrive    444 New!

Comparing the Office Desktop App to the Web App    446

Working with Office Web Apps    448 New!

Saving or Printing in Office Web Apps    450

Co-authoring Documents with Office Web Apps    452 New!

Blocking Co-authoring Documents    454

New Features    455 New!

Microsoft Office Specialist    461

Index    469


Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020