Marquee Access 2007, Section 1

Knowledge Check Answer Key

1.	This term describes a single component of information about a person, place, item, or object.	field	page 5
2.	This object stores all of the related records for one logical group.	table	page 5
3.	Click this button at the Column Width dialog box to set the column width to the length of the longest entry in the column.	Best Fit	page 7
4.	Press this key to turn on Edit mode in a datasheet.	F2	page 8
5.	Use either of these two keys to move to the next column when typing data in a new record in the datasheet.	Tab or Enter	page 10
6.	This object provides a user-friendly interface with which you can edit, view, or print data by working with only one record at a time.	form	page 12
7.	Access displays a message box requesting confirmation when a record is about to be deleted because this feature is not available for a Delete operation.	Undo	page 14
8.	When more than one column is selected for a sort operation, Access sorts first by this column.	leftmost column in selection	page 16
9.	This feature temporarily hides records in the datasheet that do not meet the specified criteria.	filter	page 18
10.	This page layout orientation rotates the printout to print wider than it is tall.	landscape	page 21
11.	Display this dialog box to set your own custom margins.	Page Setup	page 21
12.	This keyboard command selects all records in the datasheet.	Ctrl + A	page 23
13.	These are the steps to hide a column in a datasheet.	Right-click field name (or column heading) and click Hide Columns at shortcut menu.	page 23
14.	This feature defragments a database file to reduce the disk space the database requires.	Compact and Repair	page 24
15.	When backing up a database, if you accept the default options at the Save As dialog box, this is added to the end of the original database file name to differentiate the backup file.	current date after an underscore character	page 25

Marquee Access 2007, Section 2

Knowledge Check Answer Key

1.	Display a table in this view to modify a field’s properties.	Design view	page 36
2.	Assign a field this data type if the field will contain dollar values that you do not want rounded off in calculations.	Currency	page 39
3.	This is the term for the field in a table that must contain unique information for each record.	primary key	page 39
4.	Enter a value in this field property if you want the value to appear automatically in the field whenever a new record is created.	Default Value	page 40
5.	Enter a conditional statement in this field property to prevent data that does not meet the criteria from being entered into the field.	validation rule	page 42
6.	This is the field property that controls data as it is being entered by ensuring data typed in the field conforms to the code entered in the property box.	Input Mask	page 44
7.	This field property controls how data is displayed after it has been accepted for entry in the field.	Format	page 44
8.	This is the name of the wizard used to create a drop-down list in a field.	Lookup	page 46
9.	This button can be used to add a SUM function to the bottom of a numeric field in the datasheet.	Totals	page 49
10.	One table in a relationship is referred to as the primary table. The other table is referred to as this.	related	page 50
11.	In this type of relationship one table can have only one record with a matching field value in the common field while the other table can have several records with a matching field value.	one-to-many	page 50
12.	This is the term for the black line that displays between the common field name in the two field list boxes after a relationship has been created.	join line	page 51
13.	This type of relationship is created when the field used to join the two tables is the primary key in both tables.	one-to-one	page 52
14.	Once a relationship has been created between two tables you can open the primary table and click this button to display the subdatasheet.	Plus symbol, or expand indicator	page 54
15.	Open this dialog box to specify the table that you want the subdatasheet to be generated from when the primary table has more than one relationship defined.	Insert Subdatasheet	page 55

Marquee Access 2007, Section 3

Knowledge Check Answer Key

1.	This is the name of the wizard used to facilitate creating a query to select records from a table.	Simple Query Wizard	page 66
2.	Click this button to show the query results datasheet after creating a query using Design view.	Run or Datasheet view	page 69
3.	Type this entry in the Annual_Salary criteria row in the query design grid to extract records of employees who earn more than $40,000.	>40000	page 71
4.	Click the check box in this row in the query design grid to prevent a column from being displayed in the query results datasheet.	Show	page 71
5.	This entry in a blank Field box in the query design grid would add the values in a field named RegHours to the values in a field named OTHours and title the column in the query results datasheet TotalHours.	TotalHours:[RegHours]+[OTHours]	page 74
6.	Click this button in the Query Tools Design tab to change a field’s format to display in Currency.	Property Sheet	page 75
7.	Create a form using this method if you want the ability to specify the form’s layout and style before the form is generated.	Form Wizard	page 76
8	This type of form displays in two views in the work area: Datasheet view and Form view.	split form	page 76
9.	Modify a form in this view.	Layout view	page 78
10	A form or report is comprised of a series of objects referred to by this term.	controls	page 78
11.	A form created using the Form tool adds this object next to the title so you can easily add an image such as a company logo.	logo container	page 78
12.	This button opens the Field List task pane to add fields to a form.	Add Existing Fields	page 81
13.	List two items that are added to the top of a report automatically when the report is generated using the Report tool.	Any two of: image container, title, date, time	pages 82–83
14.	A report’s page orientation can be changed from portrait to landscape in this view.	Print Preview or Layout View with the Report Layout Tools, Page Setup tab	page 85
15.	A column in a report can be moved or resized by first clicking here.	column heading or field name	page 86

Marquee Access 2007, Section 4

Knowledge Check Answer Key

1.	Click this button in the Query Tools Design tab to add a row to the design grid from which you can choose an aggregate function such as Sum.	Totals	page 98
2.	This query wizard can be used to sum data that is grouped by two fields.	Crosstab Query Wizard	page 100
3.	This is the name of the view in which you can create an interactive table that organizes and summarizes data based on fields you drag and drop for row and column headings.	PivotTable view	page 102
4.	Create this type of chart by dragging fields from a Field List box to Filter, Data, and Category sections.	PivotChart	page 104
5.	Start this query wizard if you suspect someone has added a record twice in the same table.	Find Duplicates Query Wizard	page 106
6.	Use this query wizard to produce a datasheet showing names and telephone numbers from a Customer table for those customers that have no record in a related Orders table.	Find Unmatched Query Wizard	page 108
7.	Open a form or report in this view to add a calculation.	Design view	page 110
8.	A calculation added to a form or report is started by clicking this button and dragging to create the outline of a control object.	Text Box	page 110
9.	Descriptive text can be added to a form or report using this button.	Label	page 110
10.	To format a calculated control object to display the values in Currency format, open this task pane.	Property Sheet	page 111
11.	To sort records in a form display the form in this view.	Form view	page 113
12.	Hold down this key to select multiple objects in a form or report.	Shift	page 115
13.	Buttons to align a group of selected objects in a report at the same top, left, bottom, or right position are found in the Control Alignment group of this tab.	Report Design Tools Arrange	page 116
14.	To sort records in a report display this pane.	Group, Sort, and Total	page 117
15.	These are databases that have tables, queries, forms, and reports already created for you.	database templates	page 118