click below
click below
Normal Size Small Size show me how
Access 2007
Questions about Microsoft Access 2007
| Question | Answer |
|---|---|
| In an Access table, data is saved automatically as soon as you leave the record or close the table. | True |
| Once you enter data into a record, you cannot go back and make changes to the data. | False |
| If you accidentally delete a record, click undo to retrieve the record back to its position in the table before the deletion. | False |
| Tables can only be sorted by one column at a time. | False |
| Creating a report in Access gives more control over how data is printed than printing directly from a table’s datasheet. | True |
| Unlike other Microsoft applications, only one database can be open at a time. | True |
| Double-clicking the column boundary performs the Best-Fit command. | True |
| When viewing a table in Datasheet view and you click the Delete button, a message box appears asking you to confirm the deletion. | True |
| The Field Size property can be used to limit the number of characters that are allowed in a field entry. | True |
| The field in a table that makes each record unique is referred to as the constant key. | False |
| Landscape orientation rotates the printout to print wider than it is taller. | True |
| A query is an Access object designed to extract data from one or more tables. | True |
| A form is composed of a series of objects referred to as controls. | True |
| The button used to run a query contains the icon asterisk (*). | False |
| Templates are databases that already have forms, reports, and tables created for you. | True |
| If you have a database containing information about students, then all the information about one student would be referred to as a | record |
| If you have a database containing information about students, then the student’s last name would be an example of a | field |
| Press these keys to move to the first field of the first record in a table. | Ctrl + Home |
| Within an Access table, each record is represented by one | row |
| Within an Access table, each field is represented by one | column |
| Each database must contain at least one | table |
| Use this view to display a table in columns and rows. | Datasheet view |
| The Edit Mode is turned on by pressing: | F2 |
| A relational database is one in which: | tables are joined together within a database. |
| When using the Table Wizard to choose a field from the Sample Fields list box to include in your table, click the desired field and then click the button that contains which of the following symbol(s)? | > |
| What task does the Query Run button perform? | It displays the resulting records and fields produced by the query. |
| When using the Simple Query Wizard, to choose all fields from the Available fields list box to include in the Selected Fields, click the button that contains which of the following symbol(s)? | >> |
| A ______ field is used when you want to restrict the data entered into the field to a list of values. | lookup |
| Access is called a relational database management system because of the relationships that can be established among | tables |
| Adding a ____ to the query design will cause Access to display only those records that meet the requirements. | criterion statement |