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
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
Get step-by-step solutions from verified subject matter experts
