Working with Tables and Queries

Quick Check

Fill in the blanks.

1. Access 2016 provides two ways to create tables - Datasheet View and Design View.
2. In Datasheet View, data is entered directly into the table's rows and columns.
3. When creating a table in Design View, you define the structure of the table by specifying name and data type for each field.
4. To add a new field in Datasheet View, right-click on the dropdown arrow of the field to the left, then select 'Insert Field'.
5. In Design View, to delete a field, select the row corresponding to the field and click on the 'Delete Rows' button in the 'Tools' group on the Design tab.

Choose True or False for the following statements.

1. In Datasheet View, you can move a field by selecting its field header and dragging it to the desired location. True
2. Freezing a field in Access means making it appear on the rightmost side of the table. False
3. Hiding a field in Access permanently deletes it from the table. False
4. Sorting data in Access allows you to arrange records in either ascending or descending order based on the selected field. True

Match the columns

1. Creating a Table in Datasheet View → Moving a field
2. Freezing a Field → Stores web addresses
3. Establishing relationship → Specifying multiple criteria
4. Creating a Query in Design View → Sorting data
5. Query → Extracting specific information

Time to Perform

A Fill in the blanks.

1. By default, a table is created in Datasheet view.
2. The workspace of a Database Interface Window shows a table with default name Table1 in the Datasheet view.
3. Access provides a Navigation toolbar to move through the records.
4. Sorting means to arrange the data in ascending or descending order.
5. Field displays the selected field names from the table.

B State whether the following statements are True or False.

1. Data can be entered directly into the table in rows and columns in the Design view. False
2. Datasheet view is used by programmers and professionals. False
3. A data type indicates the kind of data to be stored. True
4. A table can be edited only in the Design view. False
5. Freezing in Access means to keep the selected field/column to the left side of the table and also visible at all times, irrespective of the direction of your scroll. True

C Name the following.

1. Group and tab of Table Design option: Tables group, Create tab
2. Shortcut key to close the table window: Ctrl + W
3. Set of records that are retrieved and stored in a separate table: Query Table
4. Any two panes of query window: Upper pane, Bottom pane
5. Shortcut key to save the table name: Ctrl + S