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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started