Question: I know it's a lot but can someone please help me with my test review? I will give a good review! QUESTION 1 Access starts

I know it's a lot but can someone please help me with my test review? I will give a good review!

QUESTION 1

Access starts you off with a single table and shows that table in ________ view.

Design

Datasheet

Datatype

Template

QUESTION 2

Which object would be used to find an author of a book within a database which contains book titles, authors and publishers?

Query

Table

Criteria

Form

QUESTION 3

True or False: A report is an object that helps you print some or all of the information in a table.

True

False

QUESTION 4

______ provide an easy way to view or change the information in a table.

Objects

Forms

Reports

Disks

QUESTION 5

True or False: Because Access allows you to relate tables and databases to one another, it is often referred to as a relational database.

True

False

QUESTION 6

______ extract data from a table or related tables and can include calculations.

Wizards

Forms

Queries

Labels

QUESTION 7

In a one-to-many relationship, the primary table contains a primary key field that is included as a field in the secondary table and is called a ______.

Id Key

Foreign Key

Valid Key

Criteria Key

QUESTION 8

True or False: Within a database, fields can be added, deleted and edited but never moved.

True.

False.

QUESTION 9

Records may be added to a table by using the ___________.

Query View.

Report View.

Design View.

Datasheet View

QUESTION 10

True or False: Within a database, it is important to assign the correct data type to each field; for most fields, you can change the data type after data has been entered.

True

False

QUESTION 11

True or False: To filter records, you can specify a condition that the record must meet to be included in the datasheet.

True

False

QUESTION 12

Which of the following "datatypes" would be applied to a field containing an employee's date of hire?

Date arithmetic

Constant

Date/Time field

Calculated field

QUESTION 13

A unique field that exclusively identifies each record within a table.

Relational key

Primary key

Conditional Key

Data type field

QUESTION 14

_______ fields are useful for fields that reference a specific list of items.

Date/Time

Lookup

Number

Curency

QUESTION 15

True or False: Filter by selection lets you apply a filter based on any value in your table.

True

False

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Lets address the questions one by one stepbystep QUESTION 1 Access starts you off with a single table and shows that table in Datasheet view Explanation The datasheet view displays the data in rows an... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!