BN.com Gift Guide

Sams Teach Yourself Microsoft Access 2000 in 10 Minutes

Overview

Sams Teach Yourself Access 2000 in 10 Minutes is a tutorial, organized into lessons starting with the basics and progressing to more advanced features. Straightforward, practical examples provide quick results. The book includes coverage of queries, form design, table relationships, team collaboration, and the Internet.

Read More Show Less
... See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (18) from $1.99   
  • New (1) from $7.79   
  • Used (17) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$7.79
Seller since 2005

Feedback rating:

(49525)

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
Shrink-wrapped NEW book

Ships from: Columbia, MO

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Sams Teach Yourself Access 2000 in 10 Minutes is a tutorial, organized into lessons starting with the basics and progressing to more advanced features. Straightforward, practical examples provide quick results. The book includes coverage of queries, form design, table relationships, team collaboration, and the Internet.

Read More Show Less

Product Details

  • ISBN-13: 9780672314872
  • Publisher: Sams
  • Publication date: 4/27/1999
  • Series: Sams Teach Yourself Series
  • Edition number: 1
  • Pages: 256
  • Product dimensions: 5.50 (w) x 8.40 (h) x 0.53 (d)

Meet the Author

Faithe Wempen, M.A., operates Your Computer Friend, a PC troubleshooting and training business specializing in teaching beginning users to work with their PCs. She has taught Microsoft Access courses for both businesses and individuals, and is the author of The 10 Minute Guide to Access 97 and The Microsoft Office 97 Professional 6-in-1, as well as over 20 other books.

Read More Show Less

Table of Contents

Introduction.

What Is Microsoft Access 2000? What Is the Sams Teach Yourself in 10 Minutes Series? Conventions Used in This Book.

What Is a Database?

What Are Databases Good For? How Access Stores Your Data. Reports. Queries. How the Parts Fit Together. Access Wizards Make Databases Easy.

Planning your Database.

Planning Is Important! Determining the Tables You'll Need. What Forms Will You Use? What Reports Will You Want to Produce?

Starting and Exiting Access.

Starting Access. Parts of the Screen. Exiting Access.

Using the Help System.

Help: What's Available? Asking Office Assistant. Using the Microsoft Access Help Window. Reading a Help Topic. Finding and Fixing Errors in the Program. Other Help Features.

Creating a New Database.

Choosing the Right Way to Create Your Database. Creating a Blank Database. Creating a Database with Database Wizard.

Saving, Closing, and Opening a Database.

Saving a Database. Closing a Database. Opening a Database. Changing the Drive or Folder. Finding a Database File.

Creating a Table with the Table Wizard.

Why Create a Table? Creating a Table Using the Table Wizard. Now What?

Creating a Table Without a Wizard. Why Not Use a Wizard? Creating a Table in Table Design View. Understanding Data Types and Formats. Setting the Primary Key. Switching Between Design and Datasheet Views. Creating a Table by Entering Data.

Modifying a Table.

Editing Fields and Their Properties. Adding Fields. Deleting Fields. Hiding a Field. Deleting a Table.

Creating Relationships Between Tables.

Why Create Relationships? Creating a Relationship Between Tables. What is Referential Integrity? Editing a Relationship. Removing a Relationship. Now What?

Entering Data into a Table.

Entering a Record. Some Data-Entry Tricks. Moving Around in a Table. Printing a Table. Closing a Table.

Editing Data in a Table.

Changing a Cell's Content. Selecting Records. Inserting New Records. Deleting Records. Moving and Copying Data.

Formatting a Table.

Why Format a Table? Changing Column Width and Row Height. Changing the Font.

Creating a Simple Form.

Why Create Forms? Creating a Form with AutoForm. Creating a Form with Form Wizard. Creating a Form from Scratch. Entering Data in a Form.

Modifying a Form.

Cleaning Up Your Form: An Overview. Moving Controls. Moving Controls and Their Labels Independently. Resizing Controls. Viewing Headers and Footers. Adding Labels. Formatting Controls. Changing Tab Order.

Creating Special Data-Entry Fields on a Form.

Why Use Special Data-Entry Controls? What Kinds of Controls? Creating a List Box or Combo Box. Creating an Option Group. Adding Command Buttons. Inserting ActiveX Controls.

Adding Graphics to Forms.

Why Add Graphics to Forms? Importing Clip Art. Importing a Graphic. Resizing a Graphic. Creating a New Picture.

Searching for Data.

Using the Find Feature. Using the Replace Feature. Other Ways to Find Data.

Sorting, Indexing, and Filtering Data.

Finding and Organizing Your Data. Sorting Data. Filtering Data. Creating Indexes.

Creating a Simple Query.

What Can a Query Do? Creating a Query Using the Simple Query Wizard. Printing Query Results. Other Query Wizards.

Designing Your Own Query.

Working with Query Design View. Adding Fields to a Query. Deleting a Field. Adding Criteria. Viewing Query Results.

Customizing a Query.

Sorting a Field in a Query, Showing or Hiding a Field. Adding a Calculated Field.

Creating a Simple Report.

Why Create Reports? Using AutoReport to Create a Report. Creating a Report with the Report Wizard. Viewing and Printing Reports in Print Preview.

Customizing a Report.

Entering Report Design View. Working with Controls on Your Report.

Working with Related Tables.

What Good Are Related Tables? Viewing Related Data in Datasheet View. Creating Multitable Queries. Creating Multitable Forms. Creating Multitable Reports.

Creating a Chart.

The Chart Advantage. Creating a Chart. Using Print Preview. Saving a Chart Report.

Using Access on the Internet.

Some Internet Basics. Saving as a Web Page. Inserting Hyperlinks Into an Access Object. Creating Data Access Pages.

Sharing Your Database With Others.

Why Share Data? Setting Up Exclusive Use. Assigning Passwords to Database Files. User-Level Security (Network Only). Team Collaboration. Creating an .mde File. Encrypting a Database. Data Protection on Forms.

Importing and Exporting Data.

Why Import and Export Data? Importing Data from Other Programs. Exporting Data to Other Programs.

Backing Up Your Data.

Backing Up Your Database File. Repairing Damaged Database Files.

Index.

Read More Show Less

First Chapter

[Figures are not included in this sample chapter]

Sams Teach Yourself Microsoft Access 2000 in 10 Minutes

- 3 -

STARTING AND EXITING ACCESS

In this lesson, you will learn how to start and exit Microsoft Access.

STARTING ACCESS

Youcan start Access in several ways, depending on how you've installed it. One wayis to use the Start menu button. Follow these steps:

1. Click the Start button. A menu appears.

2. Highlight or point to Programs. A list of your program groupsappears, with a list of separate Microsoft applications under the groups.

3. Click Microsoft Access in the list of applications. Accessstarts.


TIP: Moving Programs Around on the Start Menu  If you would prefer to have Access in a different program group, open the Start menu and drag the Access item to another location of your choice.

OTHER WAYS TO START ACCESS

Someother ways to start Access require more knowledge of Windows and MicrosoftOffice. If you're confused by them, stick with the primary method explained inthe preceding section.

  • You can create a shortcut icon for Access to sit on your desktop; youcan then start Access by double-clicking the icon. To create the shortcut icon,drag the Access item from the Start menu to the desktop.

  • When you're browsing files in Windows Explorer, you can double-clickany Access data file to start Access and open that data file. Access data fileshave an .mdb extension and a little icon next to them that resembles the iconnext to Microsoft Access on the Programs menu.

  • If you can't find Access, you can search for it. Click the Startbutton and select Find, select Files or Folders, and then typemsaccess.exe in the Named text box. Open the Look In listand select My Computer. Then click Find Now. When the fileappears on the list at the bottom of the Find window, double-click it to startAccess, or right-click and drag it to the desktop to create an Accessshortcut.

When you start Access, the first thing you'llsee is a dialog box prompting you to create a new database or open an existingone (see Figure 3.1). For now, click Cancel. (We won't be working withany particular database in this lesson.)

FIGURE 3.1  This Microsoft Access dialog box appearseach time you start Access.

PARTS OF THE SCREEN

Accessis much like any other Windows program: It contains menus, toolbars, a statusbar, and so on. Figure 3.2 points out these landmarks. Notice that in Figure3.2, many of the toolbar buttons are grayed out (which means you can't use themright now). There's also nothing in the work area, because no database file isopen. The Access screen will become a much busier place in later lessons whenyou begin working with a database; the buttons will become available, and yourd atabase will appear in the work area.

FIGURE 3.2  Access has the same interface landmarks asany Windows program.

UNDERSTANDING ACCESS TOOLBARS

Ifyou've used Windows programs before, you're probably familiar withtoolbars--rows of buttons that represent common commands you can issue.Toolbar buttons are often shortcuts for menu commands.

The Access toolbar changes depending on which type of database object you'reworking with at the time (table, form, and so on), and what you're doing to it.More toolbars sometimes appear when you're doing special activities, such asdrawing. To find out what a toolbar button does, put your mouse pointer overit; its name appears next to the pointer (see Figure 3.3). This feature is aToolTip (or a ScreenTip); you can use ToolTips even when a buttonis unavailable (grayed out).

FIGURE 3.3  To find out what a toolbar button does, point at it.


TIP: Customizing Toolbars  You can choose which toolbars you view at any time, and even add and remove buttons from a toolbar. If you right-click any toolbar, a shortcut menu appears. You can select a toolbar for viewing from that list, or click Customize to open a dialog box where you can customize any toolbar.

EXITING ACCESS

Whenyou finish working with Access, you should exit it to free up your computer'smemory for other tasks. You can exit Access in several ways:

  • Press Alt+F4.

  • Select File, Exit.

  • Click the Access window's Close (×) button (refer to Figure3.3).


NOTE: Alt+F4? File, Exit?  In this book, I use a kind of shorthand to tell you what keys to press and which menu commands to select. When you see press Alt+F4, it means hold down the Alt key on the keyboard while you press the F4 key. When you see select File, Exit, it means click the word File on the menu bar, and then click the Exit command on the menu that appears.

In this lesson, you learned how to start and exit Access, and about the mainparts of the screen, including the toolbar buttons. In the next lesson, youwill learn how to use Access's Help system.

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)