Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Biz Office Technology > Access 2016 > Flashcards

Access 2016 Flashcards

1
Q

*Which of the following is a database object you can use to enter, edit or display data from a table or query?

A

Form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

*Which of the tabs on the Ribbon contains the command to import data from an Excel workbook?

A

External Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

*Which tab holds the command to view the relationships in a database?

A

Database Tools

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

*Which of the following is a collection of information and objects associated with a specific subject?

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

*Which of the following is the process of rearranging records in a specified order or sequence?

A

Sorting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

*By creating a form using the Form Wizard, which of the following CANNOT be completed?

A

Choosing fields from a report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

*Which of the following is the main table of the relationship or the “one” side of the relationship in a one-to-many relationship?

A

Parent table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

*Which tab holds the option to back up a database?

A

File

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

*Which of the following is a formatted printout or screen display of the contents of one or more tables in a database?

A

Report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

*Which of the following is a single piece of information in a table?

A

Field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

*Which of the following views allows you to build the structure of the table but not enter data in the records?

A

Design

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

*Which of the following is a set of rules Access enforces between related tables when data is updated in a database?

A

Referential Integrity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

*Which of the following is a set of restrictions placed on the records to temporarily isolate a subset of records?

A

Filter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

*Which of the following filters data based upon data selected in a record or field?

A

Filter by selection

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

*Which of the following is a database object which allows you to ask the database about the information it contains?

A

Query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

*Which of the following is a collection of fields which store data?

A

Table

17
Q

*Which of the following describes Microsoft Access?

A

Database management system

18
Q

*Which of the following is a query based on more than one table?

A

Multi-table query

19
Q

*Which group on the Home tab holds the commands for changing the font of the text?

A

Text Formatting

20
Q

*Which group on the Home tab contains the command to replace data?

A

Find

21
Q

*Mercedes would like to name a field differently than the name of the field in her original table in the multi-table query she is creating. Which of the following would allow her to change the name from Company to Client in the query?

A

Client:Company

22
Q

*Louis would like to combine the data from two of his tables which contain the same fields. Which of the following queries should he use?

A

Append

23
Q

*Which of the following are complete sets of data and are the rows of the table?

A

Records

24
Q

*Which of the following is a field whose value uniquely identifies each record in a table?

A

Primary key

25
Q

*Which tab contains the ability to open the Query Wizard?

A

Create

Biz Office Technology (12 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions