Access Flashcards Flashcards

Foreign key
Terms Definitions
What are mass updates?a. Updating many fields in a single operation.b. Updating many records in a single operationc. Updating all fields in a single operation.d. Updating all records in a single operation.
b. Updating many records in a single operation.
What does maintaining the database mean? . Includes changing records, b. Changing the design of fieldsc. Modifying the data to keep it up-to-date.d. Modifying the data to keep it up-to-date such as adding new record, changing data for e
d. Modifying the data to keep it up-to-date such as adding new record, changing data for existing data, and deleting records and can include mass updates to many records at the same time.
Maintaining a database can involve:b. changing characteristics of a tablec. creating indexesd. restructure the database periodically.
d. restructure the database periodically.
What is restructuring the database?a. changing the database structureb.adding and deleting fields to a table c. changing the characteristics of existing fields and creating indexes.d. all of the above
d. all of the above
Indexes are they used for?a. table of contents - tells you where to lookb. similar to what is found in back of books - improves the efficiency of certain operationsc. involve quite a lot of administration to maintaind. Once created can'
b. similar to what is found in back of books - improve the efficiency of certain operations
If you need help, use the ___________on the menu bar in the upper right corner of the window.a. Type a question for help boxb. Office Assistant boxc. Help commandd. Question command
A. Type a question for help box
To obtain a printed copy of your relationships, click the Relationships button, then click File on the menu bar and select_______________.A. PrintB. Print RelationshipsC. Print PreviewD. Page Setup
B. Print Relationships
A field in one table whose values are required to match the primary key in another table is called __________.A. Special KeyB. format keyC. referential keyD. foreign key
D. foreign key
You can use the ____________query to remove multiple records at one time.A. deleteB. updateC. appendD. remove
A. delete
To remove a filter, click the __________button on the Table Datasheet toolbar.A. DeleteB. Undo FilterC. Delete FilterD. Remove Filter
D: Remove Filter
Before making any changes to a database, it is a good idea to _____________the database.A. make a copy ofB. sort the records inC. check the spelling inD. compact
A. make a copy of
To remove wasted space from a database, you must _____________the database.A. deleteB. compactC. cleanD. repair
B. Compact
A__________allows you to select from a list of values.A. Look tableB. Lookup fieldC. Data listD. Client Field
B. Lookup field
To update all records, use the _________query.A. insertB. updateC. appendD. make-table
B. Update
Click the __________button to filter records based on values in more than one field.A. Filter by FieldB. Filter by SelectionC. Apply FilterD. Filter by Form
D. Filter by Form
You can use __________to view records and update data in a table.A. Sheetdata viewB. Form viewC. Edit viewD. Normal view
B. Form view
You could create an index on a field if__________.A. you occasionally will need your data to be sorted on the field.B. the field is the foreign key in a relationship you have created.C. you occasionally will need to locate a record base
B. the field is the foreign key in a relationship you have created.
Use____to modify the design layout of a report.A. Design viewB. Layout viewC. Report viewD. Modify view
A. Design View
Bount controls have ___________that usually display the name of the field that provides the data for the control.A. attached labelsB. bound labelsC. control labelsD. field labels
A. attached labels
A__________is printed after a group of records.A. group footerB. detailed sectionC. page footerD. control page
A. group footer
____________a control is a way to produce the control;s property sheet.A. Right-clickingB. DraggingC. ClickingD. Double-clicking
D. Double-clicking
Clicking a control a second time produces a(n) _____________to let you modify its contents.A. dialog boxB. insertion pointC. text boxD. wizard
B. insertion point
Which of the following is not a possible view in the Report window?A. Design viewB. Print PreviewC. Layout ViewD. Data View
D. Data View
Use___________to view a report's layout.A. Layout PreviewB. Print PreviewC. Outline ViewD. Data view
A. Layout Preview
To add a calculated control, use the ___________tool in the toolbox, and place the calculated control in the appropriate section on the report.A. BoxB. Calculated controlC. Text BoxD. Control Box
C. Text Box
___________are used to display data that is calculated from other data in the database.A. Unbound controlsB. Attached labelsC. Bound controlsD. Calculating controls
D. Calculating controls
To resize a column, click Column Width on the _____menu. A. FormatB. EditC. ToolsD. Size
A. Format
________ensures that the value in a foreign key must match that of another table's primary key.A. Referiential IntegrityB. Foreign key integrityC. Reference IntegrityD. Property integrity
A. Referential integrity
To delete a record, select the desired record, press the DELETE key, then click the _______buton in the dialog box.A. DeleteB. OKC. Yes D. No
C. Yes
Looking for records that satisfy some criteria is called___________.A. lookingB. sortingC. groupingD. searching
D. searching
To add a field to a table, click the___________on the Table Design toolbar.A. Insert Rows buttonB. Rows buttonC. add Rows buttonD. Edit Rows button
A. Insert Rows button
In a _________relationship, one record in the first table matches many records in the second table, but each record in the first table is related to only one record in the first.A. one-to-oneB. one-to-severalC. one-to-manyD. many-
C. one-to-many
To specify a required field, click the_________in the Field Properties pane.A. Default property boxB. Validation Rule boxC. Required property boxD. Field Command
C. Required property box
To change to Overtype mode, press the_________key.A. ESCB. INSERTC. HOMED. TAB
B. INSERT
Indexes whose key is a combination of fields are called ________indexes.A. single-fieldB. many-fieldC. multiple-fieldD. several-field
C. multiple field
A query that makes changes to many records in one operation is called a(n)___________.A. active queryB. mass queryC. action queryD. fast query
C. action query
To allow all the data in a field to display, you ____________the column in the datasheet.A. openB. dragC. resizeD. click
C. resize
Modifying a database and keeping it up to date is known as __________the database.A. sortingB. purgingC. correctingD. maintaining
D. maintaining
_______is the text message that will appear if a user violates a validation rule.A. Validation textB. Validation rulesC. Error textD. Error rules
A. Validation text
Access automatically creates an index on the ___________of the table.A. primary keyB. foreign keyC. sort keyD. index key
A. primary key
A field in which the user must enter data is called a_______________.A. validation fieldB. required fieldC. default valueD. default field
B. required field
To add a group of records from one table to the end of anohter table, use the ___________query.A. deleteB. updateC. appendD. add-table
C. append
To specify a default value, enter the value in the ______________.A. Values boxB. Default Value property boxC. Field property boxD. Validation Value box
B. Default Value property box
Use the___________to go directoy to a record by giving the value in a field.A. Look buttonB. Locate buttonC. Find buttonD. Search button
C. Find button
If yu wish to see several records at one time, switch from Form view to ___________view.A. NormalB. DatasheetC. DatabaseD. Records
B. Datasheet
The Find Unmatched Query Wizard helps you find___________records.A. printedB. unmatchedC duplicateD. multiple
B. unmatched
To specify referential integrity, you must define a relationship between the tables using the _____command.A. DefineB. SpecifyC. Referential IntegrityD. Relationship
D. Relationships
To delete a field, open the table in__________view, click the row selector to the field, then press the DELETE key.A. FormB. DatasheetC. TableD. Design
D. Design
The field or fields on which an index is built is called the__________.A. primary keyB. major keyC. index keyD. sort key
C. index key
To return a damaged or destroyed database to a correct state is called______________.A. indexingB. formattingC. recoveryD. backing up
C. recovery
To specify referential integrity, you must define a relationship between the tables using the_________commnad.A. DefineB. SpecifyC. Referential Integrity\D. Relationships
D. Relationships
To change the size of a field, click the row selector for the desired field, press_______, then type the new size.A. F2B. F8C. F5D. F6
D. F6
Tp create indexes, click indexes on the _________menu.A. ToolsB. EditC. FormatD. View
D. View
The field or fields on which an index is buit is called the__________________.A. primary keyB. major keyC. index keyD. sort key
C. index key
A9n)_______is the most common structure for high-performance.A. A-treeB. B-treeC. C-treeD. 4-tree
B. B-tree
The names, types and sizes of all the fields define the ____________of a database.A. sizeB. propertiesC. valuesD. structure
D. structure
To preview what your report looks like with actual data, use__________.A. Design viewB. Data viewC. Print PreviewD. Actual view
C. Print Preview
A common term for the sections of a report is______________. A. objectsB. bandsC. controlsd. dock
B. bands
by default, Access assigns a __________to calculated field.A. general formatB. Currency formatC. Special formatD. Decimal format
A. general format
A_________is printed before the records in a particular group are printed.A. group headerB. subtotalC. group footerD. control
A. group header
To change the appearance of a label, right-click the label and click_________on the shortcut menu.A. Build EventB. Change FontC. FormatD. Properties
D. Properties
To obtain help entering the expression for a field you are adding, use the___________.A. Expression HelperB. Expression BuilderC. Expression ToolD. Expression Source
B. Expression Builder
___is the process used for moving toolbars to different positions on the screen.A. DockingB. ShiftingC. AlternatingD. Minimized
A. Docking
The contents of the ____________will print once at the beginning of a report.A. Report header sectionB. Report Footer sectionC. Report Title sectionD. Detail Section
Report Header Section
With a__a user can select an item from a list of possible values.A. Text boxB. controlC. combo boxD. Format property
C. combo box
With a___________a user can select an item from a list of possible values.A. Text boxB. controlC. combo boxD. Format property
C. combo box
_____________are boxes that allow you to select entries from a list.A. Combo boxesB. Custom boxesC. Entry boxesD. Form boxes
A. Combo boxes
To resize a control, ________one of the sizing handles.A. clickB. double-clickC. right-clickD. drag
D. drag
To print a selected report, ___________the report, then click Print one the shortcut menu.A. clickB. right-clickC. double-clickD. open
B. right-click
________are not associated with data from the database.A. Bound controlsB. Attached labelsC. Unbound controlsD. Calculating controls
C. Unbound controls
The various rectangles on a form are calledA. boundariesB. form contentsC. attachmentsD. controls
D. controls
The mouse pointer shape changes to a _________to indicate a control can be dragged.A. crosshairB. plus signC. handD. minus sign
C. hand
Each portion of a report is described in what is termed a(n)_________.A. objectB. sectionC. controlD. grouping
B. section
To add a title to a form, use the ________tool in the toolbox to place the title on the Form Header Sectin.A. LabelB. TitleC. Form LabelD. Create Title
A. Label
The contents of the ________print once at the end of the report.A. Report Header SectionB. Detail SectionC. Page Footer SectionD Report Footer Section
D. Report Footer Section
By default, access assigns a _________to a calculated field.A. general formatB. Currency formatC. Special formatD. Decimal format
A. general format
With a_______a user can select an item from a list of possible values.A. Text boxB. controlC. combo boxD. Format Property
C. Combo box
___________are boxes that allow you to select entries from a list.A. Combo boxesB. Custom boxesC. Entry boxesD. Form boxes
A. Combo boxes
To print a selected report, ___________the report, then click Print on the shortcut menu.A. clickB. right-clickC. double-clickD. Open
B. Right-click
__________are not associated with data from the database.A. Bound controlsB. Attached labelsC. Unbound ControlsD. Calculated controls
C. Unbound controls
_________a control is a way to produce the control's property sheet.A. Right-clickingB. DraggingC. ClickingD. Double-clicking
D. Double-clicking
The contents of the________will print once at the beginning of a report.A. Report Header sectionB. Report Footer sectionC. Report Title sectionD. Detail section
A. Report Header section
Reports based on_________open faster than those based on____________.A. tables, queriesB. queries, tablesC. forms, tablesD. tables, forms
A. Tables, queries
The contents of the__________print once at the end of the report.A. Report Header sectionB. Detail sectionC. Page Footer sectionD. Report Footer section
D. Report Footer section
To remove unwanted controls, first select the control, then press the___________key.A. ENTERB. SHIFTC. DELETED. ESC
C. DELETE
To print a selected report, ___________the report, then click print on the shortcut menu.A. clickB. right-clickD. double-clicke. open
B. right-click
To obtain help enterint the expression for a field you are adding, use the__________.A. Expression HelperB. Expression BuilderC. Expression ToolD. Expresin Source
B. Expression Source
If you want to make a slight adjustment to a control, you can hold down the_____key and use the appropriate arrow keys.A. SHIFTB. CTRLC. INSERTD. HOME
A. SHIFT
The mouse pointer shape changes to a_______to indicate a control can be dragged.A. crosshairB. plus signC. handD. minus sign
C. hand
You can use___________to create a form totally from scratch.A. Design ViewB. the Form WizardD. AutoFormE. DesignForm
A. Design View
Access automatically formats fields from the database appropriately because it nows their__________.A. contentsB. dataC. data typesD. parameters
C. data types
The mouse pointer shape changes to a ____________accompanied by a label to indicate placement of a label.A. small minus signB. small handC. small plus signD. crosshair
C. Small plus sign
To close a database, click the _____________for the database.A. CloseB. ExitC. Close WindowD. Exit Database
C. Close Window
To place a combo box in a form, press the ________tool in the toolbox.A. Insert BoxB. Combo BoxC. Box WizardD. Controls
B. Combo Box
The process of creating separate collections of records sharing a common characteristic is called_____________.A. collectingb. groupingC. sortingD. merging
B. grouping
You can view two pages at the same time when previewing a report by clicking the__________button.A. Preview TwoB. Two PagesC. Multiple Pages\D. View Two
B. Two pages
The__________contain all the information on a report or form.A. captionsB. detailsC. headersD. controls
D. controls
To select multiple controls, click the first control, then hold down the ________key while you click each of the other controls.A. SHIFTB. ALTC. CTRLD. INSERT
A. SHIFT
/ 98
Term:
Definition:
Definition:

Leave a Comment ({[ getComments().length ]})

Comments ({[ getComments().length ]})

{[comment.username]}

{[ comment.comment ]}

View All {[ getComments().length ]} Comments
Ask a homework question - tutors are online