BN.com Gift Guide

Using Access 2000

Overview

Using Microsoft Access 2000 leads you through a quick series of chapters to get you up and running with Access and its new interface quickly, avoiding intimidation with a complex product and providing quick satisfaction. Then you'll review more in-depth concepts, such as table relationships, datatypes, data entry techniques, and data access pages in real-world examples and tasks. Finish by learning complex database design strategies, interacting with a server, publishing to Web, and programming for customized ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (9) from $1.99   
  • New (4) from $8.00   
  • Used (5) from $0.00   
Close
Sort by
Page 1 of 1
Showing 1 – 3 of 4
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$8.00
Seller since 2014

Feedback rating:

(31)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
1999 Paperback New ** WE SHIP DAILY (Mon-Fri) ** Free Tracking Information.

Ships from: Waldorf, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Not Currently Available
$39.50
Seller since 2014

Feedback rating:

(310)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$60.00
Seller since 2014

Feedback rating:

(194)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing 1 – 3 of 4
Close
Sort by
Sending request ...

Overview

Using Microsoft Access 2000 leads you through a quick series of chapters to get you up and running with Access and its new interface quickly, avoiding intimidation with a complex product and providing quick satisfaction. Then you'll review more in-depth concepts, such as table relationships, datatypes, data entry techniques, and data access pages in real-world examples and tasks. Finish by learning complex database design strategies, interacting with a server, publishing to Web, and programming for customized applications.
Read More Show Less

Product Details

  • ISBN-13: 9780789716040
  • Publisher: Que
  • Publication date: 5/7/1999
  • Series: Using Series
  • Edition number: 1
  • Pages: 400
  • Product dimensions: 7.34 (w) x 9.08 (h) x 1.44 (d)

Table of Contents

I. LEARNING THE ACCESS ESSENTIALS.

1. Starting with a Properly Normalized Design.
The Importance of a Good Design. Refining the Design.

2. Understanding Access Objects.
What Are Objects? What Are Tables? What Are Queries? What Are Forms? What Are Reports? What Are Modules? Reviewing the Screen Object. Reviewing the DoCmd Object. Naming Conventions.

3. New User Features in Access 2000.
Converting to Prior Versions. Announcing the New Database Window. Using the File Dialog Box. Enhancing the Windows Clipboard. Updating with Name AutoCorrect. Improved Conditional Formatting. Reviewing Unicode. Working with Subdatasheets. Printing the Relationships Window. Compacting Access Data on Closing.

II. CREATING A DATABASE AND ITS OBJECTS.

4. Creating a Database.
Getting Started. What's a Wizard? Reviewing the Database Wizard. Documenting the Database.

5. Creating Tables.
Designing Tables. Working with the Table in Design View. Assigning Table Names That Describe Their Function. Making Tables Efficient Objects Within the Database. Setting Primary Keys. Indexes. Using the Table Wizard.

6. Creating Queries.
Reviewing Queries. Working with the Query Design Grid. Using the Simple Query Wizard. Using the Crosstab Query Wizard. Usingthe Find Duplicates Query Wizard. Using the Find Unmatched Query Wizard.

7. Creating Forms.
Understanding Forms. Working in Design View. Standardizing Forms. Quickly Creating Forms with a Wizard.

8. Creating Reports.
Introducing Reports. Using the Report Wizards. Viewing Reports in Design View. Setting Report Properties. Standardizing Reports. Creating a Report Template. Inserting a Chart into a Report with the Chart Wizard. Printing Your Report.

9. Creating Controls and Setting Properties.
Reviewing Control Wizards. Reviewing Control Properties. The List Box Control. Using the List Box Wizard. Creating the List Box from Scratch. Working with Combo Box Controls. Using Command Button Controls. Working with the Option Group Control.

III. STORING, CONTROLLING, AND MANIPULATING DATA.

10. Looking Up Values and Lists.
What's a Lookup? Using the DLookUp() Function.

11. Defining and Working with Relationships.
Bringing Your Information Together. Using the Relationships Window.

12. Managing External Data.
Importing and Linking. Using the Import Spreadsheet Wizard. Using the Import Text Wizard.

13. Designing and Using Queries.
Creating a Sample Database for This Chapter. Creating a Select Query Without Using a Wizard. Grouping Data and Performing Calculations with Crosstab Queries. Working with Action Queries.

14. Building Parameter Queries.
Setting Parameters in the Query Design Grid's Criteria Section. Creating an Input Box for User-Requested Criteria. Using Wildcards in Parameters.

15. Advanced Uses for Queries.
Querying Another Query. Creating a SQL Statement for a Macro RunSQL Action. Creating a SQL Statement for Use in VBA.

IV. CREATING THE INTERFACE: INPUT AND OUTPUT.

16. Adding Controls to Forms and Reports.
Working with the Toolbox. Working with the Grid. Inserting Controls. Positioning Controls. Sizing Controls. Selecting Multiple Controls. Working with Bound Controls.

17. Using Forms to Enter and Review Data.
Working in Form View. Navigating Records. Controlling Navigation in Forms. Sorting in a Form. Searching in a Form.

18. Refining Forms: Efficient Data Entry and Beyond.
Verifying Data. Forcing an Entry. Formatting Data with the Format Property. Applying Input Masks. Controlling Access. Using Expressions in Controls to Display Additional Data. Inserting Custom Controls.

19. The World of Subforms.
Working with Subforms. Creating a Subform. Referring to Subforms and Their Controls. A Subform Alternative: The Tab Control.

20. Advanced Form Techniques.
Working with the Form Module. Responding to Form Events. Linking Forms with VBA Code. Linking Forms with a Macro. Printing Form Data Without the Form. Reducing Data-Entry Tasks. Working with Pop-Up Forms.

21. Making Your Point with Reports.
Grouping and Sorting Data. Calculating Totals with Controls. The Art of Page Numbering. Inserting Graphics.

22. Displaying Detailed Data with a Subreport.
What's a Subreport and Why Do You Need One? Adding a Subreport to an Unbound Main Report.

23. Creating Labels and Mail-Merge Documents.
Using the Label Wizard. Printing Multiple Labels. Merging Access Data with Word Documents.

V. AUTOMATING THE DATABASE.

24. Creating Macros.
When to Use Macros. The Macro Design Window. Generating Macros with Multiple Actions.

25. Running Macros.
Methods Used to Run Macros. Debugging Macros. Working with the AutoExec and AutoKeys Macros.

26. Introducing Visual Basic for Applications.
When to Use VBA. Understanding Modules. The VBA Programming Environment. Using the Visual Basic Editor.

27. Programming Access with VBA.
Familiarizing Yourself with the Access Applications Model. Using the Object Browser. Learning to Speak VBA. Working with Variables and Data Types. Understanding Scope. Writing Procedures.

28. Using VBA for Interactive Input.
Passing Arguments to Your Code. Letting the Code Make Decisions. Displaying Information with a Message Box. Soliciting Information with Input Boxes. Looping in VBA. When Your Code Doesn't Work.

29. A Primer on ADO.
The ADO Advantage. Using ADO Objects. Using Recordsets.

VI. BEYOND THE DESKTOP.

30. Using Builders, Utilities, and Add-ins to Increase.
Efficiency. Using the Expression Builder for Complex Expressions. Using Access Database Utilities. Database Splitter. Installing and Using Add-ins.

31. Access on the Internet.
How Access and the Web Unite. Hyperlinks Within Access. Web-Publishing Basics.

32. Applying Security to the Database.
Why Have Security? Securing Native Access Databases (*.mdb). Securing an Access Project.

33. Multiuser Considerations.
Sharing Your Data. The Client/Server Database Environment. Performance Issues.

34. Using Access Projects.
Understanding Access Projects. Comparing an Access Project and a Database. Working with a Project's Objects. Securing an Access Project.

35. Taking the Next Step.
What's a Class Module? Creating Your Own Objects. Understanding ActiveX Technology.

Glossary.
Index.
Read More Show Less

First Chapter

[Figures are not included in this sample chapter]

Using Microsoft Access 2000
- 3 -
New User Features in Access 2000

  • Learn about the enhanced Database window and File dialog box
  • Notice improvements to the Clipboard, conditional formatting, and compacting when you close the database
  • Replace old add-ins with new features such as Name AutoCorrect and printing the Relationship window
  • Easily exchange files with Access 97
  • Use subdatasheets to view related records without a query
  • Learn the benefits of Unicode

Converting to Prior Versions

For the first time, you can save an Access database as a previous version file,so you can easily share your databases with someone that hasn't upgraded. Simplychoose Database Utilities from the Tools menu. Then, select ConvertDatabase, and finally, select To Prior Access Database Version to savethe current Access 2000 database as an Access 97 file.

Announcing the New Database Window

If you've been using an older version of Access, you'll be glad to know that Access2000 won't shock your sensibilities. Most of those familiar and convenient optionsthat you've come to rely on are still readily available. If you're new to Acc esswith this new release, you'll find Access easier to use than ever before.

The first enhancement old users will probably notice is the new Database window(see Figure 3.1). This window is consistent with other Office applications, specificallyOutlook 2000. The tabs across the top of the Database window in older releases arereplaced by the Database object bar to the left. There's a new object--Pages--inthe object list. This object is actually an HTML document that you can view withInternet Explorer 5.0, a feature that won't work with earlier versions.


SEE ALSO
Learn more about the new Pages object on page 578


You can click any item on the Database window object bar to update the contentsof the Database window. For example, Figure 3.1 shows all the table objects in theNorthwind database (which comes with Access 2000, but you must install it). To seeall the forms, click the Objects button at the top of the object bar, andthen click Forms; to see queries, click Queries, and so on. If youclick the Groups button at the bottom of the object bar, Access displays alist of user-defined groups. These groups can contain any type of native object andare new to Access 2000; you'll use them to organize your objects in most any wayyou want.

FIGURE 3.1 This new version has an expanded Database window.

Many old commands are now available from the Database window object bar. Simplyright-click the object bar to display the shortcut menu in Figure 3.2. If you right-clickthe list area (the white background), Access displays a smaller version of this menu(see Figure 3.3). If you choose Arrange Icons, you can control the way Accesssorts the objects. Specifically, you can sort by the object's name or type. You canalso sort by the date you created or modified each object.

FIGURE 3.2 Some menu options are new to the Database window.
FIGURE 3.3 You can sort the listed objects.

The Database window also sports a new menu bar across the top. The commands areself-explanatory.

The four icons to the right of the menu bar aren't new to Access, but they arenew to the Database window. (They were on the Database object bar.) These featuresallow you to display the list of objects in different ways. For instance, the LargeIcons button displays the objects as large icons (see Figure 3.4). Likewise, theSmall Icons button displays the objects as small icons. The List button is the defaultdisplay--creating a list of object names. The Details button lists information--adescription, the creation date, a modified date, and the object type--about the object.

FIGURE 3.4 You can display objects as large icons.

Using the File Dialog Box

The File dialog box has also had a makeover. It looks different, but you've seenmost of it before. The biggest change is the toolbar on the left (see Figure 3.5).You'll find this on all the File dialog boxes (Open, Save, Import, and Export). Iwon't show each one because the additions are basically the same for each dialogbox.

FIGURE 3.5 The File dialog box has been updated.

The My Documents folder is the default. You can look for files anywhe re in yoursystem by using the Look In drop-down list, but the new toolbar quickly takes youto the Desktop and the Favorites folder. The History folder tracks the files you'veworked on.

A new addition to this release is the Recent button, which allows you tostep backward through your last few tasks in the dialog box. The View buttonreplaces the Large Icons, Small Icons, List, and Details icons from the last version.The Tools button is actually a drop-down menu with the following commands:Find, Delete, Rename, Add to Favorites, Map NetworkDrive, and Properties. The remaining buttons aren't new to this version.

Earlier versions allowed you to open a database exclusively. New with this versionis the Open button, which gives you several new options: Open, OpenRead-Only, Open Exclusive, and Open Exclusive Read-Only.

Enhancing the Windows Clipboard

One of the most useful additions is the new Clipboard menu (see Figure 3.6), whichis available with Access, Excel, Word, Outlook, and PowerPoint. If you dock the Clipboardmenu to the current toolbar, you'll lose the Item options.

FIGURE 3.6 A new toolbar offers greater flexibility when using the Clipboard. The toolbar is undocked in this figure.

Access doesn't display the toolbar by default; you must open it. To display theClipboard toolbar, choose Toolbars from the View menu. Then, choosethe Clipboard option.


An alternative way to open the Clipboard toolbar
The quickest way to open the Clipboard toolbar is to sim ply copy the same item to the Clipboard twice in a row. To do so, just click the Copy button on the current object menu twice. Access automatically displays the Clipboard toolbar. (This feature works consistently in Design view, but not in others.)

The Clipboard saves up to 12 items for later recall. However, the Pastebutton pastes the most recently copied item. By using the Clipboard toolbar, youcan quickly access the other 11. (Figure 3.6 shows only four item slots. Don't worry--asyou copy new items to the Clipboard, the Clipboard toolbar displays empty new slots.)

Paste from the Clipboard

1. To copy multiple items to the Clipboard, select each item individually and then click the Copy button on the Clipboard toolbar or the current object menu.

2. When you're ready to start pasting, click the spot where you want to paste an item to.

3. Select the appropriate Item option from the Clipboard toolbar. Access copies the selected item to the current object (the object you selected earlier). Or, you can click Paste All to paste all the items at once.

Updating with Name AutoCorrect

In earlier versions, if you renamed an object, you had to find every referenceto that object and update it as well. If you didn't, sooner or later you encounteredan error. For instance, if you changed the name of a field in one of your tablesbut didn't update the bound controls in your data-entry form, you would certainlyhave trouble using that form.

Access 2000 now automatically updates references if you change an object's name.For instance, if you change a field name in one of your tables, Access 2000 updatesall your bound controls so that you can continue to work without error. Name AutoCorrectalso updates references in queries.

You must turn this feature on for it to work. Choose Options from the Toolsmenu and click the General tab. Next, select Track Name AutoCorrect Infoin the Name AutoCorrect section. Then, turn on the feature by selecting PerformName AutoCorrect. Name AutoCorrect remains enabled through this and subsequentsessions, unless you turn it off.

Improved Conditional Formatting

Conditional formatting allows you to set a value's font, styles, and colordepending on set conditions. For instance, you can easily display positive valuesin black and negative values in red. This feature also works with values expressedas less than, greater than, between, or equal to.

To apply conditional formatting to a form or report control, while in Design view,choose Conditional Formatting from the Format menu. Access displaysthe Conditional Formatting dialog box (see Figure 3.7). The upper portionof this dialog box displays the default format; in the lower portion, select theformats you want when a value meets conditions you specify.

FIGURE 3.7 With the Conditional Formatting feature, you can base a control's format on data.

Reviewing Unicode

Microsoft Office relies on the Unicode standard to display documents correctly,regardless of their origin. The Unicode standard, developed by the Unicode consortium,governs character coding and provides a 16-bit internat ional character code for informationprocessing that covers the world's major languages. The Unicode standard definescharacter encoding, and the properties and algorithms used in its implementation.Simply put, if an application supports Unicode, Access can read that application'sfiles, which makes data transfer easier and more accurate than before.

Working with Subdatasheets

Subdatasheets create a hierarchical display of your data in Datasheet view.Rather than view a single table or record, you can open a subdatasheet and view relateddata. For instance, if you open the Categories table in the Northwind database (whichcomes with Access 2000, but you must install it), you can expect to view only thoserecords stored in that table. However, the Categories table is related to the Productstable. By using a subdatasheet, you can display the category records and their relatedproduct records.


Viewing the subdatasheet
As soon as you open a record's subdatasheet, Access displays a minus sign to indicate that all the related records are visible. To close the subdatasheet, click the resulting minus sign.

If related records exist, Access displays an additional column at the datasheet'sleft margin. If that column contains a plus sign, the record has related records;if the column contains a minus sign, there are no related records. To see the relatedrecords (see Figure 3.8), simply click the plus sign. For instance, the first recordin the Orders table, for order 10248, has three related records.

FIGURE 3.8 This subdatasheet displays three related records for order 10248.

Printing the Relationships Window

In earlier versions of Access, if you wanted to know about relationships, youhad to use the Documenter Wizard or buy a third-party product. Now, you can use thePrint Relationships Wizard to print the Relationships window. After you open theRelationships window, choose Print Relationships from the File menu.The wizard then creates and previews a report that you can save or print.

Compacting Access Data on Closing

Compacting an Access database has always been a manual task, unless you automatedit with code. Now, you can compact your database when you close it. Doing so compressesyour file each time you close it, which saves on resources. To turn on this feature,choose Options from the Tools menu. Then, on the General page, selectthe Compact on Close check box.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)