Unit 3 Access

Question 0

What does database design refer to?

Answer 0

The arrangement of data into tables and fields

Question 1

What is a data sheet?

Answer 1

A collection of rows and columns

Question 2

What is the purpose of the Key Tip?

Answer 2

To select a command using the keyboard

Question 3

What are fields?

Answer 3

Contain a specific piece of information within a record

Question 4

What is the office button?

Answer 4

Central location for managing and sharing database objects

Question 5

What is the first step in planning a database?

Answer 5

Data entry

Question 6

What is a gallery?

Answer 6

Set of choices, often graphical,mar ranged in a grid or list

Question 7

What does a database allow you to do with the data?

Answer 7

Organizes it so it can be accessed, retrieved, and used

Question 8

What is Access?

Answer 8

Database management system

Question 9

Where is the vertical scroll bar located?

Answer 9

Right edge of window

Question 10

What is the insertion point?

Answer 10

Blinking vertical bar indicating where text or pictures will be inserted

Question 11

What is a file?

Answer 11

A saved database

Question 12

What are database properties,

Answer 12

Details about the file

Question 13

What is redundancy?

Answer 13

Storing the same fact in more than one place

Question 14

How do you view a data sheet and a form simultaneously?

Answer 14

Split form

Question 15

What does the data type do?

Answer 15

Indicates the type of data that can be used in a field

Question 16

What does landscape orientation allow you to do?

Answer 16

Printout will be across the length of the paper

Question 17

What are records?

Answer 17

Rows in the table

Question 18

What are choices for yes/no field?

Answer 18

Yes/no, true/false, and on/off

Question 19

What is a primary key?

Answer 19

Unique identifier

Only appears in a single record in the database

Question 20

What would be a good primary key for a book database?

Answer 20

ISBN number

Question 21

What is a row selector?

Answer 21

The small box you click to select the entire row

Question 22

Where are commands located

Answer 22

Menu, the ribbon

Question 23

How do you display a shortcut menu?

Answer 23

Right click

Question 24

What is a task pane?

Answer 24

Window that can remain open while you work in the database

Question 25

What does the AND criterion require?

Answer 25

Each individual criterion must be true

Question 26

Where must the criteria go when combining criteria with OR?

Answer 26

Separate lines

Question 27

What is the sort key?

Answer 27

Field/fields that records are sorted for

Question 28

What is a common restrictions?

Answer 28

Exclude duplicates

Question 29

What words imply a descending order?

Answer 29

Decreasing, descending, high to low

Question 30

How is the minor key determined within a sort?

Answer 30

The field on the right

Question 31

What property must be changed to omit duplicates?

Answer 31

Unique values (change to yes)

Question 32

What must records in the two tables posses in order to be joined?

Answer 32

A common field

Question 33

What is a calculated field?

Answer 33

Field that can be computed from other fields

Question 34

What is grouping?

Answer 34

Creating groups of records that share a common characteristic

Question 35

Which view is most often used when creating queries?

Answer 35

Design view

Question 36

What are wildcards?

Answer 36

Symbols that represent any character or combination of characters

Question 37

What is a wildcard for a individual letter called?

Answer 37

A question mark (?)

Question 38

What is a parameter query?

Answer 38

Query that prompts for input whenever it is used

Question 39

In what must a value be enclosed when making a parameter query?

Answer 39

Square brackets

Question 40

What is the first step when working with putting data in a special order?

Answer 40

Determine whether sorting is required

Question 41

What comparison operator is NOT used in Access?

Answer 41

Not equal to

Question 42

What is sorting?

Answer 42

To order the records to the answer to a query in a particular way

Question 43

What is the first step when designing a query?

Answer 43

Click query design

Question 44

What is the Zoom dialog box used for?

Answer 44

To enter calculated fields

Question 45

What is a query?

Answer 45

A question presented in a way access can process?

Question 46

What are the two query views?

Answer 46

Data sheet view and design view

Question 47

What are the ways to view query results?

Answer 47

Run/ view

Question 48

What are the stood in the Query Wizard?

Answer 48

1. Pick type of query 2. Select fields 3. Give it a name