Access - Ch 4 Flashcards
Database object used to add data to or edit in a table
Form
Used to create data entry forms for all sorts of tables
Form Tool
Form Tool - Creates a form with a stacked layout that displays all fields in the record source
Form
Form Tool - Creates new blank form in Design View
Form Design
Form Tool - Creates a new blank form in Layout View
Blank Form
Form Tool - Creates custom form based on your answers series of step-by-step questions
Form Wizard
Form Tool - Creates user-interface forms that can also be used on internet
Navigation
Form Tool - creates two-part form with a stacked layout in one section and tabular layout in the other
Split Form
Form Tool - Creates tabular layout form that includes all of the fields from the record source
Multiple Items
Form Tool - Creates a form that resembles the datasheet of a table or query
Datasheet
Form Tool - Create custom dialog box that requires user input that is needed for a database object
Modal Dialog
A table/query that supplies the records for a form or report
Record Source
Displays fields in a vertical column for 1 record at a time
Stacked Layout
Displays data horizontally across a page
Tabular Layout
Text boxes, buttons, labels, etc. used to edit/add/delete data in a form or report
Controls
Provides guides to help keep controls aligned horizontally & vertically
Layout Control
User interface primarily used for data entry & modifications; cannot make changes to the form layout or design
Form View
Enables you to change advance design settings that are not available in Layout View; gives more control over design
Design View
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)
Layout View
Combines two views of the same record source; top is displayed stacked; bottom is displayed tabular
Split Form
Displays multiple records in tabular layout
Multiple Items Form
Defined set of colours, fonts, graphics, etc. that can be applied to forms & reports
Theme
Document that displays information from a database in a format that outputs meaningful information
Report
Report Tools - Create tabular report showing all fields in the record source
Report
Report Tools - Create new blank report in Design View; add field/controls manually
Report Design
Report Tools - /create new blank report in Layout View; drag & drop to add fields/controls manually
Blank Report
Report Tools - Answer step-by-step questions to design custom report
Report Wizard
Report Tools - Select a preformatted label template & create printable labels
Labels
Enables you to view a report on screen in a continuous page layout; can filter data & change it
Report View
Enables you to see exactly what the report will look like
Print Preview
File type created for exchanging documents independently of software applications & operating systems
Portable Document Format (PDF)