TF3.Forms, Queries, and Reports Are Examples of Database Objects

Access Starters

Thursday April 30, 2015
TF1.Any list you make for a specific purpose can be considered a simple database, even a grocery list.

TF2.By default, the Navigation Pane appears on the right side of the Access screen each time you create or open a database.

TF3.Forms, queries, and reports are examples of database objects.

TF4.The dialog box launcher contains the commands that you use most often, such as Save, Undo, and Redo.

TF5.When you press the Shift key, small letters and numbers called KeyTips appear on the Ribbon.

Monday May 4, 2015
1.In Access, a template is

a.a database to manage contacts. b.where a database is stored.

c.two tables linked together. da ready-to-use database.

2.When you create a new blank database, Access opens a database that contains

a.one of each type of database object. b.a table.

c.sample data. d.a template.

3.To save a database file in a location other than the default, click the

a.folder icon. b.blank database icon.

c.file name button. d.Help button.

Tuesday May 5, 2015
TF1.You can use the Navigation buttons to search for data in a table.

TF2.You can enter any kind of data into any field.

TF3.After you enter data and move to a new field, Access automatically saves the data for you in the table.

TF4.After you delete a record, you can click the Undo button to bring it back.

Wednesday May 6, 2015
4.The table structure is created when you

a.format the data. b.enter data.

c.query the data. d.create forms.

5.The Templates group commands are located on which tab?

a.Home b.Create

c.Database Toolsd.Datasheet

6.To copy a table, you must first select it in

a.the Clipboard.b.Microsoft Office Online.

c.the Navigation Pane. d.Datasheet view.

Thursday May 7, 2015
1.To rename a table or other database object, first

a.save it. b.close it. c.edit it. d.open it.

2.If you delete a database table,

a.you cannot undo the action. b.click Undo to restore the table.

c.it is still available in the Navigation Pane.

d.the data is transferred to the Clipboard.

3.A complete list of field properties is available in

a.the Navigation Pane. b.Datasheet view.

c.Design view. d.all of the above.

Friday May 8, 2015
4.Which of the following is not a field property?

a.Column Template b.Field Size c.Caption d.Allow Zero Length

5.Which field property requires users to enter data in a specific format?

a.Validation Text b.Default Value c.Required d.Input Mask

6.The Default Value property can be used for which field?

a.Short Text b.Number c.Currency d.All of the above

Monday May 11, 2015
7.Which of the following is not a way to validate data?

a.Data type b.Field sizes c.Filtering d.Field properties

8.The Caption field property is used for which field?

a.Short Text b.Attachment c.Date/Time d.All of the above

Tuesday May 12, 2015
TF1.A simple report contains all the records in a table or query.

TF2.You can edit the data in a report.

TF3.Click the Report button to define a record source.

TF4.In the Report Wizard, you can skip steps such as Sorting or

Grouping by clicking the Next button.

TF5.You can drag a field from the Field List pane to the design

grid to add it to the report.

Monday May 18, 2015
TF1.The easiest way to create a bound control is to double-click or drag a field from the Property Sheet to the report.

TF2.You can bind a control to a field using the Property Sheet.

TF3.You can turn off Control Wizards.

TF4.Display formatting can be applied to controls and labels in a form or report.

TF5.You can specify only one condition for conditional formatting.

Tuesday May 19, 2015
TF6.You can switch an entire control layout of a report or form from one type to the other.

TF7.Control padding adjusts the amount of space between a control and the gridlines of a layout.

TF8.The Remove Layout command in the Table group removes a control from a form or report.

TF9.You can use Print Preview to set the margins for a form or report.

TF10.Tab order refers to the order of tabs displayed in a dialog box.

Friday May 22, 2015
1. Which tool creates a customizable form that displays multiple records?

a.Query b.Subform c.Split Form d.Multiple Items

2.When you use the Multiple Items tool, the form that Access creates resembles a

a.control. b.datasheet. c.filter. d.query.

3.A split form shows your data in which views?

a.Form view and Datasheet view b.Layout view and Design view

c.Form view and Design view d.Layout view and Datasheet view

4.Which split form property allows you to define whether the datasheet appears above, below, to the left, or to the right of the form?

a.Split Form Orientation b.Split Form Datasheet c.Split Form Splitter Bar d.Split Form Size

5.Which type of form allows you to view data from more than one table or query on the same form?

a.Multi-item form b.Split form c.Subform d.Navigation form

Tuesday May 26, 2015
Lesson 11

TF1.Grouping intervals establish the way that records are grouped together.

TF2.You cannot group data in the Report Wizard.

TF3.Group headers take on the name of the group.

TF4.Group footers are optional in a report.

TF5.The arrows at the end of a Group On row determine sort order.

TF6.Average is an aggregate function.

TF7.The Totals command adds group footers and calculated controls for you.

TF8.You must preview a report before you can print.

TF9.You can modify labels in Design view.

TF10.Labels can be printed using reports.

Lesson 12
1.What type of query displays its results in a grid similar to an Excel worksheet?

a.Crosstab b.Append c.Aggregated d.Subquery

2.What can you use for a more intuitive interface in which to enter criteria or an expression in a field or criteria cell?

a.Zoom box b.Field list pane c.Control label d.Expression Builder

3.Which action query does not make changes to the data in the tables that it is based on?

a.Append b.Make table c.Update d.Delete

4.Which type of query can be thought of as a powerful version of the Search and Replace dialog box?

a.Filter b.Calculated field c.Update d.Crosstab

5.Which of the following is not a type of join?

a.Inner join b.Exterior join c.Cross join d.Unequal join

6.Which of the following is not an aggregated function?

a.Lowest b.Sum c.Average d.Count

7.Which of the following SELECT statement selects all the fields from the Inventory table?

a.SELECT all fields FROM Inventory b.SELECT [ALL] from [INVENTORY]

c.SELECT from INVENTORY {all fields} d.SELECT * FROM Inventory

8.For more space in which to enter the SELECT statement in a field or criteria cell, what do you press to display the Zoom box?

a.Shift+F2 b.Ctrl+2 c.Shift+Enter d.Ctrl+Spacebar

9.To display the pane used to format a calculated value in query Design view, click the ______in the Show/Hide group on the Design tab on the Ribbon.

a.Undo button b.Property Sheet button c.Datasheet view button d.Totals button

10.Which type of query adds the records in the query’s result set to the end of an existing table?

a.Append b.Make table c.Update d.Delete

Wednesday May 27, 2015

Lesson 13
TF1.You can choose from 20 different chart types in the Chart Wizard.

TF2.The Chart Wizard is a control.

TF3.A legend can be displayed only on the right side of a chart.

TF4.Microsoft Graph displays the chart and the datasheet of the underlying data source.

TF5.The Refresh All button displays an object’s Property Sheet.

TF6.The Refresh All button updates data in a chart with data modified in the underlying data source.

TF7.You can save a table as a report.

TF8.You can print tables, queries, forms, reports, or macros by right-clicking the object in the Navigation pane and selecting Print from the shortcut menu.

TF9.An Axis is a type of chart.

TF10.After you save a chart in Microsoft Graph, Microsoft Graph closes.

Lesson 14
1.Which tab contains options for importing or exporting data?

a.Manage Data b.Database Tools c.External Data d.Create

2.Before beginning an import operation, the source file should be

a.open. b.closed. c.copied. d.backed up.

3.If you want to add, edit, or delete data in a linked table, you must make the changes in the

a.first row of data. b. Access object. c.field headers. d.source file.

4.You can save an import or export operation involving any of the file formats supported in Access, but you cannot save the details of a

a.linking operation. b.text file import operation.

c.query export operation. d.fixed-width file.

5.The following is an example of what kind of text?

1, Fourth Coffee, Dana, Burnell, Sales Manager

a.HTML b.Linked c.Fixed-width d.Comma-delimited

6.How many database objects can you export in a single export operation?

a.One b.Two c.Three d.Unlimited

7.When you export an object to Word, Access creates what type of file?

a.MS-DOS Text b.Rich Text Format c.HTML d.Linked

8.If you choose to store imported data in a new table, Access

a.links the new table to an existing table.

b.overwrites the data in the existing table.

c.creates a table and adds the imported data to this table.

d.gives you an error message.

9.What is an advantage of linking an Access database to data in another program?

a.Maintaining a copy of the external data in Access

b.Being able to use Access querying and reporting tools

c.Being able to edit the linked table in Access

d.Easily being able to change the structure of the Access table

10.Which dialog box allows you to manage saved import and export specifications?

a.External Data b.Saved Specifications c.Import/Export Tasks

d.Manage Data Tasks

Lesson 15
TF1.Backing up files on a regular basis is really not necessary.

TF2.When you back up a database, Access automatically adds the date to the filename.

TF3.Compacting and repairing a database leaves the file fragmented.

TF4.Some database properties are updated by Access and cannot be changed.

TF5.The .accdb extension is for the Access 2002–2003 file format.

TF6.Access Options allow you to customize Access.

TF7.If you forget a password for a database, Microsoft can retrieve it for you.

TF8.You can print a report from the Database Documenter.

TF9.The Compact and Repair command allows you to find missing table links.

TF10.It is a good idea to back up a database before splitting it.