Calgary Public Library

Access 2013 All-in-One For Dummies

eng

no index present

non fiction

Access 2013 All-in-One For Dummies

electronic resource

dictionaries

831116674

Get started with the new Access 2013 with this impressive all-in-one reference! Microsoft Access allows you to store, organize, view, analyze, and share data; the new release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. This compilation of nine indispensible minibooks is exactly what you need to get up to speed on the latest changes to Access. This easy-to-understand resource provides both new and experienced Access users with invaluable advice for connecting Access to SQL Server, manipulating data local

Access® 2013 All-in-One For Dummies®; Contents at a Glance; Table of Contents; Book I: Getting Started with Access 2013; Chapter 1: Introducing Access 2013; Why Use a Database?; Plan, Plan, Plan; The Six Types of Access Objects; Essential Database Concepts; Chapter 2: Getting Started, Getting Around; Running Access; Opening a Database; Making Friends with the Access Window; Introducing Mission Control: The Navigation Pane; Viewing Objects in Your Database; Creating, Deleting, Renaming, Copying, and Printing Objects; Introducing Backstage View; Using Wizards; Getting HelpSaving Time with Keyboard ShortcutsChapter 3: Designing Your Database the Relational Way; What Are Tables, Fields, and Keys?; What Are Relationships?; Designing a Database; Choosing Field Types; Storing Single Facts; Creating a Database; Book II: Tables for Storing Your Data; Chapter 1: Creating and Modifying Tables; Viewing Your Tables; Creating the First Table for Your Data; Working with Tables and Fields in Your Database; Creating Fields; Working with a Datasheet Full of Data; Adding and Editing Records; Checking Your Spelling; Using AutoCorrect for Faster Data EntryFormatting a DatasheetTaking Advantage of Subdatasheets; Adding a Total Row to the Datasheet; Chapter 2: Refining Your Table in Design View; Creating Tables in Design View; Refining Your Table in Design View; Formatting Fields with Field Properties; Defining the Primary Key; Indexing Fields; Printing Table Designs; Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet; Sorting the Rows of a Datasheet; Finding (and Replacing) Data; Filtering a Datasheet; Chapter 4: Importing and Exporting Data; Cutting, Copying, and Pasting; Importing or Linking to DataGetting Data from Another Access DatabaseGetting Data Out of Access; Using Access Data in a Word Mail Merge; Chapter 5: Avoiding "Garbage In, Garbage Out"; Finding the Right Tool to Keep Garbage Out; Using Input Masks to Validate and Format Data; Creating a Lookup Field; Validating Data As It's Entered; Chapter 6: Relating Your Tables and Protecting Your Data; Creating Relationships and Protecting Your Data with Referential Integrity; Creating Referential Integrity with Many-to-Many Relationships; Printing the Relationships Window; Book III: Queries (Or Getting Information from Your Data)Chapter 1: Creating Select QueriesUnderstanding Types of Queries; Creating a Query in Design View; Creating a Query with the Simple Query Wizard; Viewing Your Query; Using Query Design View; Taking Tips on Creating a Query; Editing a Query; Limiting Records with Criteria Expressions; Working with Multiple Related Tables; Working with Query Datasheets; Saving Queries; Chapter 2: Letting Queries Do the Math; Doing Calculations in Queries; Writing Expressions in Access; Using Expression Builder; Going beyond Basic Arithmetic; Performing Date and Time Calculations