Exam 17: Creating a Database

When you close the query window after modifying a query, you'll see a message asking Do you want to save changes to the design of query 'Query Name'? _________________________

Microsoft Excel is the component of the Microsoft Office suite best suited for working with large collections of data called databases.

-Referring to the figure above, if you wanted to change the director for The Hurt Locker, you would ____.

To define a field for a table, you begin by selecting a name for the field.

To edit data, click the cell containing the data.Use the ____ keys to move the insertion point within the field.

The name you enter when you save a table should be the same as the name for the database.

To start Access, click Start, point to ____, click Microsoft Office, then click Microsoft Access 2010.

A ____ contains information about a single "entity" in the database-a person, place, event, or thing.

To define a field for a table, you begin by selecting a(n) ____________________, such as Text, Number, or Memo.

A(n) ____________________ contains a single unit of information, such as a name, birth date, or ZIP code.

Each ____________________ in a table contains a particular type of data, such as a name or date.

The primary key is an important field in an Access table.Please describe a primary key.Does Access create the primary key or can you create it yourself?

To move a field, select the column or columns that you want to move.Drag the column ____ to the desired location.

A ____ contains records.

Rows represent ____.

Case 17-1 Sam is working in an Access table listing all of the hockey equipment that he has for sale on eBay. Please answer the questions below. -Sam just got in a new shipment of goalie face masks that he wants to add to the database.When he adds the first entry, it shows up ____.

Import options are listed on Access's ____________________ tab.

An Access database consists of tables.Each table is similar to a ____.

You can create a(n) ____________________ to search your database for records that contain particular data.

To delete a record, right-click the ____ of the record you want to delete.Select Delete Record from the shortcut menu.