Sams - Teach Yourself Microsoft Access 2000 in 24 Hours

Search Tips

Advanced Search

Sams Teach Yourself Microsoft Access 2000 in 24 Hours

by Timm Buchanan; Craig Eddy

Sams, Macmillan Computer Publishing

ISBN: 0672312891 Pub Date: 04/29/99

Search this book:

Table of Contents

Workshop

The Workshop is designed to help you anticipate possible questions, review what you’ve learned and begin

thinking ahead to putting your knowledge into practice. The answers to the Quiz are in Appendix A.

Q&A

Q Why is the column heading in Datasheet view different from the field name shown in the Design

view for a table.

A Every field, regardless of data type, has a

Label

property. You use this property to specify the default

caption for the field. This caption is used in the Datasheet view. It also is the default caption for the

label that is placed on a form when the field is added to the form.

Q When I add a new employee, I get a message informing me that the

FirstName

field cannot

contain a

Null

value. Why is this happening.

A Most fields have a property called

Required

. If this property is set to

Yes

, you must enter a value for

every record stored in the database. If the data is really not required, you can set this property to

Q When I attempt to delete an employee, I get a message informing me that the record cannot be

deleted. Why is this happening.

A Remember that the back-end databases you can use with Access use a relational database model. This

means that you can relate a record in one table to a record or records in another table. After you create

such a relationship, the information pertaining to the relationship must be kept intact. In the Northwind

database, for example, you can create an Orders record that has an employee related to it—the

employee who took the order, perhaps. If you then deleted that Employee record, you’d leave some

incomplete data in the Orders table (you’d have orders with data pointing to invalid employees).

Access 97 enforces this data integrity by disallowing deletions in this instance. As you’ll see in Hour

10, however, Access 97 can instead be instructed to delete any records related to the record you’re

attempting to delete.

Quiz

1. How can you determine which fields make up the primary key for a table.

Title

-----------