Tips

See tip link for description.

See tip link for description.

In this unit we will learn how to create queries and how to use them to edit records in tables created in Access2003.

When our database contains many tables and relationships, the Relationship window could become so complex that it is difficult to interpret. We can overcome this difficulty by tidying the window and visualizing only the tables and their relationships that interest us in one moment. We use the Clear layout and Show direct relationships options for this as we will describe to you next.

If we have already created a relationship and want to create another but the table is not ready in the Relationships window we need to add the table to the window.

In this unit we will see how to relate tables and the different types of relationships that can exist between two tables in a database.

Every field within a table has a severals characteristics set out which provide an additional control with regard to the way in which the field functions. The properties appear in the lower part of the Table design window when we have a field selected.

We will often need to search for a record when knowing the value of some of its fields. In order to perform this operation we have at our disposal the Access2003 Find tool.

Here we will see the record editing techniques used to modify a table definition as well as the data introduced into it.

We will fill in the grid defining each of the columns that compose the table: