skip to content
Microsoft Office Access 2007 comprehensive Preview this item
ClosePreview this item
Checking...

Microsoft Office Access 2007 comprehensive

Author: Robert T Grauer; Maurie Wigman Lockley; Keith Mulbery
Publisher: Upper Saddle River, N.J. : Pearson Prentice Hall, ©2008.
Series: Exploring series
Edition/Format:   Print book : English
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

Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Robert T Grauer; Maurie Wigman Lockley; Keith Mulbery
ISBN: 9780131567887 0131567888
OCLC Number: 145146728
Description: xxviii, 707 pages : color illustrations ; 28 cm.
Contents: >Chapter 1 - Introduction to Access: Finding Your Way through a Database Section 1: Data and Files Everywhere! Exploring, Describing, and Navigating Among the Objects in an Access Database Understanding the Difference Between Working in Storage and Memory Practicing Good File Management Backing up, Compacting, and Repairing Access Files Hands-On Exercises 1 Introduction to Databases Section 2: Filters, Sorts, and Access Versus Excel Creating Filters Sorting Table Data on One or More Fields Knowing When to Use Access or Excel to Manage Data Hands-On Exercises 2: Data Manipulation: Filters and Sorts Section 3: The Relational Database Using the Relationship Window Understanding Relational Power Hands-On Exercises 3: Introduction to Relationships Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Chapter 2 - Relational Databases and Multi-Table Queries: Designing Databases and Using Section 1: Related Data Table Design, Properties, Views, and Wizards Designing Data Creating Tables Hands-On Exercises 1: Table Design, Properties, Views, and Wizards Section 2: Multiple Table Database Understanding Table Relationships Sharing Data with Excel Establishing Table Relationships Hands-on Exercises 2: Imports and Relationships Section 3: Queries Creating a Query Specifying Criteria for Different Data Types Copying and Running a Query Using the Query Wizard Understanding Large Database Differences Hands-On Exercises 3: Multi-Table Query Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Chapter 3 - Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions Section 1: Data Summary and Analysis Understanding the Order of Precedence Creating a Calculated Field in a Query Hands-On Exercises 1: Calculated Query Fields Section 2: Expression Builder Creating Expressions with the Expression Builder Creating and Editing Access Functions Performing Date Arithmetic Hands-On Exercises 2: Expression Builder, Functions, and Date Arithmetic Section 3: Data Aggregates Creating and Working with Data Aggregates Hands-On Exercises 3: Data Aggregates Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Chapter 4 - Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports Section 1: Appearance Matter Planning Reports Using Different Report Views Creating and Editing a Report Hands-On Exercises 1: Introduction to Access Reports Section 2: The Anatomy of a Report Identifying Report Elements, Sections and Controls Adding Grouping Levels Using the Layout View Adding Fields to a Report Hands-On Exercises 2: Create, Sort, Edit, Nest and Remove Groups from Reports Section 3: The Report and Label Wizard Using the Report Wizard Hands-On Exercises 3: Report Wizard Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Chapter 5 - Pivot Tables and Charts Section 1 Data Mining Create a PivotTable view Calculate aggregate statistics Modify a PivotTable Hands-on Exercise 1: Create and Use a PivotTable Section 2 Charts Convey Information Select an appropriate chart type Identify chart elements Edit a PivotChart Hands-on Exercise 2: PivotCharts and Modifications Section 3 Calculations in PivotTables and PivotCharts Create calculations in a PivotTable Hands-on Exercise 3: 3 Calculating Field Values in PivotTables Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Chapter 6 - Data Protection: Integrity, Validation, Reliability Section 1 Data Validity Establish Data Validity Create a Lookup Modify a Lookup by Adding and Deleting Values Create and Modify a Multivalue Lookup Field Work with Input Masks Hands-on Exercise 1: Data Protection Section 2 Forms Create Forms Using the Forms Tools Hands-on Exercise 2: Form Creation Tools Section 3 Form Customization Create Custom Forms Using Design View Add Action Buttons and Combo Box Controls Create Subforms Fashion Functional Formats Hands-on Exercise 3: Customizing Forms Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Chapter 7 - Advanced Queries: Using Queries to Change Data Section 1 Action Queries Maintain a Database Understand Action Queries Create an Update Query Use a Make table Query Create a Delete Query Hands-on Exercise 1: 1 Create an Update Query Section 2 Advanced Queries Construct Crosstab Queries Work with Parameter Queries Create Find Unmatched Queries Understand Find Duplicate Queries Hands-On Exercise 2: Advanced Queries Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Chapter 8 - Get Connected: Exchanging Data Between Access and Other Applications Section 1 Access and the World Wide Web Create a Hyperlinked Field Edit a Hyperlinked Field Add and Use Table Attachment Fields Hands-on Exercise 1: Make Connections Section 2 Data Connections Add and Use Attachment Fields in Forms and Reports Export Objects as HTML Files Import and Link to HTML Files Share XML Data Share Data with Excel Hands-on Exercise 2: 2 Share Data Section 3 E-Mail Management with Access and Outlook Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Chapter 9 - Bulletproofing the Database Section 1 Data Protection Managing and Securing the Data Hands-on Exercise 1: Managing and Securing the Data Using Analysis Tools to Improve Database Performance and Documentation Moving Data to New Database Files Hands-on Exercise 2: Using Database Tools Section 2 Table Design Goals: Efficient Accurate and ScalableAnalyzing and Optimizing Object Relationships in an Access Database Section 3 Helping Database Users Create Usable Switchboards Hands-on Exercise 3: The Switchboard Manager Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Chapter 10 - Customizing a database with macros and Visual Basic for Applications Section 1 Programming with Macros Understanding the purpose for macros in Access Creating embedded macros using Wizards Creating macros using the Macro Builder Assigning macros to events Using conditions to control macro actions Hands-On Exercises 1: Customizing a database using macros Section 2 Understanding database programming with Visual Basic for Applications (VBA) Using the Visual Basic Editor Creating procedures Declaring Variables Using decision structures Using repetition structures Managing data using Recordsets Hands-On Exercise 2: Customizing a database using VBA Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases
Series Title: Exploring series
Responsibility: Robert T. Grauer, Maurie Wigman Lockley, Keith Mulbery.
More information:

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/145146728> # Microsoft Office Access 2007 comprehensive
    a schema:Book, schema:CreativeWork ;
   library:oclcnum "145146728" ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/3805408466#Place/upper_saddle_river_n_j> ; # Upper Saddle River, N.J.
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/3805408466#CreativeWork/microsoft_access> ; # Microsoft Access.
   schema:about <http://id.worldcat.org/fast/888037> ; # Database management
   schema:about <http://id.worldcat.org/fast/1371910> ; # Microsoft Access.
   schema:about <http://dewey.info/class/005.7585/e22/> ;
   schema:bookFormat bgn:PrintBook ;
   schema:contributor <http://viaf.org/viaf/57848335> ; # Keith Mulbery
   schema:contributor <http://viaf.org/viaf/1918953> ; # Maurie Wigman Lockley
   schema:copyrightYear "2008" ;
   schema:creator <http://viaf.org/viaf/71545260> ; # Robert T. Grauer
   schema:datePublished "2008" ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/3805408466> ;
   schema:inLanguage "en" ;
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/3805408466#Series/exploring_series> ; # Exploring series
   schema:name "Microsoft Office Access 2007 comprehensive"@en ;
   schema:productID "145146728" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/145146728#PublicationEvent/upper_saddle_river_n_j_pearson_prentice_hall_2008> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/3805408466#Agent/pearson_prentice_hall> ; # Pearson Prentice Hall
   schema:url <http://catdir.loc.gov/catdir/toc/ecip0720/2007025033.html> ;
   schema:workExample <http://worldcat.org/isbn/9780131567887> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/145146728> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/3805408466#Agent/pearson_prentice_hall> # Pearson Prentice Hall
    a bgn:Agent ;
   schema:name "Pearson Prentice Hall" ;
    .

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

<http://experiment.worldcat.org/entity/work/data/3805408466#Series/exploring_series> # Exploring series
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/145146728> ; # Microsoft Office Access 2007 comprehensive
   schema:name "Exploring series" ;
    .

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

<http://id.worldcat.org/fast/888037> # Database management
    a schema:Intangible ;
   schema:name "Database management"@en ;
    .

<http://viaf.org/viaf/1918953> # Maurie Wigman Lockley
    a schema:Person ;
   schema:familyName "Lockley" ;
   schema:givenName "Maurie Wigman" ;
   schema:name "Maurie Wigman Lockley" ;
    .

<http://viaf.org/viaf/57848335> # Keith Mulbery
    a schema:Person ;
   schema:familyName "Mulbery" ;
   schema:givenName "Keith" ;
   schema:name "Keith Mulbery" ;
    .

<http://viaf.org/viaf/71545260> # Robert T. Grauer
    a schema:Person ;
   schema:birthDate "1945" ;
   schema:familyName "Grauer" ;
   schema:givenName "Robert T." ;
   schema:name "Robert T. Grauer" ;
    .

<http://worldcat.org/isbn/9780131567887>
    a schema:ProductModel ;
   schema:isbn "0131567888" ;
   schema:isbn "9780131567887" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

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