Category list

Editing a Relationship


Team-Fly

	10 Minute Guide to Microsoft Access 2002 By Joe Habraken
	Table of Contents

	Lesson 11. Creating Relationships Between Tables

You can edit any of the relationships that you create between your tables. Just double-click the relationship line and the Edit Relation ships dialog box appears (refer to Figure 9.6). For example, you might want to enforce referential integrity on an existing relationship or change other options related to the relationship as discussed in the previous section.

When you have finished editing the relationship, click OK to close the Edit Relationships box. This returns you to the Relationships window.


Team-Fly

Top


Team-Fly

	10 Minute Guide to Microsoft Access 2002 By Joe Habraken
	Table of Contents

	Lesson 11. Creating Relationships Between Tables

Removing a Relationship

To delete a relationship, just click it in the Relationships window (the line between the tables turns bold to indicate that it is selected), and then press Delete. Access asks for confirmation; click Yes, and the relationship disappears.

If you delete relationships between tables, you are affecting how information in the tables can be combined in a query, form, or report. It is a good practice to design your tables so that they can be related. Re member that each table is supposed to hold a subset of the database information. If each table is set up correctly, it should have at least one other table in the database to which it can be related .

In this lesson, you learned how to create, edit, and delete relationships between tables. In the next lesson, you learn how to create forms using a wizard or from scratch.


Team-Fly

Top


Team-Fly

	10 Minute Guide to Microsoft Access 2002 By Joe Habraken
	Table of Contents

Lesson 12. Creating a Simple Form

In this lesson, you learn how to create a form using the AutoForm, the Form Wizard, and from scratch.


Team-Fly

Top


Team-Fly

	10 Minute Guide to Microsoft Access 2002 By Joe Habraken
	Table of Contents

	Lesson 12. Creating a Simple Form

Creating Forms

As discussed in Lesson 7, "Entering Data into a Table," entering data directly into a table has its downside. It can become difficult to concentrate on one record at a time, and if you are working with a large number of fields, information is constantly scrolling on and off the screen.

An alternative to entering data into the table is to use a form. With a form, you can allot as much space as you need for each field, you get to concentrate on one record at a time, and you can create forms that simultaneously enter data into more than one table. You can create a form in three ways:

AutoForms provide very quick, generic forms that contain all the fields in a single table.
The Form Wizard helps you create a form by providing a series of screens in which you can choose the fields and style for the form.
Creating a form from scratch means that you work in the Form Design view and select the fields from the appropriate table or tables. This is the most difficult way to create a new form (at first), but it also provides the most control.


Team-Fly

Top

Flylib.com

Category list

Editing a Relationship

Lesson 12. Creating a Simple Form

Similar products