Borrow it
- Bowness Library
- Calgary Public Library Mobile
- Central Library
- Country Hills Library
- Crowfoot Library
- Fish Creek Library
- Forest Lawn Library
- Giuffre Family Library
- Glenmore Square Library
- Judith Umbach Library
- Louise Riley Library
- Memorial Park Library
- Nose Hill Library
- Saddletowne Library
- Shaganappi Library
- Shawnessy Library
- Signal Hill Library
- Southwood Library
- Village Square Library
The Resource Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)
Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)
Resource Information
The item Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource) represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Calgary Public Library.This item is available to borrow from all library branches.
Resource Information
The item Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource) represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Calgary Public Library.
This item is available to borrow from all library branches.
- 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
- Language
- eng
- Extent
- 1 online resource.
- 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
- Isbn
- 9781118491546
- Label
- Access 2013 bible
- Title
- Access 2013 bible
- Statement of responsibility
- by Michael Alexander, Dick Kusleika
- 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)
- 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
- 9781118491546
- Isbn Type
- (electronic bk.)
- Specific material designation
- remote
- System control number
- (OCoLC)836401060
- Label
- Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)
- 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
- 9781118491546
- Isbn Type
- (electronic bk.)
- Specific material designation
- remote
- System control number
- (OCoLC)836401060
Library Locations
-
Bowness LibraryBorrow it6532 Bowness Road NW, Calgary, Alberta, T3B OE9, CA51.0889698 -114.2011763
-
Calgary Public Library MobileBorrow itCA
-
-
Country Hills LibraryBorrow it11950 Country Village Link NE, Calgary, Alberta, T3K 6E3, CA51.160139 -114.0676844
-
-
Fish Creek LibraryBorrow it11161 Bonaventure Drive SE, Calgary, Alberta, T2J 6S1, CA50.951870 -114.061042
-
Forest Lawn LibraryBorrow it4807 8th Avenue SE, Calgary, Alberta, T2A 4M1, CA51.0451596 -113.9657157
-
Giuffre Family LibraryBorrow it3223 14th Street SW, Calgary, Alberta, T2T 3V8, CA51.024526 -114.0947351
-
Glenmore Square LibraryBorrow it7740 18th Street SE, Calgary, Alberta, T2C 2N5, CA50.9833577 -114.0146572
-
Judith Umbach LibraryBorrow it6617 Centre Street North, Calgary, Alberta, T2K 4Y5, CA51.1113839 -114.0626328
-
Louise Riley LibraryBorrow it1904 14th Avenue NW, Calgary, Alberta, T2N 1M5, CA51.0652117 -114.105152
-
Memorial Park LibraryBorrow it1221 2nd Street SW, Calgary, Alberta, T2R 0W5, CA51.041549 -114.0682554
-
Nose Hill LibraryBorrow it1530 Northmount Drive NW, Calgary, Alberta, T2L 0G6, CA51.096103 -114.13759
-
Saddletowne LibraryBorrow it7556 Falconridge Blvd NE, Calgary, Alberta, T3J 0C9, CA51.1212759 -113.9469193
-
Shaganappi LibraryBorrow it3415 8th Avenue SW, Calgary, Alberta, T3C 0E8, CA51.0448674 -114.1367083
-
Shawnessy LibraryBorrow it333 Shawville Blvd. SE, Calgary, Alberta, T2Y 4H3, CA50.898545 -114.062885
-
Signal Hill LibraryBorrow it5994 Signal Hill Centre SW, Calgary, Alberta, T3H 3P8, CA51.0180759 -114.1755888
-
Southwood LibraryBorrow it924 Southland Drive SW, Calgary, Alberta, T2W 0J9, CA50.963642 -114.0858663
-
Village Square LibraryBorrow it2623 56th Street NE, Calgary, Alberta, T1Y 6E7, CA51.0755508 -113.9526426
Library Links
Embed
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.calgarylibrary.ca/portal/Access-2013-bible-by-Michael-Alexander-Dick/Ry7De5LxfZE/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.calgarylibrary.ca/portal/Access-2013-bible-by-Michael-Alexander-Dick/Ry7De5LxfZE/">Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.calgarylibrary.ca/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.calgarylibrary.ca/">Calgary Public Library</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data - Experimental
Data Citation of the Item Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.calgarylibrary.ca/portal/Access-2013-bible-by-Michael-Alexander-Dick/Ry7De5LxfZE/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.calgarylibrary.ca/portal/Access-2013-bible-by-Michael-Alexander-Dick/Ry7De5LxfZE/">Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource)</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.calgarylibrary.ca/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.calgarylibrary.ca/">Calgary Public Library</a></span></span></span></span></div>