Filters
Question type

Study Flashcards

________ shows the report design but not the data.


A) Report view
B) Print Preview
C) Layout view
D) Design view

E) C) and D)
F) All of the above

Correct Answer

verifed

verified

Query results show records and fields created at ________,which means that the results are created each time you run the query.

Correct Answer

verifed

verified

________ is/are facts about people,events,things,or ideas.


A) Knowledge
B) A competitive advantage
C) Data
D) Information

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

When you open a database,Access displays the Navigation Pane on the right side.

A) True
B) False

Correct Answer

verifed

verified

A wizard is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

A) True
B) False

Correct Answer

verifed

verified

The ________ Wizard starts similarly to the Query Wizard in selecting fields for the report.


A) Table
B) Report
C) Form
D) Design

E) B) and C)
F) C) and D)

Correct Answer

verifed

verified

Query results show records and fields created at recordset time,which means that the results are created each time you run the query.

A) True
B) False

Correct Answer

verifed

verified

The power of a database system comes with the ability to link tables together.

A) True
B) False

Correct Answer

verifed

verified

Match the following objects with their definition.

Premises
Table
Form
Report
Query
View
Responses
Used to enter,edit,delete or display records
Provides an easy-to-read view of data
Stores data in columns and rows
Ask questions about the data
Gives a different perspective

Correct Answer

Table
Form
Report
Query
View

Match the following terms with their definition.

Premises
Datasheet view
Design view
Relationship
Record
Field
Responses
A column of data
Shows the data contents within a table
A row of data
Shows how fields are defined
Links between tables

Correct Answer

Datasheet view
Design view
Relationship
Record
Field

A ________ provides an easy-to-read format suitable for printing.


A) wizard
B) macro
C) form
D) report

E) None of the above
F) C) and D)

Correct Answer

verifed

verified

If you select ________,Access automatically compacts your database anytime you close it.


A) Compact Now
B) Compact on Exit
C) Compact on Close
D) Compact and Repair Database

E) C) and D)
F) None of the above

Correct Answer

verifed

verified

A(n) ________ is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.


A) AutoReport
B) form
C) AutoForm
D) wizard

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

Match the following Access file extensions with their definition. I.ACCDB II.ACCDT III.ACCDE IV.MDB V.MDE A.2007-2013 Access database files B.2002-2003 Access database files C.2002-2003 "execute only" Access database files D.2007-2013 "execute only" Access database files E.2007-2013 Access database templates

Correct Answer

verifed

verified

Each ________ in the query design grid shows information about the field.

Correct Answer

verifed

verified

Access is a(n)________ DBMS program created by Microsoft.

Correct Answer

verifed

verified

Access allows you to create an app database and either give it to others or put it on the ________.

Correct Answer

verifed

verified

You are reading a report that shows Company A generated $2,000 last week.This would be ________.


A) knowledge
B) a competitive advantage
C) data
D) information

E) None of the above
F) All of the above

Correct Answer

verifed

verified

Which of the following is NOT true about creating new databases?


A) When you create a new database,you can design it yourself starting with an empty database.
B) You can use a template; however,you need to create your own forms and reports.
C) If you design your own database,you develop the tables,fields,and the relationships between the tables.
D) If you build your own database,you need to decide what information you want to keep in your database,how this information should be grouped into tables,what relationships you need,and what queries and reports you need.

E) All of the above
F) C) and D)

Correct Answer

verifed

verified

Match the following objects with their definition. I.Table II.Form III.Report IV.Query V.View A.Used to enter,edit,delete or display records B.Provides an easy-to-read view of data C.Stores data in columns and rows D.Ask questions about the data E.Gives a different perspective

Correct Answer

verifed

verified

Showing 61 - 80 of 108

Related Exams

Show Answer