Access - Ch 4

Question 1

Database object used to add data to or edit in a table

Answer 1

Form

Question 2

Used to create data entry forms for all sorts of tables

Answer 2

Form Tool

Question 3

Form Tool - Creates a form with a stacked layout that displays all fields in the record source

Answer 3

Form

Question 4

Form Tool - Creates new blank form in Design View

Answer 4

Form Design

Question 5

Form Tool - Creates a new blank form in Layout View

Answer 5

Blank Form

Question 6

Form Tool - Creates custom form based on your answers series of step-by-step questions

Answer 6

Form Wizard

Question 7

Form Tool - Creates user-interface forms that can also be used on internet

Answer 7

Navigation

Question 8

Form Tool - creates two-part form with a stacked layout in one section and tabular layout in the other

Answer 8

Split Form

Question 9

Form Tool - Creates tabular layout form that includes all of the fields from the record source

Answer 9

Multiple Items

Question 10

Form Tool - Creates a form that resembles the datasheet of a table or query

Answer 10

Datasheet

Question 11

Form Tool - Create custom dialog box that requires user input that is needed for a database object

Answer 11

Modal Dialog

Question 12

A table/query that supplies the records for a form or report

Answer 12

Record Source

Question 13

Displays fields in a vertical column for 1 record at a time

Answer 13

Stacked Layout

Question 14

Displays data horizontally across a page

Answer 14

Tabular Layout

Question 15

Text boxes, buttons, labels, etc. used to edit/add/delete data in a form or report

Answer 15

Controls

Question 16

Provides guides to help keep controls aligned horizontally & vertically

Answer 16

Layout Control

Question 17

User interface primarily used for data entry & modifications; cannot make changes to the form layout or design

Answer 17

Form View

Question 18

Enables you to change advance design settings that are not available in Layout View; gives more control over design

Answer 18

Design View

Question 19

Enables you to make changes to layout while also viewing data in the form; useful for testing functionality & adjusting sizes of controls (text boxes & labels)

Answer 19

Layout View

Question 20

Combines two views of the same record source; top is displayed stacked; bottom is displayed tabular

Answer 20

Split Form

Question 21

Displays multiple records in tabular layout

Answer 21

Multiple Items Form

Question 22

Defined set of colours, fonts, graphics, etc. that can be applied to forms & reports

Answer 22

Theme

Question 23

Document that displays information from a database in a format that outputs meaningful information

Answer 23

Report

Question 24

Report Tools - Create tabular report showing all fields in the record source

Answer 24

Report

Question 25

Report Tools - Create new blank report in Design View; add field/controls manually

Answer 25

Report Design

Question 26

Report Tools - /create new blank report in Layout View; drag & drop to add fields/controls manually

Answer 26

Blank Report

Question 27

Report Tools - Answer step-by-step questions to design custom report

Answer 27

Report Wizard

Question 28

Report Tools - Select a preformatted label template & create printable labels

Answer 28

Labels

Question 29

Enables you to view a report on screen in a continuous page layout; can filter data & change it

Answer 29

Report View

Question 30

Enables you to see exactly what the report will look like

Answer 30

Print Preview

Question 31

File type created for exchanging documents independently of software applications & operating systems

Answer 31

Portable Document Format (PDF)