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

Microsoft Access 2007

Author: S E Slack
Publisher: Harlow, England ; New York : Prentice Hall, 2007.
Series: Brilliant pocket books series
Edition/Format:   Print book : EnglishView all editions and formats
Summary:
Short, easy-to-follow tutorials help the reader to instantly grasp the essential functions of Access, including importing data from other programs and using forms, filters, queries and reports to capture and analyse data.
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: S E Slack
ISBN: 9780132059244 013205924X
OCLC Number: 123374223
Description: xiii, 284 pages : illustrations ; 22 cm.
Contents: Introduction 1. What's New in Access 2007 * Using The Ribbon * Taking Advantage of the Quick Access Toolbar * Working with the Navigation Pane * Other New Tools and Features to Watch For 2. Access 2007 Fundamentals * Opening Access * Function Keys * View Options * Saving in Access * Exiting Access 3. Understanding Access 2007 * Databases and Objects * Tables * Forms * Queries * Reports * Macros * Modules * The Sandbox Operating Mode * Changing the Registry Key 4. The New File Format * Understanding the New File Format * Converting a Database into an Access 2007 File 5. Database Fundamentals * Understanding Databases * Designing a Database * Setting Up Primary Categories * Adding Subcategories * Choosing Primary Keys * Establishing Table Relationships * Analysingthe Design 6. Creating a Database * Creating a New, Blank Database * Creating a Database from a Template * Opening an Existing Database * Copying a Database * Closing a Database 7. Publishing a Database to a Sharepoint Site * What Are Sharepoint Services? 8. Finding Information in Your Database * Finding Words or Phrases * Replacing Words or Phrases 9. Collecting Information Using Outlook 2007 * When to Use Electronic Data Collection * Things to Know Before You Collect Electronic Data * Collecting Data Via the E-Mail * Managing Your Data Collection Replies 10. Table Relationships and Design * Understanding Table Relationships * Creating a Table Relationship * Changing a Table Relationship * Deleting a Table Relationship * Designing a Table 11. Creating Tables * Creating a New, Blank Table in an Existing Template * Creating a Table from a Template * Creating a Table with Links or Imported Information * Entering Data in a Table * Setting Table Properties * Setting the Primary Key for a Table * Removing the Primary Key for a Table 12. Copying or Exporting Table Data * Copying Data from Another Source into Your Table * Exporting a Table to a Sharepoint Site 13. Editing Tables * Changing Column Width * Changing the Row Height * Changing Font Style and Size * Freezing a Column * Changing the Look and Feel of Your Table * Deleting Records 14. Saving, Closing or Deleting a Table * Saving a Table * Closing a Table * Deleting a Table 15. Using Fields in a Table * Inserting a New Field into a New Table * Inserting a New Field into an Existing Table * Adding an Existing Field to a Table * Changing a Field's Content * Deleting a Field * Moving or Copying Data in a Field * Hiding or Unhiding a Field * Setting Field Properties 16. Working with Lookup Columns * What is a Lookup Column? * Lookup Field Properties * Creating a Lookup Column Using the Lookup Wizard * Changing a Lookup Column * Changing a Field to a Lookup Column 17. Using Forms * Understanding Forms * Form Wizard * Entering Data into a Form 18. Creating Forms * Creating a Form Using the Form Tool * Creating a Form Using the Split Form Tool * Creating a Form with the Blank Form Tool * Creating a Form That Contains a Sub Form * Adding a Logo to Your Form 19. Working with Field Controls * What Are Field Controls? * Moving Field Controls * Changing the Size of a Control 20. Adding Special Controls * Using Windows Visual Theme In Controls * Adding Text Box Controls * Creating a List Box or Combo Box * Creating a Calculated Control * Creating a Command Button * Creating an Option Group * Inserting Date and Time into a Form or Report 21. Using Expressions * Understanding Expressions * Creating an Expression Using the Expression Builder 22. Using Conditional Formatting * Applying Conditional Formatting to a Control Based on its Own Value * Using an Expression to Apply Conditional Formatting to Controls * Changing the Conditional Formatting of a Focus Control * Removing Conditional Formatting 23. Sorting and Finding Data * The Difference Between Sorting and Filtering * Sorting a Table, Query or Form * Sorting Records in Case-Sensitive Order * Sorting Records in a Customised Order * Sorting Records Based on Numeric Values Stored in a Text Field * Sorting Records by Date Values 24. Using Filters * Understanding Filters * Filtering Table Data by Selection * Applying Advanced Filters * Saving Filters as Queries 25. Reporting Fundamentals * Understanding Report Sections * Choosing Record Sources for Your Report * Using Totals, Averages, Percentages or Running Sums in Reports 26. Creating a Report * Creating a Report Using the Report Wizard * Creating a Report Using the Report Tool * Creating a Report Using the Blank Report Tool * Creating and Using Subreports * Creating a Grouped or Summary Report 27. Saving or Editing a Report * Modifying Your Report in the Layout View * Modifying Your Report in the Design View * Creating Alternating Row Colours 28. Previewing, Printing and E-Mailing A Report * Viewing Your Report * Printing Your Report * E-Mailing Your Report 29. Creating a Query * Understanding Queries * Creating a Select Query Using the Query Wizard * Creating a Union Query * Creating and Running an Update Query * Creating and Running an Append Query * Creating a Make Table Query 30. Adding to a Query * Adding Criteria to a Query * Adding Calculations to a Query 31. Editing a Query * Editing Data in a Query * Finding, Hiding or Eliminating Duplicate Data 32. Summarizing and Saving Queries * Summarizing Query Values * Saving the Query Results 33. Joining Tables and Queries * Using Inner Joins * Using Outer Joins * Using Cross Joins * Using Unequal Joins * Removing a Join 34. Using Multivalued Fields in a Query * Displaying a Multivalued Field in a Query * Displaying a Bound Value in a Query * Searching for More Than One Query in a Multivalued Field * Using a Query as a Mailmerge Source 35. Working with Attachments * Adding an Attachment Field to a Table * Attaching A Field Directly to a Table * Using Attachments with Forms and Reports * Saving Attached Files to Other Locations * Removing Attached Files 36. Importing and Exporting * Understanding Importing and Exporting Operations * Running, Saving and Scheduling an Import Operation as a Specification 37. Printing in Access * Printing an Access File * Printing in Landscape Orientation * Creating and Printing Labels * Customising Labels 38. Using Macros * Understanding Macros * New Macro Features in Access 2007 * Creating a Macro * Fixing a Macro * Enabling or Disabling Macros 39. Working with Security Settings * The Trust Center * Adding or Removing A Developer from a Trusted Location * Changing a Trusted Location * Encrypting Your Database * Opening an Encrypted Database * Removing a Password from an Encrypted Database * Using the Package-and-Sign Feature
Series Title: Brilliant pocket books series
Responsibility: S.E. Slack.

Abstract:

Short, easy-to-follow tutorials help the reader to instantly grasp the essential functions of Access, including importing data from other programs and using forms, filters, queries and reports to  Read more...

Reviews

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

Tags

Be the first.

Similar Items

Related Subjects:(1)

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/123374223> # Microsoft Access 2007
    a schema:CreativeWork, schema:Book ;
    library:oclcnum "123374223" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
    library:placeOfPublication <http://dbpedia.org/resource/New_York_City> ; # New York
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/3901056519#Place/harlow_england> ; # Harlow, England
    schema:about <http://id.worldcat.org/fast/1371910> ; # Microsoft Access.
    schema:about <http://dewey.info/class/005.7565/e22/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/3901056519#CreativeWork/microsoft_access> ; # Microsoft Access.
    schema:bookFormat bgn:PrintBook ;
    schema:creator <http://viaf.org/viaf/26498533> ; # Sally E. Slack
    schema:datePublished "2007" ;
    schema:description "Short, easy-to-follow tutorials help the reader to instantly grasp the essential functions of Access, including importing data from other programs and using forms, filters, queries and reports to capture and analyse data."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/3901056519> ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/3901056519#Series/brilliant_pocket_books_series> ; # Brilliant pocket books series
    schema:name "Microsoft Access 2007"@en ;
    schema:productID "123374223" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/123374223#PublicationEvent/harlow_england_new_york_prentice_hall_2007> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/3901056519#Agent/prentice_hall> ; # Prentice Hall
    schema:workExample <http://worldcat.org/isbn/9780132059244> ;
    umbel:isLike <http://bnb.data.bl.uk/id/resource/GBA728156> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/123374223> ;
    .


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/3901056519#Agent/prentice_hall> # Prentice Hall
    a bgn:Agent ;
    schema:name "Prentice Hall" ;
    .

<http://experiment.worldcat.org/entity/work/data/3901056519#Place/harlow_england> # Harlow, England
    a schema:Place ;
    schema:name "Harlow, England" ;
    .

<http://experiment.worldcat.org/entity/work/data/3901056519#Series/brilliant_pocket_books_series> # Brilliant pocket books series
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/123374223> ; # Microsoft Access 2007
    schema:name "Brilliant pocket books series" ;
    .

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

<http://viaf.org/viaf/26498533> # Sally E. Slack
    a schema:Person ;
    schema:familyName "Slack" ;
    schema:givenName "Sally E." ;
    schema:givenName "S. E." ;
    schema:name "Sally E. Slack" ;
    .

<http://worldcat.org/isbn/9780132059244>
    a schema:ProductModel ;
    schema:isbn "013205924X" ;
    schema:isbn "9780132059244" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

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