The Resource Access 2013 All-in-One For Dummies, (electronic resource)

Access 2013 All-in-One For Dummies, (electronic resource)

Label
Access 2013 All-in-One For Dummies
Title
Access 2013 All-in-One For Dummies
Creator
Contributor
Subject
Language
eng
Summary
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
Member of
Cataloging source
EBLCP
Dewey number
005.7565
Index
no index present
LC call number
QA76.9.D3 B377 2013
Literary form
non fiction
Nature of contents
dictionaries
Series statement
EBSCO eBooks
Target audience
adult
Access 2013 All-in-One For Dummies, (electronic resource)
Label
Access 2013 All-in-One For Dummies, (electronic resource)
Link
http://ezproxy.ae.talonline.ca/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=566603
Publication
Note
  • Description based upon print version of record
  • Manipulating Text with Expressions
Related Contributor
Related Location
Related Agents
Related Authorities
Related Subjects
Related Items
Antecedent source
unknown
Carrier category
online resource
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type MARC source
rdacontent
Contents
  • 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 Help
  • Saving 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 Entry
  • Formatting 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 Data
  • Getting 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
Control code
ocn831116674
http://library.link/vocab/cover_art
https://secure.syndetics.com/index.aspx?isbn=9781118637371/LC.GIF&client=780-496-1833&type=xw12&upc=&oclc=%28Sirsi%29%20ebs831116674
Dimensions
unknown
http://library.link/vocab/discovery_link
{'EPLMNA': 'https://epl.bibliocommons.com/item/show/1189404005'}
Extent
1 online resource (795 pages)
File format
unknown
Form of item
online
Isbn
9781118637371
Isbn Type
(electronic bk.)
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
  • (Sirsi) ebs831116674
  • (Sirsi) ebs831116674
  • (CaAE) ebs831116674
  • (OCoLC)831116674

Library Locations

    • Stanley A. Milner (Downtown)Borrow it
      7 Sir Winston Churchill Square, Edmonton, AB, T5J 2V4, CA
      53.542897 -113.48975860000002
Processing Feedback ...