Page 56 - Computer Class 08

Sorting the Objects in the Navigation Pane

By default, objects are sorted by type, with the tables in one group, the forms in another etc.
However, you can change how the objects are sorted.

Let’s
Let’s Learn...
Learn...
To sort the objects in the Navigation Pane.

1. Click the drop-down arrow to the right of the All Access

Objects.
2. Click on a sort option from the list.

Understanding Views

There are multiple ways to view a database object. The two views for tables are Design View

and Datasheet View .
8 Design View is used to set the data types, insert or delete fields and set the Primary Key.
8 Datasheet View is used to enter and view the data for the records.

Switching Between Design View and Datasheet View

Click the View arrow on the Home tab and click on either Datasheet View or Design View

Creating a Table

A table is a collection of data about a specific topic, such as employee information, products
or customers. The first step in creating a table is entering the fields and data types. This can
be done in either Datasheet View or Design View but it is recommended to set up the table
in Design View .

Computer-8 56