IT App

T

- A new blank desktop database includes one table named Table1.

F

- when you add a field to a table in Table Design View, entering the field name is optional.

T

- To enter data in a table, open it in Table datasheet view

F

- Before you can rename a field, you must change its data type.

T

- you can create a table in table datasheet view or table design view.

F

- to display the data in a table, you open the table in table design view.

T

- you might delete an employee if the employee no longer works for the company

F

- a field with the currency data type contains such as quantities, measurements, and scores.

T

the linking field on the "many" side of one-to-many relationships is called the foreign key field

F

- when you enter a record in a table, you are working in navigation mode.

T

- when a record from one table is related to several records in another table, the tables have a one-to-many relationship.

F

- press ESC to remove editing changes you made to the previous record.

T

- you enter and edit data in a query datasheet in the same way you do in a table datasheet.

F

- a form selects a subset of fields & records from one or more tables, & then presents selected data as a single datasheet.

T

- to add a field list to the upper pane in query design view, drag a table from the navigation pane.

F

- of all the database objects, a table provides the most formatting, layout, and summary options.

T

- to add, delete, or change fields in a query, you use query design view.

F

- a query is a temporary view of the data that is removed when you close the query in query design view.

T

- in query design view, the query grid shows the names of the fields and tables involved in the query.

F

- before you close a query datasheet, you must save your changes to the data.

F

- before you close database, you must save any changes you made to the data.

F

- in a datasheet, you can find data, but not replace it.

F

- To navigate to a record in a table, switch to table design view.

F

- sorting a table datasheet temporarily displays only those records that match given criteria.

F

table design view shows how each table relates to other tables in the database