Access-Lesson 2
The __________ contains predefined templates including in two categories , Blank Forms and Quick Start
Application
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
To save a database file in a location other than the default, click the a. Folder icon b. Blank database icon c. File name button d. Help button
a. folder icon.
After you have created a table or other database object, you should a. Save it with a descriptive name b. Copy it to create a backup c. Link it to an external data source d. Insert a blank column at the end
a. save it with a descriptive name
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
One way to create a table is to copy the __________of an existing table and paste it into the database
Structure
Which is Not a way to create a new database table? a. Use Quick Start b. Choose create on the Table menu c. Copy the structure of another table d. Create a new blank desktop database
b. Choose Create on the Table menu
When you create a new blank desktop database, Access opens a database that contains a. One of each type of database object. b. A table c. Sample data d. A template
b. a table.
The table structure is created when you a. Format the data b. enter data c. query the data d. create forms
b. enter data
The templates group commands are located on which tab? a. Home b. Create c. Database Tools d. Datasheet
b.Create
When you quit the program , Access automatically a. Creates a link between all tables b. Leave the Navigation Pane open c. Saves the data d . Renames the file
c. saves the data
To copy a table , you must first select it in a. The clipboard b. Microsoft Office online c. The Navigation pane d. Datasheet view
c. the Navigation Pane
A table is structured through rows and _______ , which become meaningful when you enter data into it.
column
When you paste a table , which dialog box is displayed? a. Table Structure b. Copy Table c. Paste Data d . Paste Table As
d. Paste Table As
In Access, a template is a. A database to manage contacts. b. Where a database is stored. c. Two tables linked together. d. a ready -to-use database.
d. a ready-to-use database.
You can create a database using one of the many templates available or by creating a new _________database.
excel worksheet
Several options for creating a database are provided on the ______ screen in Backstage view or the _______ screen when Access is initially launched.
new
The _________ category in the Application Parts gallery contains a collection of predefined database objects for tracking comments , contacts, and issues.
quick start