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

Resource Information

The instance Access 2013 bible, by Michael Alexander, Dick Kusleika, (electronic resource) represents a material embodiment of a distinct intellectual or artistic creation found in Calgary Public Library. This resource is a combination of several types including: Instance, Electronic.

Image

https://secure.syndetics.com/index.aspx?type=xw12&client=calgp&isbn=9781118491546&upc=&oclc=%28OCoLC%29836401060/LC.JPG

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

Medium

electronic resource

Statement of responsibility

by Michael Alexander, Dick Kusleika

Instantiates

• Access 2013 bible

Publication

• New York, Wiley, 2013

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.)

Record ID

u865751

Specific material designation

remote

System control number

(OCoLC)836401060