skip to content
Microsoft Office Access 2007 : the complete reference Preview this item
ClosePreview this item
Checking...

Microsoft Office Access 2007 : the complete reference

Author: Virginia Andersen
Publisher: New York : McGraw-Hill, ©2007.
Edition/Format:   Print book : CD for computer : Program   Computer File : EnglishView all editions and formats
Summary:
The Ultimate Microsoft Office Access 2007 Resource Build a highly responsive a database so you can track, report, and share information and make more informed decisions. This comprehensive resource shows you how to design and develop custom Access 2007 databases--even if you have little or no programming experience. You'll learn to collect data from a variety of sources, share it securely with others, and integrate  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

Material Type: Program, Internet resource
Document Type: Book, Computer File, Internet Resource
All Authors / Contributors: Virginia Andersen
ISBN: 0072263504 9780072263503
OCLC Number: 74966300
Notes: Includes index.
ODL_2017/2018.
Description: xxiv, 775 pages : illustrations ; 23 cm + 1 CD-ROM (4 3/4 in.)
Details: System requirements for accompanying CD-ROM: Acrobat Reader.
Contents: Cover --
Contents --
Acknowledgments --
Introduction --
Part I: Getting Started --
1 Quick Tour of Microsoft Office Access 2007 --
Starting Access and Opening a Database --
Looking at a Table --
Looking at the Wizards --
Getting Help --
Summary --
2 The World of Relational Databases --
What is a Relational Database? --
Defining Database Objects --
Inspecting the Sample Database --
The Payoff --
Summary --
3 Creating a Database --
Designing the Database --
Introducing Home Tech Repair --
Creating a Database from a Template --
Running the New Application --
Starting with a Blank Database --
Summary --
4 Creating and Modifying Tables --
Creating a New Table from a Template --
Creating a New Table in Datasheet View --
Creating a New Table in Design View --
Modifying the Table Design --
Ensuring Data Validity --
Copying an Existing Table Structure --
Setting Table Properties --
Summary --
5 Relating Tables --
Defining a Relationship --
Viewing and Editing Relationships --
Printing the Relationships --
Summary --
6 Entering and Editing Data --
Entering New Data --
Customizing Data Entry --
Changing the Datasheet Appearance --
Changing a Table Definition --
Editing Record Data --
Printing Table Data --
Summary --
Part II: Retrieving and Presenting Information --
7 Sorting, Filtering, and Printing Records --
Sorting Records --
Filtering Records --
Printing Table Data --
Summary --
8 Extracting Information with Queries --
How Do Queries Work? --
Creating Select Queries --
Adding Selection Criteria --
Setting Query Properties --
Modifying a Query --
Performing Calculations in a Query --
Creating Special Queries with the Query Wizard --
Printing the Query Results --
Deleting a Query --
Summary --
9 Creating Advanced Queries --
Creating Special Purpose Queries --
Designing Action Queries --
Introducing Structured Query Language --
Creating a Subquery --
Summary --
10 Creating Form and Report Designs --
Deciding the Database Object Type --
Common Design Elements --
Working in the Design Window --
Modifying Form Sections and Controls --
Deleting Controls --
Adding Other Objects and Special Effects --
Changing Form and Report Properties --
Summary --
11 Using the Form Tools --
Creating a New Form Design --
Using the Form Wizard --
Modifying the Form Design --
Using the Form for Data Entry --
Printing the Form --
Looking at the Other Wizards --
Creating a Hierarchical Form from Related Tables --
Summary --
12 Customizing Forms --
Starting a New Custom Form --
Creating a Multiple-Page Form --
Adding Special Controls --
Introducing the Police Database --
Adding a Subform --
Adding Custom Help --
Validating or Restricting Data in Forms --
Summary --
13 Using the Report Wizard --
Creating a New Report Design --
Previewing the Report --
Printing the Report --
Modifying the Report Design --
Saving the Report Design --
Using Report Snapshots --
Summary --
14 Customizing Reports --
Creating a New Report Design --
Filtering, Sorting, and Grouping Records in Layout View --
Adding a Subreport --
Designing a Multiple-Column Report --
Printing Maili.
Responsibility: Virginia Andersen.
More information:

Abstract:

Suitable for Microsoft Office Access 2007 users, this resource covers various features of the software and explains how to design, build, and maintain custom Access databases.  Read more...

Reviews

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

Tags

Be the first.

Similar Items

Related Subjects:(3)

User lists with this item (3)

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/74966300> # Microsoft Office Access 2007 : the complete reference
    a bgn:CD, schema:Book, schema:CreativeWork ;
   library:oclcnum "74966300" ;
   library:placeOfPublication <http://dbpedia.org/resource/New_York_City> ; # New York
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nyu> ;
   rdfs:comment "Unknown 'gen' value: pgm" ;
   schema:about <http://dewey.info/class/005.7565/e22/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/802616684#CreativeWork/microsoft_access> ; # Microsoft Access.
   schema:about <http://id.worldcat.org/fast/1371910> ; # Microsoft Access.
   schema:about <http://experiment.worldcat.org/entity/work/data/802616684#Topic/administradores_de_bases_de_datos> ; # Administradores de bases de datos
   schema:about <http://id.worldcat.org/fast/888037> ; # Database management
   schema:bookFormat bgn:PrintBook ;
   schema:copyrightYear "2007" ;
   schema:creator <http://viaf.org/viaf/54329344> ; # Virginia Andersen
   schema:datePublished "2007" ;
   schema:description "The Ultimate Microsoft Office Access 2007 Resource Build a highly responsive a database so you can track, report, and share information and make more informed decisions. This comprehensive resource shows you how to design and develop custom Access 2007 databases--even if you have little or no programming experience. You'll learn to collect data from a variety of sources, share it securely with others, and integrate it with other Office applications. Filled with detailed, easy-to-follow instructions, Microsoft Office Access 2007: The Complete Reference shows you how to take full advantage of all the new features, including the new ribbon user interface and navigation pane, new field types, and more. Create a reliable and versatile information management solution with help from this all-inclusive guide. As a bonus, you can gain hands-on experience by following along with the book's sample databases on the CD-ROM. Customize the user interface to suit your preferences Use the built-in database templates or design your own Create, modify, and relate tables Enter and edit data Write advanced queries to extract and manipulate information Create customized forms and reports Improve performance and back up your database Develop macros to carry out automated responses to user actions Import, link, and export data Enable a multiple-user environment Secure your database --Publisher."@en ;
   schema:description "Cover -- Contents -- Acknowledgments -- Introduction -- Part I: Getting Started -- 1 Quick Tour of Microsoft Office Access 2007 -- Starting Access and Opening a Database -- Looking at a Table -- Looking at the Wizards -- Getting Help -- Summary -- 2 The World of Relational Databases -- What is a Relational Database? -- Defining Database Objects -- Inspecting the Sample Database -- The Payoff -- Summary -- 3 Creating a Database -- Designing the Database -- Introducing Home Tech Repair -- Creating a Database from a Template -- Running the New Application -- Starting with a Blank Database -- Summary -- 4 Creating and Modifying Tables -- Creating a New Table from a Template -- Creating a New Table in Datasheet View -- Creating a New Table in Design View -- Modifying the Table Design -- Ensuring Data Validity -- Copying an Existing Table Structure -- Setting Table Properties -- Summary -- 5 Relating Tables -- Defining a Relationship -- Viewing and Editing Relationships -- Printing the Relationships -- Summary -- 6 Entering and Editing Data -- Entering New Data -- Customizing Data Entry -- Changing the Datasheet Appearance -- Changing a Table Definition -- Editing Record Data -- Printing Table Data -- Summary -- Part II: Retrieving and Presenting Information -- 7 Sorting, Filtering, and Printing Records -- Sorting Records -- Filtering Records -- Printing Table Data -- Summary -- 8 Extracting Information with Queries -- How Do Queries Work? -- Creating Select Queries -- Adding Selection Criteria -- Setting Query Properties -- Modifying a Query -- Performing Calculations in a Query -- Creating Special Queries with the Query Wizard -- Printing the Query Results -- Deleting a Query -- Summary -- 9 Creating Advanced Queries -- Creating Special Purpose Queries -- Designing Action Queries -- Introducing Structured Query Language -- Creating a Subquery -- Summary -- 10 Creating Form and Report Designs -- Deciding the Database Object Type -- Common Design Elements -- Working in the Design Window -- Modifying Form Sections and Controls -- Deleting Controls -- Adding Other Objects and Special Effects -- Changing Form and Report Properties -- Summary -- 11 Using the Form Tools -- Creating a New Form Design -- Using the Form Wizard -- Modifying the Form Design -- Using the Form for Data Entry -- Printing the Form -- Looking at the Other Wizards -- Creating a Hierarchical Form from Related Tables -- Summary -- 12 Customizing Forms -- Starting a New Custom Form -- Creating a Multiple-Page Form -- Adding Special Controls -- Introducing the Police Database -- Adding a Subform -- Adding Custom Help -- Validating or Restricting Data in Forms -- Summary -- 13 Using the Report Wizard -- Creating a New Report Design -- Previewing the Report -- Printing the Report -- Modifying the Report Design -- Saving the Report Design -- Using Report Snapshots -- Summary -- 14 Customizing Reports -- Creating a New Report Design -- Filtering, Sorting, and Grouping Records in Layout View -- Adding a Subreport -- Designing a Multiple-Column Report -- Printing Maili."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/802616684> ;
   schema:inLanguage "en" ;
   schema:name "Microsoft Office Access 2007 : the complete reference"@en ;
   schema:productID "74966300" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/74966300#PublicationEvent/new_york_mcgraw_hill_2007> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/802616684#Agent/mcgraw_hill> ; # McGraw-Hill
   schema:url <http://catdir.loc.gov/catdir/toc/ecip078/2007000657.html> ;
   schema:workExample <http://worldcat.org/isbn/9780072263503> ;
   umbel:isLike <http://bnb.data.bl.uk/id/resource/GBA691781> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/74966300> ;
    .


Related Entities

<http://dbpedia.org/resource/New_York_City> # New York
    a schema:Place ;
   schema:name "New York" ;
    .

<http://experiment.worldcat.org/entity/work/data/802616684#Topic/administradores_de_bases_de_datos> # Administradores de bases de datos
    a schema:Intangible ;
   schema:name "Administradores de bases de datos"@en ;
    .

<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/54329344> # Virginia Andersen
    a schema:Person ;
   schema:familyName "Andersen" ;
   schema:givenName "Virginia" ;
   schema:name "Virginia Andersen" ;
    .

<http://worldcat.org/isbn/9780072263503>
    a schema:ProductModel ;
   schema:isbn "0072263504" ;
   schema:isbn "9780072263503" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

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