skip to content
Go! with Microsoft Access 2010 comprehensive Preview this item
ClosePreview this item
Checking...

Go! with Microsoft Access 2010 comprehensive

Author: Shelley Gaskin; Carolyn McLellan; Nancy Graviett
Publisher: Upper Saddle River, N.J. : Prentice Hall, ©2011.
Edition/Format:   Print book : CD for computer : EnglishView all editions and formats
Summary:

Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly-defined  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Document Type: Book
All Authors / Contributors: Shelley Gaskin; Carolyn McLellan; Nancy Graviett
ISBN: 9780138007713 0138007713
OCLC Number: 647772307
Notes: Includes index.
Description: xxvii, 765, [30] pages : color illustrations ; 28 cm + 1 CD-ROM (4 3/4 in.)
Contents: GO! with Microsoft Access 2010 ComprehensiveTable of Contents Chapter 1 Getting Started with Access DatabasesScenario: Capital Cities Community CollegeProject 1A: Contact InformationObjective 1: Identify Good Database Design Activity 1.01 Using Good Design Techniques to Plan a DatabaseObjective 2: Create a Table and Define Fields in a New Blank Database Activity 1.02 Starting with a New Blank Database Activity 1.03 Creating Fields in a Table Activity 1.04 Renaming Field in a Table Activity 1.05 Adding a Record to a Table Activity 1.06 Assigning the Data Type of a Field in Datasheet View Activity 1.07 Adding Additional Records to a Table Activity 1.08 Importing Data from an Excel Workbook to an Existing Access TableObjective 3: Add and Change the Structure of Tables Activity 1.09 Deleting a Table Field in Design View Activity 1.10 Modifying a Field Size and Description in Design View Activity 1.11 Setting a Primary Key and Saving a Table Activity 1.12 Adding a Second Table to a Database by Importing an Excel Spreadsheet Activity 1.13 Adjusting Column Widths Activity 1.14 Printing a TableObjective 4: Create and Use a Query, a Form, and a Report Activity 1.15 Using the Simple Query Wizard to Create a Query Activity 1.16 Creating a Form Activity 1.17 Creating, Modifying, and Printing a ReportObjective 5: Save, Close, and Change the Properties of a Database Activity 1.18 Changing Database Properties Activity 1.19 Closing and Saving a DatabaseProject 1B: Student WorkshopsObjective 6: Create a Database Using a Template Activity 1.20 Creating a New Database Using a Template Activity 1.21 Building a Table by Entering Records in a Multiple Items FormObjective 7: Organize Database Objects in the Navigation Pane Activity 1.22 Organizing Database Objects in the Navigation PaneObjective 8: Create a New Table in a Database Created with a Template Activity 1.23 Creating a New Table and Changing Its DesignObjective 9: View a Report and Print a Table in a Database Created with a Template Activity 1.24 Viewing a Report Activity 1.25 Printing a TableChapter 2 Sort and Query a DatabaseScenario: Capital Cities Community CollegeProject 2A: Instructors and CoursesObjective 1: Open an Existing Database Activity 2.01 Opening and Renaming an Existing Database Activity 2.02 Resolving Security Alerts and Renaming TablesObjective 2: Create Table Relationships Activity 2.03 Creating Table Relationships and Enforcing Referential Integrity Activity 2.04 Printing a Relationship ReportObjective 3: Sort Records in a Table Activity 2.05 Sorting Records in a Table in Ascending or Descending Order Activity 2.06 Sorting Records in a Table on Multiple FieldsObjective 4: Create a Query in Design View Activity 2.07 Creating a New Select Query in Design View Activity 2.08 Running, Saving, Printing, and Closing a QueryObjective 5: Create a New Query from an Existing Query Activity 2.09 Creating a New Query from an Existing QueryObjective 6: Sort Query Results Activity 2.10 Sorting Query ResultsObjective 7: Specify Criteria in a Query Activity 2.11 Specifying Text Criteria in a Query Activity 2.12 Specifying Criteria Using a Field Not Displayed in the Query Results Activity 2.13 Using Is Null Criteria to Find Empty FieldsProject 2B: Athletic ScholarshipsObjective 8: Specify Numeric Criteria in a Query Activity 2.14 Opening an Existing Database and Importing a Spreadsheet Activity 2.15 Creating Table Relationships Activity 2.16 Specifying Numeric Criteria in a Query Activity 2.17 Using Comparison Operators Activity 2.18 Using the Between . . . And Comparison OperatorObjective 9: Use Compound Criteria Activity 2.19 Using AND Criteria in a Query Activity 2.20 Using OR Criteria in a QueryObjective 10: Create a Query Based on More Than One Table Activity 2.21 Creating a Query Based on More Than One TableObjective 11: Use Wildcards in a Query Activity 2.22 Using a Wildcard in a QueryObjective 12: Use Calculated Fields in a Query Activity 2.23 Using Calculated Fields in a QueryObjective 13: Calculate Statistics and Group Data in a Query Activity 2.24 Using the MIN, MAX, AVG, and SUM Functions in a Query Activity 2.25 Grouping Data in a Query Chapter 3 Forms, Filters, and ReportsScenario: Capital Cities Community CollegeProject 3A: Students and MajorsObjective 1: Create and Use a Form to Add and Delete Records Activity 3.01 Creating a Form Activity 3.02 Adding Records to a Table by Using a Form Activity 3.03 Deleting Records from a Table by Using a Form Activity 3.04 Printing a FormObjective 2: Create a Form by Using the Form Wizard Activity 3.05 Creating a Form by Using the Form WizardObjective 3: Modify a Form in Design View and in Layout View Activity 3.06 Modifying a Form in Design View Activity 3.07 Adding, Resizing, and Moving Controls in Layout View Activity 3.08 Formatting and Aligning Controls in Layout ViewObjective 4: Filter Records Activity 3.09 Filtering Data by Selection on One Field Activity 3.10 Using Filter By Form Project 3B: Job OpeningsObjective 5: Create a Report by Using the Report Tool Activity 3.11 Creating a Report by Using the Report Tool Activity 3.12 Modifying a Report in Layout ViewObjective 6: Create Reports by Using the Blank Report Tool or the Report Wizard Activity 3.13 Creating a Report by Using the Blank Report Tool Activity 3.14 Creating a Report by Using the Report WizardObjective 7: Modify the Design of a Report Activity 3.15 Modifying a Report in Layout View Activity 3.16 Modifying a Report in Design ViewObjective 8: Keep Data Together in a Printed Report Activity 3.17 Keeping Data Together and Printing a Report Chapter 4 Enhancing TablesScenario: City of Westland PlainsProject 4A Maneuver Data and Enforce Data IntegrityObjective 1 Manage Existing Tables Activity 4.01 Backing Up a Database Activity 4.02 Adding File Locations to Trusted Locations Activity 4.03 Copying a Table and Modifying the Structure Activity 4.04 Appending Records to a Table Activity 4.05 Splitting a Table into Two Tables Activity 4.06 Appending Records from Another Database Objective 2 Modify Existing Tables Activity 4.07 Finding and Deleting Records Activity 4.08 Finding and Modifying Records Activity 4.09 Adding and Moving Fields in Design View and Datasheet View Activity 4.10 Checking Spelling Objective 3 Create and Modify Table Relationships Activity 4.11 Creating Table Relationships and Testing Referential Integrity Activity 4.12 Setting and Testing Cascade Options Project 4B Format Tables and Validate Data EntryObjective 4 Create a table in design view Activity 4.13 Creating a Table in Design ViewObjective 5 Change Data types Activity 4.14 Changing Data Types Objective 6 Create a Lookup Field Activity 4.15 Creating a Lookup Field Based on a List of Values Activity 4.16 Creating a Lookup Field Based on Data in Another TableObjective 7 Set Field Properties Activity 4.17 Creating an Input Mask using the Input Mask Wizard Activity 4.18 Creating an Input Mask using the Input Mask Properties Box Activity 4.19 Specifying a Required Field Activity 4.20 Setting Default Values for Fields Activity 4.21 Indexing Fields in a TableObjective 8 Create Data Validation Rules and Validation Text Activity 4.22 Creating Data Validation Rules and Validation Text Activity 4.23 Testing Table Design and Field PropertiesObjective 9 Attach Files to Records Activity 4.24 Attaching a Word Document to a Record Chapter 5 Enhancing QueriesScenario: Board Anywhere Surf and Snowboard ShopProject 5A Create Special-Purpose QueriesObjective 1 Create Calculated Fields in a Query Activity 5.01 Creating a Calculated Field Based on Two Existing Fields Activity 5.02 Creating a Calculated Field Based on One Existing Field and a NumberObjective 2 Use Aggregate Functions in a Query Activity 5.03 Adding a Total Row to a Query Activity 5.04 Creating a Totals QueryObjective 3 Create a Crosstab Query Activity 5.05 Creating a Select Query as the Source for a Crosstab Query Activity 5.06 Creating a Crosstab QueryObjective 4 Find Duplicate and Unmatched Records Activity 5.07 Finding Duplicate Records Activity 5.08 Finding Unmatched RecordsObjective 5 Create a Parameter Query Activity 5.09 Creating a Parameter Query Using One Criteria Activity 5.10 Creating a Parameter Query Using Multiple Criteria Project 5B Create Action Queries and Modify Join TypesObjective 6 Create a Make Table Query Activity 5.11 Creating a Select Query Activity 5.12 Converting a Select Query to a Make Table QueryObjective 7 Create an Append Query Activity 5.13 Creating an Append Query for a Table in the Current Database Activity 5.14 Creating an Append Query for a Table in Another DatabaseObjective 8 Create a Delete Query Activity 5.15 Creating a Delete QueryObjective 9 Create an Update Query Activity 5.16 Creating an Update Query Activity 5.17 Creating an Update Query with an ExpressionObjective 10 Modify the Join Type Activity 5.18 Viewing the Results of a Query Using an Inner Join Activity 5.19 Changing the Join Type to an Outer Join Chapter 6 Customizing Forms and ReportsScenario: Wild Islands BreezeProject 6A Customize FormsObjective 1 Create a Form in Design View Activity 6.01 Creating a Form in Design View Activity 6.02 Adding Sections to the FormObjective 2 Change and Add Controls Activity 6.03 Changing Controls on a Form Activity 6.04 Adding Controls to a FormObjective 3 Format a Form Activity 6.05 Adding a Background Color Activity 6.06 Adding a Background Picture to a Form Activity 6.07 Modifying the Borders of ControlsObjective 4 Make a Form User Friendly Activity 6.08 Adding a Message to the Status Bar Activity 6.09 Creating Custom ControlTips Activity 6.10 Changing the Tab Order Project 6B Customize ReportsObjective 5 Create a Report Based on a Query Using a Wizard Activity 6.11 Creating a Report Using a Wizard Activity 6.12 Modifying a Report Created Using a WizardObjective 6 Create a Report in Design View Activity 6.13 Creating a Report in Design view Activity 6.14 Modifying the Sections of a ReportObjective 7 Add Controls to a Report Activity 6.15 Adding Label and Text Box Controls to a Report Activity 6.16 Adding an Image Control and a Line Control to a ReportObjective 8 Group, Sort, and Total Records in Design View Activity 6.17 Adding a Grouping and Sort Level to a Report Activity 6.18 Adding Calculated Controls to a Report Chapter 7 Creating Advanced Forms and ReportsScenario: Southwest GardensProject 7A Create Advanced FormsObjective 1 Create a Split Form Activity 7.01 Creating a Split Form Using the Split Form Tool Activity 7.02 Formatting a Split Form Activity 7.03 Converting an Existing Form into a Split formObjective 2 Create a Form and a Subform Activity 7.04 Creating a Form and a Subform Using the Form Tool Activity 7.05 Creating a Form and a Subform Using the Form Wizard Activity 7.06 Creating a Subform by Dragging a Related Table On to an Existing FormObjective 3 Create a Multi-Page Form Activity 7.07 Creating a Multi-Page Form Using the Tab Control Project 7B Create Advanced ReportsObjective 4 Create and Modify a Subreport Activity 7.08 Using the Subreport Wizard to Create a Subreport Activity 7.09 Modifying a Subreport Activity 7.10 Creating a Subreport by Adding an Object to an Existing Report Activity 7.11 Displaying a Total from a Subreport on the Main ReportObjective 5 Create a Report Based on a Parameter Query Activity 7.12 Creating a Report Based on a Parameter Query Activity 7.13 Printing the Parameters in the ReportObjective 6 Create an Alphabetic Index Activity 7.14 Creating an Alphabetic Index Chapter 8 Creating Macros, PivotTables, and PivotChartsScenario: Providence and Warwick HospitalProject 8A Create and Modify MacrosObjective 1 Create a Standalone Macro with One Action Activity 8.01 Creating a Standalone Macro Activity 8.02 Opening a Form in Its Own Window Activity 8.03 Creating a Second Standalone Macro that Automatically ExecutesObjective 2 Add Multiple Actions to a Standalone Macro Activity 8.04 Adding Multiple Actions to an Existing Standalone MacroObjective 3 Create a Macro Group Activity 8.05 Creating the First Macro in a Macro Group Activity 8.06 Creating a Second Macro in a Macro Group Activity 8.07 Creating a Third Macro in a Macro GroupObjective 4 Associate a Macro with an Event Activity 8.08 Associating a Command Button with a MacroObjective 5 Create an Embedded Macro Activity 8.09 Creating an Embedded MacroObjective 6 Print Macro Details Activity 8.10 Printing Macro DetailsProject 8B Create and Modify PivotTables and PivotChartsObjective 7 Create a PivotTable from a Query Activity 8.11 Creating a PivotTable from a Query Activity 8.12 Pivoting the Data and Adding Totals Activity 8.13 Removing Fields from and Adding Fields to the PivotTableObjective 8 Create a PivotChart from a PivotTable Activity 8.14 Creating a PivotChart from a PivotTable Chapter 9 Integrating Access with Other ApplicationsScenario: Penn Liberty MotorsProject 9A Import Data from and Link Data to Other Office Applications; Create Memos using Mail MergeObjective 1 Import Data from a Word Table Activity 9.01 Preparing a Word Table for Importing Activity 9.02 Importing Data from a Word TableObjective 2 Import Data from an Excel Workbook Activity 9.03 Importing Data from an Excel Worksheet Activity 9.04 Appending Data from Excel to a TableObjective 3 Insert an Excel Chart into a Report Activity 9.05 Create a Query and a Report Activity 9.06 Inserting an Excel Chart into a ReportObjective 4 Import from and Link to Another Access Database Activity 9.07 Importing Data from Another Access Database Activity 9.08 Linking to a Table in Another Access Database Project 9B Export Data to Office Applications, to HTML, and to XML filesObjective 5 Export Data to Word Activity 9.09 Exporting an Access Query to Word Activity 9.10 Exporting and Access Report to WordObjective 6 Use Mail Merge to Integrate Access and WordActivity 9.11 Merging an Access Table with a Word DocumentObjective 7 Export Data to Excel Activity 9.12 Exporting Selected Records to Excel Activity 9.13 Copying Selected Records to an Existing WorkbookObjective 8 Export Data to an HTML File and an XML File Activity 9.14 Exporting a Report to an HTML File Activity 9.15 Exporting a Report to an XML File Chapter 10 Administering DatabasesScenario: Image MedtechProject 10A Manage Access FilesObjective 1 Compact and Repair a Database Activity 10.01 Compacting and Repairing a DatabaseObjective 2 Back Up a Database Activity 10.02 Backing Up a DatabaseObjective 3 Convert Databases to a Previous Version Activity 10.03 Converting to a 2002-2003 DatabaseObjective 4 Replicate and Synchronize a Database Activity 10.04 Creating a Replica of a Database Activity 10.05 Synchronizing a DatabaseProject 10B Improve performance and Customize AccessObjective 6 Use Microsoft Access Analysis Tools Activity 10.06 Using the Table Analyzer Activity 10.07 Using the Performance Analyzer Activity 10.08 Viewing Object Dependencies Activity 10.09 Using the Database DocumenterObjective 7 Add Smart Tags Activity 10.10 Adding Smart TagsObjective 8 Modify Access Views and Behaviors Activity 10.11 Modifying Access Options Activity 10.12 Customizing the Quick Access Toolbar Activity 10.13 Setting Current Database Options Activity 10.14 Customizing the Navigation PaneChapter 11 Securing Databases and Writing SQL StatementsScenario: Rennier Law PartnersProject 11A Secure Access DatabasesObjective 1 Utilize the Trust Center Activity 11.01 Viewing Trust Center OptionsObjective 2 Use the Database Splitter Activity 11.02 Splitting a DatabaseObjective 3 Encrypt and Decrypt Databases Activity 11.03 Encrypting a Database with a Password Activity 11.04 Decrypting a Database with a PasswordObjective 4 Create a Locked Database (ACCDE File) Activity 11.05 Creating a Secure ACCDE File Project 11B Write SQL StatementsObjective 5 Modify a Query in SQL View Activity 11.06 Modifying a Query in SQL ViewObjective 6 Create a Query in SQL View Activity 11.07 Creating SQL Statements Activity 11.08 Specifying the Join Type in SQLObjective 7 Create a Union Query Using SQL Activity 11.09 Creating a Union Query in SQL View Objective 8 Create Calculated Fields and SQL Aggregate Functions Activity 11.10 Creating Calculated Fields in SQL Activity 11.11 Writing SQL Aggregate Functions
Other Titles: Microsoft Access 2010 comprehensive
Responsibility: Shelley Gaskin, Carolyn McLellan, and Nancy Graviett.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/647772307> # Go! with Microsoft Access 2010 comprehensive
    a schema:Book, bgn:CD, schema:CreativeWork ;
   library:oclcnum "647772307" ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/3860463470#Place/upper_saddle_river_n_j> ; # Upper Saddle River, N.J.
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
   schema:about <http://id.worldcat.org/fast/1093575> ; # Relational databases
   schema:about <http://experiment.worldcat.org/entity/work/data/3860463470#CreativeWork/microsoft_access> ; # Microsoft Access.
   schema:about <http://dewey.info/class/005.7565/e22/> ;
   schema:about <http://id.worldcat.org/fast/1371910> ; # Microsoft Access.
   schema:alternateName "Microsoft Access 2010 comprehensive" ;
   schema:bookFormat bgn:PrintBook ;
   schema:contributor <http://viaf.org/viaf/136281591> ; # Carolyn McLellan
   schema:contributor <http://viaf.org/viaf/6750213> ; # Nancy Graviett
   schema:copyrightYear "2011" ;
   schema:creator <http://viaf.org/viaf/274790590> ; # Shelley Gaskin
   schema:datePublished "2011" ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/3860463470> ;
   schema:inLanguage "en" ;
   schema:name "Go! with Microsoft Access 2010 comprehensive"@en ;
   schema:productID "647772307" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/647772307#PublicationEvent/upper_saddle_river_n_j_prentice_hall_2011> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/3860463470#Agent/prentice_hall> ; # Prentice Hall
   schema:workExample <http://worldcat.org/isbn/9780138007713> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/647772307> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/3860463470#Place/upper_saddle_river_n_j> # Upper Saddle River, N.J.
    a schema:Place ;
   schema:name "Upper Saddle River, N.J." ;
    .

<http://id.worldcat.org/fast/1093575> # Relational databases
    a schema:Intangible ;
   schema:name "Relational databases"@en ;
    .

<http://id.worldcat.org/fast/1371910> # Microsoft Access.
    a schema:CreativeWork ;
   schema:name "Microsoft Access." ;
    .

<http://viaf.org/viaf/136281591> # Carolyn McLellan
    a schema:Person ;
   schema:familyName "McLellan" ;
   schema:givenName "Carolyn" ;
   schema:name "Carolyn McLellan" ;
    .

<http://viaf.org/viaf/274790590> # Shelley Gaskin
    a schema:Person ;
   schema:familyName "Gaskin" ;
   schema:givenName "Shelley" ;
   schema:name "Shelley Gaskin" ;
    .

<http://viaf.org/viaf/6750213> # Nancy Graviett
    a schema:Person ;
   schema:familyName "Graviett" ;
   schema:givenName "Nancy" ;
   schema:name "Nancy Graviett" ;
    .

<http://worldcat.org/isbn/9780138007713>
    a schema:ProductModel ;
   schema:isbn "0138007713" ;
   schema:isbn "9780138007713" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.