Access Flashcards

Start Studying!

Terms

undefined, object

copy deck

What are mass updates? a. Updating many fields in a single operation. b. Updating many records in a single operation c. 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 fields c. 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 table c. creating indexes d. restructure the database periodically.: d. restructure the database periodically.
What is restructuring the database? a. changing the database structure b.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 look b. similar to what is found in back of books - improves the efficiency of certain operations c. involve quite a lot of administration to maintain d. 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 box b. Office Assistant box c. Help command d. 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. Print B. Print Relationships C. Print Preview D. 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 Key B. format key C. referential key D. foreign key: D. foreign key
You can use the ____________query to remove multiple records at one time. A. delete B. update C. append D. remove: A. delete
To remove a filter, click the __________button on the Table Datasheet toolbar. A. Delete B. Undo Filter C. Delete Filter D. Remove Filter: D: Remove Filter
Before making any changes to a database, it is a good idea to _____________the database. A. make a copy of B. sort the records in C. check the spelling in D. compact: A. make a copy of
To remove wasted space from a database, you must _____________the database. A. delete B. compact C. clean D. repair: B. Compact
A__________allows you to select from a list of values. A. Look table B. Lookup field C. Data list D. Client Field: B. Lookup field
To update all records, use the _________query. A. insert B. update C. append D. make-table: B. Update
Click the __________button to filter records based on values in more than one field. A. Filter by Field B. Filter by Selection C. Apply Filter D. Filter by Form: D. Filter by Form
You can use __________to view records and update data in a table. A. Sheetdata view B. Form view C. Edit view D. 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 view B. Layout view C. Report view D. 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 labels B. bound labels C. control labels D. field labels: A. attached labels
A__________is printed after a group of records. A. group footer B. detailed section C. page footer D. control page: A. group footer
____________a control is a way to produce the control;s property sheet. A. Right-clicking B. Dragging C. Clicking D. Double-clicking: D. Double-clicking
Clicking a control a second time produces a(n) _____________to let you modify its contents. A. dialog box B. insertion point C. text box D. wizard: B. insertion point
Which of the following is not a possible view in the Report window? A. Design view B. Print Preview C. Layout View D. Data View: D. Data View
Use___________to view a report's layout. A. Layout Preview B. Print Preview C. Outline View D. 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. Box B. Calculated control C. Text Box D. Control Box: C. Text Box
___________are used to display data that is calculated from other data in the database. A. Unbound controls B. Attached labels C. Bound controls D. Calculating controls: D. Calculating controls
To resize a column, click Column Width on the _____menu. A. Format B. Edit C. Tools D. Size: A. Format
________ensures that the value in a foreign key must match that of another table's primary key. A. Referiential Integrity B. Foreign key integrity C. Reference Integrity D. 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. Delete B. OK C. Yes D. No: C. Yes
Looking for records that satisfy some criteria is called___________. A. looking B. sorting C. grouping D. searching: D. searching
To add a field to a table, click the___________on the Table Design toolbar. A. Insert Rows button B. Rows button C. add Rows button D. 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-one B. one-to-several C. one-to-many D. many-: C. one-to-many
To specify a required field, click the_________in the Field Properties pane. A. Default property box B. Validation Rule box C. Required property box D. Field Command: C. Required property box
To change to Overtype mode, press the_________key. A. ESC B. INSERT C. HOME D. TAB: B. INSERT
Indexes whose key is a combination of fields are called ________indexes. A. single-field B. many-field C. multiple-field D. several-field: C. multiple field
A query that makes changes to many records in one operation is called a(n)___________. A. active query B. mass query C. action query D. fast query: C. action query
To allow all the data in a field to display, you ____________the column in the datasheet. A. open B. drag C. resize D. click: C. resize
Modifying a database and keeping it up to date is known as __________the database. A. sorting B. purging C. correcting D. maintaining: D. maintaining
_______is the text message that will appear if a user violates a validation rule. A. Validation text B. Validation rules C. Error text D. Error rules: A. Validation text
Access automatically creates an index on the ___________of the table. A. primary key B. foreign key C. sort key D. index key: A. primary key
A field in which the user must enter data is called a_______________. A. validation field B. required field C. default value D. default field: B. required field
To add a group of records from one table to the end of anohter table, use the ___________query. A. delete B. update C. append D. add-table: C. append
To specify a default value, enter the value in the ______________. A. Values box B. Default Value property box C. Field property box D. 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 button B. Locate button C. Find button D. Search button: C. Find button
If yu wish to see several records at one time, switch from Form view to ___________view. A. Normal B. Datasheet C. Database D. Records: B. Datasheet
The Find Unmatched Query Wizard helps you find___________records. A. printed B. unmatched C duplicate D. multiple: B. unmatched
To specify referential integrity, you must define a relationship between the tables using the _____command. A. Define B. Specify C. Referential Integrity D. 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. Form B. Datasheet C. Table D. Design: D. Design
The field or fields on which an index is built is called the__________. A. primary key B. major key C. index key D. sort key: C. index key
To return a damaged or destroyed database to a correct state is called______________. A. indexing B. formatting C. recovery D. backing up: C. recovery
To specify referential integrity, you must define a relationship between the tables using the_________commnad. A. Define B. Specify C. 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. F2 B. F8 C. F5 D. F6: D. F6
Tp create indexes, click indexes on the _________menu. A. Tools B. Edit C. Format D. View: D. View
The field or fields on which an index is buit is called the__________________. A. primary key B. major key C. index key D. sort key: C. index key
A9n)_______is the most common structure for high-performance. A. A-tree B. B-tree C. C-tree D. 4-tree: B. B-tree
The names, types and sizes of all the fields define the ____________of a database. A. size B. properties C. values D. structure: D. structure
To preview what your report looks like with actual data, use__________. A. Design view B. Data view C. Print Preview D. Actual view: C. Print Preview
A common term for the sections of a report is______________. A. objects B. bands C. controls d. dock: B. bands
by default, Access assigns a __________to calculated field. A. general format B. Currency format C. Special format D. Decimal format: A. general format
A_________is printed before the records in a particular group are printed. A. group header B. subtotal C. group footer D. control: A. group header
To change the appearance of a label, right-click the label and click_________on the shortcut menu. A. Build Event B. Change Font C. Format D. Properties: D. Properties
To obtain help entering the expression for a field you are adding, use the___________. A. Expression Helper B. Expression Builder C. Expression Tool D. Expression Source: B. Expression Builder
___is the process used for moving toolbars to different positions on the screen. A. Docking B. Shifting C. Alternating D. Minimized: A. Docking
The contents of the ____________will print once at the beginning of a report. A. Report header section B. Report Footer section C. Report Title section D. Detail Section: Report Header Section
With a__a user can select an item from a list of possible values. A. Text box B. control C. combo box D. Format property: C. combo box
With a___________a user can select an item from a list of possible values. A. Text box B. control C. combo box D. Format property: C. combo box
_____________are boxes that allow you to select entries from a list. A. Combo boxes B. Custom boxes C. Entry boxes D. Form boxes: A. Combo boxes
To resize a control, ________one of the sizing handles. A. click B. double-click C. right-click D. drag: D. drag
To print a selected report, ___________the report, then click Print one the shortcut menu. A. click B. right-click C. double-click D. open: B. right-click
________are not associated with data from the database. A. Bound controls B. Attached labels C. Unbound controls D. Calculating controls: C. Unbound controls
The various rectangles on a form are called A. boundaries B. form contents C. attachments D. controls: D. controls
The mouse pointer shape changes to a _________to indicate a control can be dragged. A. crosshair B. plus sign C. hand D. minus sign: C. hand
Each portion of a report is described in what is termed a(n)_________. A. object B. section C. control D. 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. Label B. Title C. Form Label D. Create Title: A. Label
The contents of the ________print once at the end of the report. A. Report Header Section B. Detail Section C. Page Footer Section D Report Footer Section: D. Report Footer Section
By default, access assigns a _________to a calculated field. A. general format B. Currency format C. Special format D. Decimal format: A. general format
With a_______a user can select an item from a list of possible values. A. Text box B. control C. combo box D. Format Property: C. Combo box
___________are boxes that allow you to select entries from a list. A. Combo boxes B. Custom boxes C. Entry boxes D. Form boxes: A. Combo boxes
To print a selected report, ___________the report, then click Print on the shortcut menu. A. click B. right-click C. double-click D. Open: B. Right-click
__________are not associated with data from the database. A. Bound controls B. Attached labels C. Unbound Controls D. Calculated controls: C. Unbound controls
_________a control is a way to produce the control's property sheet. A. Right-clicking B. Dragging C. Clicking D. Double-clicking: D. Double-clicking
The contents of the________will print once at the beginning of a report. A. Report Header section B. Report Footer section C. Report Title section D. Detail section: A. Report Header section
Reports based on_________open faster than those based on____________. A. tables, queries B. queries, tables C. forms, tables D. tables, forms: A. Tables, queries
The contents of the__________print once at the end of the report. A. Report Header section B. Detail section C. Page Footer section D. Report Footer section: D. Report Footer section
To remove unwanted controls, first select the control, then press the___________key. A. ENTER B. SHIFT C. DELETE D. ESC: C. DELETE
To print a selected report, ___________the report, then click print on the shortcut menu. A. click B. right-click D. double-click e. open: B. right-click
To obtain help enterint the expression for a field you are adding, use the__________. A. Expression Helper B. Expression Builder C. Expression Tool D. 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. SHIFT B. CTRL C. INSERT D. HOME: A. SHIFT
The mouse pointer shape changes to a_______to indicate a control can be dragged. A. crosshair B. plus sign C. hand D. minus sign: C. hand
You can use___________to create a form totally from scratch. A. Design View B. the Form Wizard D. AutoForm E. DesignForm: A. Design View
Access automatically formats fields from the database appropriately because it nows their__________. A. contents B. data C. data types D. parameters: C. data types
The mouse pointer shape changes to a ____________accompanied by a label to indicate placement of a label. A. small minus sign B. small hand C. small plus sign D. crosshair: C. Small plus sign
To close a database, click the _____________for the database. A. Close B. Exit C. Close Window D. Exit Database: C. Close Window
To place a combo box in a form, press the ________tool in the toolbox. A. Insert Box B. Combo Box C. Box Wizard D. Controls: B. Combo Box
The process of creating separate collections of records sharing a common characteristic is called_____________. A. collecting b. grouping C. sorting D. merging: B. grouping
You can view two pages at the same time when previewing a report by clicking the__________button. A. Preview Two B. Two Pages C. Multiple Pages\ D. View Two: B. Two pages
The__________contain all the information on a report or form. A. captions B. details C. headers D. 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. SHIFT B. ALT C. CTRL D. INSERT: A. SHIFT

Start Studying!

Deck Info

Number of cards 98