Deck 10: Customizing Access and Using Skydrive and Office Web Apps

Question 1

Each field in a table must have a unique name.

Answer 1

True

Question 2

In Access,the primary object of a database is called a table.

Answer 2

True

Question 3

A template provides you with a complete,ready-to-use database application.

Answer 3

True

Question 4

The Navigation pane shows each object in your database.

Question 5

CamelCase notation is the practice of using a prefix to indicate the type of object.

Question 6

In Access,it is not possible to delete fields after you have added data to the field.

Question 7

Access is a relational database management system.

Question 8

Each field in your database must be assigned a specific data type.

Question 9

The Navigation pane displays your objects by categories and groups.

Question 10

When you first create an object,Access assigns a generic name,such as Table1 or Form1.

Question 11

Form objects are used to find data in a database.

Question 12

It is important to save a database file before closing it.

Question 13

A primary key is a field that contains a unique value for each record.

Question 14

It is possible to change a limited number of field properties in Datasheet view.

Question 15

Design view allows you to enter,modify,delete,or view the data records.

Question 16

Access provides many different ways to navigate among the data records stored in your tables.

Question 17

When working with a new table,you can save it by clicking the File tab and clicking the Save button.

Question 18

The AutoFit feature helps visually frame the rows and columns in a datasheet with a border.

Question 19

The Back Up Database option creates a copy of your database.

Question 20

Access automatically assigns a generic file name to your database,such as Database1.accdb.

Question 21

Which of the following is used to find data in a database?

A) report
B) form
C) query
D) table

Question 22

What is another name for a single unit of data?

A) field
B) record
C) table
D) database

Question 23

Which of the following is not located on the Access Ribbon?

A) File tab
B) Home tab
C) Create tab
D) Organize tab

Question 24

The Find button is located on the File tab.

Question 25

What is a collection of related records called?

A) field
B) record
C) table
D) database

Question 26

Adding a filter to a second field is an OR condition.

Question 27

The Datasheet Formatting dialog box enables you to make several changes at once to the layout of a datasheet.

Question 28

Compound filter criteria combine more than one search value using the AND and OR logical operators.

Question 29

In a database,which of the following enables you to connect two tables to each other?

A) field
B) record
C) table
D) database

Question 30

It is not possible to change the order of fields in an Access table.

Question 31

Which of the following is an organized collection of integrated and related tables?

A) hierarchy of data
B) database
C) database management system
D) Entity-Relationship Diagram

Question 32

To best organize a database,what must you understand?

A) hierarchy of data
B) database
C) database management system
D) Entity-Relationship Diagram

Question 33

The Sort functions are helpful in limiting the number of records that display in your datasheet.

Question 34

Descending order is the lowest to highest for a number field or A to Z for a text field.

Question 35

In Access,what are the different components of a database application called?

A) fields
B) data
C) objects
D) tables

Question 36

What is a collection of related fields called?

A) field
B) record
C) table
D) database

Question 37

Once a filter has been applied to datasheet records,it is not possible to return them to their original unfiltered state.

Question 38

Which of the following is a type of software application?

A) hierarchy of data
B) database
C) database management system
D) Entity-Relationship Diagram

Question 39

If you open a table with a previously saved sort,clicking Remove Sort on the Home tab removes the sort.

Question 40

You can sort a datasheet by one field,or a set of adjacent fields,in ascending or descending order.

Question 41

Which of the following data types is used for storing text longer than 255 characters?

A) Short Text
B) Long Text
C) Number
D) Currency

Question 42

Which of the following tabs provides functionality for linking to other applications and data files?

A) File
B) Create
C) Database Tools
D) External Data

Question 43

Which of the following shortcuts opens the Backstage view so you can select a new database to create?

A) Ctrl+B
B) Ctrl+N
C) Ctrl+O
D) Ctrl+S

Question 44

Which of the following keys opens and closes the Navigation pane?

A) F5
B) F7
C) F9
D) F11

Question 45

Which of the following should you do to the database file when you are finished working on it?

A) save
B) back up
C) close
D) rename

Question 46

Which of the following is used to store data records?

A) report
B) form
C) query
D) table

Question 47

What are data records displayed in?

A) Navigation pane
B) contextual tab
C) datasheet
D) Navigation menu

Question 48

Which of the following allows you to enter,modify,delete,or view data records?

A) Design view
B) Datasheet view
C) External data
D) Ctrl+N

Question 49

Which of the following tabs must you use to create a backup copy of a database?

A) Home
B) File
C) Backup
D) Copy

Question 50

Which of the following data types is used to store the results of a calculation?

A) Hyperlink
B) Attachment
C) Calculated
D) Lookup Wizard

Question 51

Which of the following allows you to build or modify the basic structure or functionality of an object?

A) Design view
B) Datasheet view
C) External data
D) Ctrl+N

Question 52

Which of the following is used to create an interface to view,add,update,and delete data?

A) report
B) form
C) query
D) table

Question 53

Which of the following data types is used to attach pictures,images,and Office files?

A) Hyperlink
B) Attachment
C) Calculated
D) Lookup Wizard

Question 54

Which of the following describes a pre-designed database?

A) object
B) Blank desktop database
C) Leszynski
D) template

Question 55

Which of the following tabs provides information about your database and additional functions to help you manage the database?

A) File
B) Create
C) Database Tools
D) External Data

Question 56

Which of the following tabs must you use to create all the objects you use in a database?

A) File
B) Create
C) Database Tools
D) External Data

Question 57

Which of the following data types is used to instruct Access to insert a unique,sequential number each time a new record is added?

A) Currency
B) AutoNumber
C) OLE Object
D) Hyperlink

Question 58

Which of the following data types would you use to display a spreadsheet object in a field?

A) Currency
B) AutoNumber
C) OLE Object
D) Hyperlink

Question 59

Which of the following is used to view and print the data in a database?

A) report
B) form
C) query
D) table

Question 60

Each object in your database application is shown in the ___________________.

A) Navigation pane
B) File tab
C) datasheet
D) Navigation menu

Question 61

When a new table is created in Datasheet view,what field does Access automatically include?

A) AUTO
B) COUNTER
C) ID
D) FIELD

Question 62

Which of the following is the default name that Access assigns to new blank tables?

A) Table01
B) Table1
C) Datasheet01
D) Datasheet1

Question 63

Which of the following buttons can you use to undo the deletion of a table field?

A) Undelete Field
B) Undo
C) Redo
D) none of the above

Question 64

In Datasheet view,which of the following keys moves the pointer to the next field?

A) Tab
B) Shift
C) Esc
D) Insert

Question 65

What must you create for each of the different pieces of information you want to keep in your table?

A) field
B) record
C) object
D) query

Question 66

To edit field properties in Datasheet view,select the cell containing the field name you wish to change and then click the ____________.

A) Home tab
B) File tab
C) Name & Caption button
D) Properties button

Question 67

What symbol displays when Date and Currency values are too wide to fit in the column?

A) dollar signs ( $$$$ $)
B) asterisks (*****)
C) ampersands (@@@@@)
D) pound signs (#####)

Question 68

Access ____________ determines a data type for the field based on the contents that you enter.

A) never
B) rarely
C) sometimes
D) automatically

Question 69

The Undo button _______________ be used to undo changes made to the datasheet layout.

A) can
B) can rarely
C) can usually
D) can never

Question 70

To add a new field to a table,on what must you click in the first cell?

A) Record Selector
B) form
C) Append Row
D) datasheet

Question 71

To add a new field between existing fields,put your pointer on the field name of the column _____________ where you wish to insert a new field.

A) to the left of
B) to the right of
C) above
D) below

Question 72

Which of the following is a field that contains a unique value for each record?

A) primary key
B) secondary key
C) index
D) record selector

Question 73

If you have several users of your database,you must be certain that all users have ___________ the database before you perform a backup procedure.

A) saved
B) copied
C) closed
D) renamed

Question 74

To change the name of a field in a datasheet,_____________ the field name.

A) click
B) double-click
C) select
D) delete

Question 75

To initiate the automatic saving of data,what must be done to your table at least once?

A) opened
B) saved
C) backed up
D) renamed

Question 76

What must be unique about each field in a table?

A) report
B) form
C) query
D) name

Question 77

It is strongly recommended that you identify a(n)___________ in each table as the primary key.

A) field
B) record
C) object
D) query

Question 78

To delete a record from a table,first click in the _______________ of the _____________.

A) Record Selector cell,record
B) Append Row,datasheet
C) first field,record
D) first row,datasheet

Question 79

To select a column,place your pointer ____________ the field name of the column you wish to move.

A) above
B) below
C) to the left of
D) to the right of

Question 80

Which tab are Access's features for formatting text found?

A) File
B) Home
C) Create
D) Format