Brainscape's Knowledge GenomeTM

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


See full index

CIT 105 > Access > Flashcards

Access Flashcards

0
Q

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

A

Attachment

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

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

A

Gr*

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

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

A

True

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

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

A

OLE Object

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

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

A

False

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

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

A

True

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

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.

A

Caption

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

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

A

False

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

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

A

64

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

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

A

False

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

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

A

External Data

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

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

A

sort

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

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.

A

True

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

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

A

False

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

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

A

True

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

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

A

record

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

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

A

True

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

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

A

True

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

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

A

False

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

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.

A

Options

20
Q

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.

A

colon (:)

21
Q

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

A

Design View

22
Q

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

A

True

23
Q

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.

A

True

24
Q

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

A

True

25
Q

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

A

Compact & Repair

26
Q

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

A

False

27
Q

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.

A

False

28
Q

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.

A

False

29
Q

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

A

Format

30
Q

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.

A

Criteria

31
Q

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

A

Group By

32
Q

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

A

comparison operators

33
Q

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

A

False

34
Q

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

A

True

35
Q

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

A

databases

36
Q

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

A

True

37
Q

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

A

False.

38
Q

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

A

Print

39
Q

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

A

False

40
Q

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

A

Rename

41
Q

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

A

Landscape

42
Q

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

A

Click to Add

43
Q

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

A

True

44
Q

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.

A

Query Design

45
Q

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

A

primary key

46
Q

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.

A

False

47
Q

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

A

True

48
Q

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

A

Undo

CIT 105 (3 decks)

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