Access is a ____.

Student ResponseCorrect Answer1.file management system2.workbook management system3.word processing software tool4.database management system

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

Student ResponseCorrect Answer1.database2.tuple3.object4.relation

____ words are words that have a special meaning to Access and cannot be used for the names of fields or tables.

Student ResponseCorrect Answer1.Significant2.Special3.Reserved4.Restricted

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

Student ResponseCorrect Answer1.642.323.2554.128

A field whose data type is ____ can contain any characters.

Student ResponseCorrect Answer1.Alpha2.Normal3.Lookup4.Text

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.

Student ResponseCorrect Answer1.Unlimited2.Memo3.Variable4.Character

A saved database is referred to as a ____.

Student ResponseCorrect Answer1.DBMS2.databook3.file4.template

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.

Student ResponseCorrect Answer1.tiered2.sublevel3.contextual4.subtype

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

Student ResponseCorrect Answer1.Add2.Create3.New4.Insert Table

10.

You only can delete a primary key in ____ view.

Student ResponseCorrect Answer1.Print Preview2.Design3.Datasheet4.Layout

11.

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

Student ResponseCorrect Answer1.Undo2.Cancel3.Back4.Escape

12.

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.

Student ResponseCorrect Answer1.Rename Field2.Change Field3.Rename Column4.Change Column

13.

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.

Student ResponseCorrect Answer1.Add Field2.Insert Column3.Add column4.Insert Field

14.

In the accompanying figure, the small box or bar to left of each field is called the ____.

Student ResponseCorrect Answer1.field bar2.field selector3.current field bar4.row selector

15.

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.

Student ResponseCorrect Answer1.primary key2.foreign key3.principal key4.main key

16.

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 ____.

Student ResponseCorrect Answer1.Home tab2.status bar3.Quick Access Toolbar4.title bar

17.

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu

Student ResponseCorrect Answer1.Table Design2.Design View3.Structure View4.Layout View

18.

To add a record to a table, click the ____ record button.

Student ResponseCorrect Answer1.Insert2.New (blank)3.Add New4.Last

19.

To quit Access, click the ____ button on the right side of the Access title bar.

Student ResponseCorrect Answer1.End2.Close3.Quit Access4.Quit

20.

To hide the Navigation Pane, click the ____ Button.

Student ResponseCorrect Answer1.Navigation Bar Show/Hide2.Hide Navigation Pane3.Shutter Bar Open/Close4.Close Pane

21.

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.

Student ResponseCorrect Answer1.Report View2.Print Preview3.Preview/Print4.Preview View

22.

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

Student ResponseCorrect Answer1.Orientation2.Landscape3.Switch Orientation4.Portrait/Landscape

23.

If a field has a Number data type, you can change the ____ property to Fixed to set a fixed number of decimal places.

Student ResponseCorrect Answer1.Field Size2.Format3.Caption4.Decimal

24.

To create a report using the Report Wizard, click ____ on the Ribbon and then click the Report Wizard button.

Student ResponseCorrect Answer1.Create2.Report3.New Object4.Insert

25.

A(n) ___ combines both a datasheet and a form.

Student ResponseCorrect Answer1.AutoForm2.split form3.simple form4.DataForm

26.

To back up a database, use the ____ command on the Office Button menu.

Student ResponseCorrect Answer1.Backup2.Options3.Manage4.Data Tools

27.

If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.

Student ResponseCorrect Answer1.Warning2.Customize3.Security4.Options

28.

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

Student ResponseCorrect Answer1.Open2.Run3.Design View4.Datasheet View

29.

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

Student ResponseCorrect Answer1.Quick Print2.Preview Query3.Run and Print4.Print Query

30.

You can click either the View button or the ____ button on the Ribbon to execute a query.

Student ResponseCorrect Answer1.Select2.Results3.Run4.Execute

31.

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.

Student ResponseCorrect Answer1.Select Query2.Query Design3.Design View4.Query

32.

Figure 2-1

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

Student ResponseCorrect Answer1.query grid2.show grid3.criteria grid4.design grid

33.

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.

Student ResponseCorrect Answer1.or2.Sort3.Show4.Criteria

34.

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.

Student ResponseCorrect Answer1.Be?2.Be&3.Be..4.Be*

35.

To find all individuals whose name is Tom or Tim, enter ____ in the Criteria row of the appropriate column.

Student ResponseCorrect Answer1.T$m2.T?m3.T#m4.T&m

36.

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 _____.

Student ResponseCorrect Answer1.square brackets [ ]2.parentheses ( )3.single quotes ''4.curly braces { }

37.

To save a query, click the Save button on the ____.

Student ResponseCorrect Answer1.Create tab on the Ribbon2.status bar3.Home tab on the Ribbon4.Quick Access Toolbar

38.

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.

Student ResponseCorrect Answer1.> 10,0002.> 100003.> $100004.> $10,000

39.

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.

Student ResponseCorrect Answer1.=$20,0002.20,0003.=20,0004.20000

40.

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.

Student ResponseCorrect Answer1.Show2.Order3.Criteria4.Sort

41.

To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.

Student ResponseCorrect Answer1.Off2.No3.Yes4.On

42.

Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.

Student ResponseCorrect Answer1.join2.concatenate3.merge4.combine

43.

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.

Student ResponseCorrect Answer1.semi-colon (:)2.exclamation point (!)3.equal sign (=)4.colon (:)

44.

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 ____.

Student ResponseCorrect Answer1.Resize2.Enlarge3.Magnify4.Zoom

45.

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.

Student ResponseCorrect Answer1.Format2.Caption3.Property Sheet4.Query

46.

To include the Total row in the design grid, click the _____ button on the Design tab.

Student ResponseCorrect Answer1.Aggregate2.Totals3.Statistics4.Calculations

47.

To find the average amount paid amount for a client, select _____ as the entry in the Total row for the Amount Paid column.

Student ResponseCorrect Answer1.Median2.AVG3.Average4.VAR

48.

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

Student ResponseCorrect Answer1.Group By2.Same3.Where4.Like

49.

To show the Navigation Pane if it is hidden, click the ____ Button.

Student ResponseCorrect Answer1.Show2.Shutter Bar Open/Close3.Show/Hide4.Restore

50.

To quit Access, click the ____ button on the right side of the Access title bar.

Student ResponseCorrect Answer1.Exit2.Close3.Quit4.Stop

Resources

Top Categories

Product

Company