Access

Question 0

A field with the _____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

Answer 0

Attachment

Question 1

To find all clients whose names begin with Gr, enter _______ in the Criteria row of the Client Name field.

Answer 1

Gr*

Question 2

True or False. Landscape orientation means the printout is across the length (height) of the page.

Answer 2

True

Question 3

A field whose data type is _______ can store an OLE object, which is an object linked to or embedded in the table.

Answer 3

OLE Object

Question 4

True or False. The Database Tools tab provides commands to compact and repair a database.

Answer 4

False

Question 5

True or False. Cross tab queries are useful for summarizing data.

Answer 5

True

Question 6

To change the caption for a field in a query, click the field in the design grid, click the ______ button on the Design tab, click the Caption box, and enter the new caption.

Answer 6

Caption

Question 7

True or False. A query that prompts for input whenever it is run is a run-time query.

Answer 7

False

Question 8

In Access, table and field names can be up to _______ characters in length.

Answer 8

64

Question 9

True or False. When tables are joined in a query, it is not possible to restrict retrieval by using criteria.

Answer 9

False

Question 10

To import data to a table, click the ______ tab on the Ribbon.

Answer 10

External Data

Question 11

To order the records in the answer to a query in a particular way you _______ the records.

Answer 11

sort

Question 12

True or False. To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City Field.

Answer 12

True

Question 13

True or False. To restrict the objects that appear on the Navigation Pane use the Restrict Bar.

Answer 13

False

Question 14

True or False. When Access first creates a database, it automatically creates a table.

Answer 14

True

Question 15

A _______ contains information about a given person, product, or event.

Answer 15

record

Question 16

True or False. In Access, the rows in the table are called records.

Answer 16

True

Question 17

True or False. To rename a field, right-click the column heading for the field, and then click Rename Field on the shortcut menu.

Answer 17

True

Question 18

True or False. The only calculated fields you can create in Access are those involving addition.

Answer 18

False

Question 19

To specify AutoCorrect rules and exceptions to the rules, click File to open the Backstage view, click _________, and then click Proofing in the dialog box that displays.

Answer 19

Options

Question 20

To include calculated fields in queries, enter a name for the calculated field, a _______, and then the expression in one of the columns in the Field row.

Answer 20

colon (:)

Question 21

To change the design of a query, right-click the query in the Navigation Pane and then click _____ on the shortcut menu.

Answer 21

Design View

Question 22

True or False. Grouping means creating groups of records that share some common characteristic.

Answer 22

True

Question 23

True or False. To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

Answer 23

True

Question 24

True or False. Redundancy is the storing of a piece of data in more than one place.

Answer 24

True

Question 25

To compact and repair a database, click the _______ button in the Information gallery in the Backstage view.

Answer 25

Compact & Repair

Question 26

True or False. Report view shows a report on the screen and allows the user to make changes to the report.

Answer 26

False

Question 27

True or False. To find all clients whose amount paid is greater than $1,000.00 or whose business analyst is analyst 11, enter each criterion on the same line.

Answer 27

False

Question 28

True or False. If you specify more than one sort key, the sort key, on the left will be the minor sort key and the one on the right will be the major sort key.

Answer 28

False

Question 29

To show the symbol for the Euro instead of the dollar sign, change the _________ property for the field whose data type is Currency.

Answer 29

Format

Question 30

In the accompanying figure, you can enter BC76 in the ________ row of the Client Number field to find all clients whose client number is BC76.

Answer 30

Criteria

Question 31

To indicate grouping in Access, select _______ as the entry in the Total row for the field to be used for grouping.

Answer 31

Group By

Question 32

Less than (), and NOT (not equal to) are examples of __________.

Answer 32

comparison operators

Question 33

True or False. In Access, table names cannot contain digits.

Answer 33

False

Question 34

True or False. A property sheet is a window containing the various properties of the object.

Answer 34

True

Question 35

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a _________.

Answer 35

databases

Question 36

True or False. An inner join is the default join in Access.

Answer 36

True

Question 37

True or False. You cannot create a form for a query.

Answer 37

False.

Question 38

To print the results of a query that is open, click File on the _____ tab in Backstage view, and then click Quick Print.

Answer 38

Print

Question 39

True or False. A soft copy is information that exists on a physical medium such as paper.

Answer 39

False

Question 40

To rename a database object, right-click the object in the NavigationPane and the click ______ on the shortcut menu.

Answer 40

Rename

Question 41

To change the print operation from portrait to landscape, click the ______ button on the Print Preview tab.

Answer 41

Landscape

Question 42

To define an additional field in Datasheet view, click the _________ column heading.

Answer 42

Click to Add

Question 43

True or False. The expression for a calculated field can be typed directly into the Field row.

Answer 43

True

Question 44

To create a new query in Design view, click Create on the Ribbon to display the Create tab and then click the _________ button to create a new query.

Answer 44

Query Design

Question 45

In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number is the ________ for the table.

Answer 45

primary key

Question 46

True or False. The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

Answer 46

False

Question 47

True or False. The maximum number of characters allowed in a field whose data type is 255 characters.

Answer 47

True

Question 48

To undo the most recent change to a table structure, click the ______ button on the Quick Access Toolbar.

Answer 48

Undo