Beh 225 week 3 checkpoint PowerPoint presentation of intelligence?

Answer 1

1.(Points: 2)Access is a ____.

1. file management system

2. workbook management system

3. word processing software tool

4. database management system

Save Answer

2.(Points: 2)In Access, a(n) ____ consists of a collection of tables, each of which contains information on a specific subject.

1. database

2. tuple

3. object

4. relation

Save Answer

3.(Points: 2)____ words are words that have a special meaning to Access and cannot be used for the names of fields or tables.

1. Significant

2. Special

3. Reserved

4. Restricted

Save Answer

4.(Points: 2)In Access, table and field names can be up to ____ characters in length.

1. 64

2. 32

3. 255

4. 128

Save Answer

5.(Points: 2)A field whose data type is ____ can contain any characters.

1. Alpha

2. Normal

3. Lookup

4. Text

Save Answer

6.(Points: 2)A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

1. Unlimited

2. Memo

3. Variable

4. Character

Save Answer

7.(Points: 2)A saved database is referred to as a ____.

1. DBMS

2. databook

3. file

4. template

Save Answer

8.(Points: 2)In addition to the top-level tabs, Access displays other tabs called ____ tabs that display when you perform certain tasks or work with certain objects such as datasheets.

1. tiered

2. sublevel

3. contextual

4. subtype

Save Answer

9.(Points: 2)One way to create a table, is to click ____ on the Ribbon and then click the Table button.

1. Add

2. Create

3. New

4. Insert Table

Save Answer

10.(Points: 2)You only can delete a primary key in ____ view.

1. Print Preview

2. Design

3. Datasheet

4. Layout

Save Answer

11.(Points: 2)To undo the most recent change to a table structure, click the ____ button on the Quick Access Toolbar.

1. Undo

2. Cancel

3. Back

4. Escape

Save Answer

12.(Points: 2)To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.

1. Rename Field

2. Change Field

3. Rename Column

4. Change Column

Save Answer

13.(Points: 2)To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click ____ on the shortcut menu.

1. Add Field

2. Insert Column

3. Add column

4. Insert Field

Save Answer

14.(Points: 2)In the accompanying figure, the small box or bar to left of each field is called the ____.

1. field bar

2. field selector

3. current field bar

4. row selector

Save Answer

15.(Points: 2)

Figure 1-2

In the accompanying figure, the key symbol that appears in the row selector for the Client Number field indicates that Client Number is the ____ for the table.

1. primary key

2. foreign key

3. principal key

4. main key

Save Answer

16.(Points: 2)

Figure 1-2

In the accompanying figure, you would save the changes to the structure of the table by clicking the Save button on the ____.

1. Home tab

2. status bar

3. Quick Access Toolbar

4. title bar

Save Answer

17.(Points: 2)To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu

1. Table Design

2. Design View

3. Structure View

4. Layout View

Save Answer

18.(Points: 2)To add a record to a table, click the ____ record button.

1. Insert

2. New (blank)

3. Add New

4. Last

Save Answer

19.(Points: 2)To quit Access, click the ____ button on the right side of the Access title bar.

1. End

2. Close

3. Quit Access

4. Quit

Save Answer

20.(Points: 2)To hide the Navigation Pane, click the ____ Button.

1. Navigation Bar Show/Hide

2. Hide Navigation Pane

3. Shutter Bar Open/Close

4. Close Pane

Save Answer

21.(Points: 2)To preview and then print a table, select the table, click the Office Button, point to the Print command arrow to display the Print submenu, and then click ____ on the Print submenu.

1. Report View

2. Print Preview

3. Preview/Print

4. Preview View

Save Answer

22.(Points: 2)To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.

1. Orientation

2. Landscape

3. Switch Orientation

4. Portrait/Landscape

Save Answer

23.(Points: 2)If a field has a Number data type, you can change the ____ property to Fixed to set a fixed number of decimal places.

1. Field Size

2. Format

3. Caption

4. Decimal

Save Answer

24.(Points: 2)To create a report using the Report Wizard, click ____ on the Ribbon and then click the Report Wizard button.

1. Create

2. Report

3. New Object

4. Insert

Save Answer

25.(Points: 2)A(n) ___ combines both a datasheet and a form.

1. AutoForm

2. split form

3. simple form

4. DataForm

Save Answer

26.(Points: 2)To back up a database, use the ____ command on the Office Button menu.

1. Backup

2. Options

3. Manage

4. Data Tools

Save Answer

27.(Points: 2)If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.

1. Warning

2. Customize

3. Security

4. Options

Save Answer

28.(Points: 2)To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

1. Open

2. Run

3. Design View

4. Datasheet View

Save Answer

29.(Points: 2)To print a query without first opening it, select the query in the Navigation Pane and then click the Office Button, point to Print on the Office Button menu, and then click ____ on the Print submenu

1. Quick Print

2. Preview Query

3. Run and Print

4. Print Query

Save Answer

30.(Points: 2)You can click either the View button or the ____ button on the Ribbon to execute a query.

1. Select

2. Results

3. Run

4. Execute

Save Answer

31.(Points: 2)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.

1. Select Query

2. Query Design

3. Design View

4. Query

Save Answer

32.(Points: 2)

Figure 2-1

In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.

1. query grid

2. show grid

3. criteria grid

4. design grid

Save Answer

33.(Points: 2)

Figure 2-1

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

1. or

2. Sort

3. Show

4. Criteria

Save Answer

34.(Points: 2)

Figure 2-1

In the accompanying figure, you can find all clients whose names begin with Be, by entering _____ in the Criteria row of the Client Name field.

1. Be?

2. Be&

3. Be..

4. Be*

Save Answer

35.(Points: 2)To find all individuals whose name is Tom or Tim, enter ____ in the Criteria row of the appropriate column.

1. T$m

2. T?m

3. T#m

4. T&m

Save Answer

36.(Points: 2)To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in _____.

1. square brackets [ ]

2. parentheses ( )

3. single quotes ''

4. curly braces { }

Save Answer

37.(Points: 2)To save a query, click the Save button on the ____.

1. Create tab on the Ribbon

2. status bar

3. Home tab on the Ribbon

4. Quick Access Toolbar

Save Answer

38.(Points: 2)

Figure 2-2

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is greater than $10,000.00, erase the 0 and enter _____ in the Criteria row of the Current Due column.

1. > 10,000

2. > 10000

3. > $10000

4. > $10,000

Save Answer

39.(Points: 2)

Figure 2-2

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $20,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

1. =$20,000

2. 20,000

3. =20,000

4. 20000

Save Answer

40.(Points: 2)To sort records in a query, specify the sort order in the _____ row of the design grid below the field that is the sort key.

1. Show

2. Order

3. Criteria

4. Sort

Save Answer

41.(Points: 2)To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.

1. Off

2. No

3. Yes

4. On

Save Answer

42.(Points: 2)Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.

1. join

2. concatenate

3. merge

4. combine

Save Answer

43.(Points: 2)To include calculated fields in queries, enter a name for the calculated field, a(n) _____, and then the expression in one of the columns in the Field row.

1. semi-colon (:)

2. exclamation point (!)

3. equal sign (=)

4. colon (:)

Save Answer

44.(Points: 2)To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

1. Resize

2. Enlarge

3. Magnify

4. Zoom

Save Answer

45.(Points: 2)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.

1. Format

2. Caption

3. Property Sheet

4. Query

Save Answer

46.(Points: 2)To include the Total row in the design grid, click the _____ button on the Design tab.

1. Aggregate

2. Totals

3. Statistics

4. Calculations

Save Answer

47.(Points: 2)To find the average amount paid amount for a client, select _____ as the entry in the Total row for the Amount Paid column.

1. Median

2. AVG

3. Average

4. VAR

Save Answer

48.(Points: 2)To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.

1. Group By

2. Same

3. Where

4. Like

Save Answer

49.(Points: 2)To show the Navigation Pane if it is hidden, click the ____ Button.

1. Show

2. Shutter Bar Open/Close

3. Show/Hide

4. Restore

Save Answer

50.(Points: 2)To quit Access, click the ____ button on the right side of the Access title bar.

1. Exit

2. Close

3. Quit

4. Stop

Save Answer