Access 2013 On Demand

Access 2013 On Demand

By: Perspection, Inc. (author), Steve Johnson (author)Paperback

2 - 4 weeks availability

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

Create a review

About Author

Steve Johnson has written more than 80 books on a variety of computer software, including Adobe Edge Animate, Adobe Photoshop CS6, Adobe Dreamweaver CS6, Adobe InDesign CS6, Adobe Illustrator CS6, Adobe Flash Professional CS5, Microsoft Windows 8, Microsoft Office 2013 and 2010, Microsoft Office 2008 for the Macintosh, and Apple OS X Mountain Lion. In 1991, after working for Apple Computer and Microsoft, Steve founded Perspection, Inc., which writes and produces software training. When he is not staying up late writing, he enjoys coaching baseball, playing golf, gardening, and spending time with his wife, Holly, and three children, JP, Brett, and Hannah. Steve and his family live in Northern California, but can also be found visiting family all over the western United States.

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

Product Details

  • publication date: 09/05/2013
  • ISBN13: 9780789750471
  • Format: Paperback
  • Number Of Pages: 448
  • ID: 9780789750471
  • weight: 841
  • ISBN10: 0789750473

Delivery Information

  • Saver Delivery: Yes
  • 1st Class Delivery: Yes
  • Courier Delivery: Yes
  • Store Delivery: Yes

Prices are for internet purchases only. Prices and availability in WHSmith Stores may vary significantly

Close