The Resource Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)

Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)

Label
Access 2013 bible
Title
Access 2013 bible
Statement of responsibility
by Michael Alexander, Dick Kusleika
Creator
Contributor
Subject
Genre
Language
eng
Summary
A comprehensive reference to the updated and new features of Access 2013 As the world's most popular database management tool, Access enables you to organize, present, analyze, and share data as well as build powerful database solutions. However, databases can be complex. That's why you need the expert guidance in this comprehensive reference. Access 2013 Bible helps you gain a solid understanding of database purpose, construction, and application so that whether you're new to Access or looking to upgrade to the 2013 version, this well-rounded resource provides you with a th
Cataloging source
EBLCP
http://library.link/vocab/creatorDate
1950-
http://library.link/vocab/creatorName
Alexander, Michael
Dewey number
005.75/65
Index
no index present
LC call number
QA76.9.D3
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
Kusleika, Dick
http://library.link/vocab/subjectName
  • Database management -- Computer programs
  • Database management
  • Microsoft access
  • Database management
Label
Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)
Link
http://calgary.lib.overdrive.com/ContentDetails.htm?ID=892BE2D8-64DF-4D96-8469-2CFC63024162
Instantiates
Publication
Note
  • Description based upon print version of record
  • Getting Fancy with Advanced SQL Statements
Contents
  • Microsoft Access 2013 Bible; About the Authors; Acknowledgments; Contents at a Glance; Contents; Introduction; Is This Book for You?; Conventions Used in This Book; How This Book Is Organized; How to Use This Book; What's on the Website; Part I: Access Building Blocks; Chapter 1: An Introduction to Database Development; The Database Terminology of Access; Relational Databases; Access Database Objects; A Five-Step Design Method; Chapter 2: Getting Started with Access; The Access Welcome Screen; How to Create a Blank Desktop Database; The Access 2013 Interface
  • Part II: Understanding Access TablesChapter 3: Creating Access Tables; Table Types; Creating a New Table; Creating tblCustomers; Changing a Table Design; Understanding tblCustomers Field Properties; Setting the Primary Key; Indexing Access Tables; Printing a Table Design; Saving the Completed Table; Manipulating Tables; Adding Records to a Database Table; Understanding Attachment Fields; Chapter 4: Understanding Table Relationships; Building Bulletproof Databases; Data Normalization and Denormalization; Table Relationships; Integrity Rules; Keys; Chapter 5: Working with Access Tables
  • Understanding DatasheetsLooking at the Datasheet Window; Opening a Datasheet; Entering New Data; Navigating Records in a Datasheet; Changing Values in a Datasheet; Using the Undo Feature; Copying and Pasting Values; Replacing Values; Adding New Records; Deleting Records; Displaying Records; Sorting and Filtering Records in a Datasheet; Aggregating Data; Printing Records; Chapter 6: Importing and Exporting Data; How Access Works with External Data; Options for Importing and Exporting; How to Import External Data; How to Export to External Formats; Chapter 7: Linking to External Data
  • Linking External DataWorking with Linked Tables; Splitting a Database; Part III: Working with Access Queries; Chapter 8: Selecting Data with Queries; Introducing Queries; Creating a Query; Working with Query Fields; Adding Criteria to Your Queries; Printing a Query's Recordset; Saving a Query; Creating Multi-Table Queries; Working with the Table Pane; Creating and Working with Query Joins; Chapter 9: Using Operators and Expressions in Access; Introducing Operators; Using Operators and Expressions in Queries; Entering Single-Value Field Criteria; Using Multiple Criteria in a Query
  • Entering Criteria in Multiple FieldsChapter 10: Going Beyond Select Queries; Aggregate Queries; Action Queries; Crosstab Queries; Part IV: Analyzing Data in Access; Chapter 11: Transforming Data in Access; Finding and Removing Duplicate Records; Common Transformation Tasks; Chapter 12: Working with Calculations and Dates; Using Calculations in Your Analyses; Using Dates in Your Analyses; Chapter 13: Performing Conditional Analyses; Using Parameter Queries; Using Conditional Functions; Chapter 14: Fundamentals of Using Access SQL; Understanding Basic SQL
Control code
ocn836401060
Dimensions
unknown
Extent
1 online resource.
Form of item
online
Isbn
9781118490341
Isbn Type
(electronic bk.)
Specific material designation
remote
System control number
(OCoLC)836401060
Label
Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)
Link
http://calgary.lib.overdrive.com/ContentDetails.htm?ID=892BE2D8-64DF-4D96-8469-2CFC63024162
Publication
Note
  • Description based upon print version of record
  • Getting Fancy with Advanced SQL Statements
Contents
  • Microsoft Access 2013 Bible; About the Authors; Acknowledgments; Contents at a Glance; Contents; Introduction; Is This Book for You?; Conventions Used in This Book; How This Book Is Organized; How to Use This Book; What's on the Website; Part I: Access Building Blocks; Chapter 1: An Introduction to Database Development; The Database Terminology of Access; Relational Databases; Access Database Objects; A Five-Step Design Method; Chapter 2: Getting Started with Access; The Access Welcome Screen; How to Create a Blank Desktop Database; The Access 2013 Interface
  • Part II: Understanding Access TablesChapter 3: Creating Access Tables; Table Types; Creating a New Table; Creating tblCustomers; Changing a Table Design; Understanding tblCustomers Field Properties; Setting the Primary Key; Indexing Access Tables; Printing a Table Design; Saving the Completed Table; Manipulating Tables; Adding Records to a Database Table; Understanding Attachment Fields; Chapter 4: Understanding Table Relationships; Building Bulletproof Databases; Data Normalization and Denormalization; Table Relationships; Integrity Rules; Keys; Chapter 5: Working with Access Tables
  • Understanding DatasheetsLooking at the Datasheet Window; Opening a Datasheet; Entering New Data; Navigating Records in a Datasheet; Changing Values in a Datasheet; Using the Undo Feature; Copying and Pasting Values; Replacing Values; Adding New Records; Deleting Records; Displaying Records; Sorting and Filtering Records in a Datasheet; Aggregating Data; Printing Records; Chapter 6: Importing and Exporting Data; How Access Works with External Data; Options for Importing and Exporting; How to Import External Data; How to Export to External Formats; Chapter 7: Linking to External Data
  • Linking External DataWorking with Linked Tables; Splitting a Database; Part III: Working with Access Queries; Chapter 8: Selecting Data with Queries; Introducing Queries; Creating a Query; Working with Query Fields; Adding Criteria to Your Queries; Printing a Query's Recordset; Saving a Query; Creating Multi-Table Queries; Working with the Table Pane; Creating and Working with Query Joins; Chapter 9: Using Operators and Expressions in Access; Introducing Operators; Using Operators and Expressions in Queries; Entering Single-Value Field Criteria; Using Multiple Criteria in a Query
  • Entering Criteria in Multiple FieldsChapter 10: Going Beyond Select Queries; Aggregate Queries; Action Queries; Crosstab Queries; Part IV: Analyzing Data in Access; Chapter 11: Transforming Data in Access; Finding and Removing Duplicate Records; Common Transformation Tasks; Chapter 12: Working with Calculations and Dates; Using Calculations in Your Analyses; Using Dates in Your Analyses; Chapter 13: Performing Conditional Analyses; Using Parameter Queries; Using Conditional Functions; Chapter 14: Fundamentals of Using Access SQL; Understanding Basic SQL
Control code
ocn836401060
Dimensions
unknown
Extent
1 online resource.
Form of item
online
Isbn
9781118490341
Isbn Type
(electronic bk.)
Specific material designation
remote
System control number
(OCoLC)836401060

Library Locations

  • Bowness LibraryBorrow it
    6532 Bowness Road NW, Calgary, Alberta, T3B OE9, CA
    51.0889698 -114.2011763
  • Calgary Public Library MobileBorrow it
    CA
  • Central LibraryBorrow it
    616 Macleod Trail SE, Calgary, Alberta, T2G 2M2, CA
    51.046473 -114.057859
  • Country Hills LibraryBorrow it
    11950 Country Village Link NE, Calgary, Alberta, T3K 6E3, CA
    51.160139 -114.0676844
  • Crowfoot LibraryBorrow it
    8665 Nose Hill Drive, Calgary, Alberta, T3G 5T3, CA
    51.129458 -114.193826
  • Fish Creek LibraryBorrow it
    11161 Bonaventure Drive SE, Calgary, Alberta, T2J 6S1, CA
    50.951870 -114.061042
  • Forest Lawn LibraryBorrow it
    4807 8th Avenue SE, Calgary, Alberta, T2A 4M1, CA
    51.0451596 -113.9657157
  • Giuffre Family LibraryBorrow it
    3223 14th Street SW, Calgary, Alberta, T2T 3V8, CA
    51.024526 -114.0947351
  • Glenmore Square LibraryBorrow it
    7740 18th Street SE, Calgary, Alberta, T2C 2N5, CA
    50.9833577 -114.0146572
  • Judith Umbach LibraryBorrow it
    6617 Centre Street North, Calgary, Alberta, T2K 4Y5, CA
    51.1113839 -114.0626328
  • Louise Riley LibraryBorrow it
    1904 14th Avenue NW, Calgary, Alberta, T2N 1M5, CA
    51.0652117 -114.105152
  • Memorial Park LibraryBorrow it
    1221 2nd Street SW, Calgary, Alberta, T2R 0W5, CA
    51.041549 -114.0682554
  • Nose Hill LibraryBorrow it
    1530 Northmount Drive NW, Calgary, Alberta, T2L 0G6, CA
    51.096103 -114.13759
  • Saddletowne LibraryBorrow it
    7556 Falconridge Blvd NE, Calgary, Alberta, T3J 0C9, CA
    51.1212759 -113.9469193
  • Shaganappi LibraryBorrow it
    3415 8th Avenue SW, Calgary, Alberta, T3C 0E8, CA
    51.0448674 -114.1367083
  • Shawnessy LibraryBorrow it
    333 Shawville Blvd. SE, Calgary, Alberta, T2Y 4H3, CA
    50.898545 -114.062885
  • Signal Hill LibraryBorrow it
    5994 Signal Hill Centre SW, Calgary, Alberta, T3H 3P8, CA
    51.0180759 -114.1755888
  • Southwood LibraryBorrow it
    924 Southland Drive SW, Calgary, Alberta, T2W 0J9, CA
    50.963642 -114.0858663
  • Village Square LibraryBorrow it
    2623 56th Street NE, Calgary, Alberta, T1Y 6E7, CA
    51.0755508 -113.9526426