Access Lesson 2 Knowledge Assessment
The _______ contains predefined templates included in two categories, Blank Forms and Quick Start.
Application Parts gallery
Which is not a way to create a new database table?
Choose Create on the Table menu.
The Templates group commands are located on which tab?
Create
Several options for creating a database are provided on the _______ tab in the Backstage view.
New
When you paste a table, which dialog box is displayed?
Paste Table As
The _______ category in the Application Parts gallery contains a collection of predefined database objects for tracking comments, contacts, and issues.
Quick Start
In Access, a template is
a ready-to-use database.
When you create a new blank database, Access opens a database that contains
a table.
One way to create a table is to copy the _______ of an existing table and paste it into the database.
structure
You can use up to _______ characters (letters or numbers), including spaces, to name a database object.
64
Entering data in Datasheet view is very similar to entering data in a(n) _______.
Excel worksheet
You can create a database using one of the many templates available or by creating a new _______ database.
blank
A table is structured through rows and _______, which become meaningful when you enter data into it.
columns
The table structure is created when you
enter data.
To save a database file in a location other than the default, click the
folder icon
By default, Access creates a(n) _______ field named "ID" for all new datasheets.
primary key
When you add a new table to an existing database, that new table stands alone until you _______ it to your existing tables.
relate
After you have created a table or other database object, you should
save it with a descriptive name.
When you quit the program, Access automatically
saves the data.
To copy a table, you must first select it in
the Navigation Pane