Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions