End of Access Exam

1. End of Access Exam Review

2. True • Landscape orientation rotates the printout to print wider than it is taller.

3. False • The field in a table that makes each record unique is referred to as the constant key.

4. Access is called a relational database management system because of the relationships that can be established among tables.

5. True • In an Access table, data saved automatically as soon as you leave the record or close the table.

6. True • A query is an Access object designed to extract data from one or more tables.

7. False • Tables can only be sorted by one column at a time.

8. False • The button used to run a query contains the icon asterisk (*).

9. Within an Access table, each field is represented by one column.

10. True • Templates are databases that already have forms, reports, and tables created for you.

11. Adding a criterion statement to the query design will cause Access to display only those records that meet the requirements.

12. False • Once you enter data into a record, you cannot go back and make changes to the data.

13. True • When viewing a table in Datasheet view and you click the Delete button, a message box appears asking you to confirm the deletion.

14. False • Unlike other Microsoft applications, only one database can be open at a time.

15. A relational database is one in which: tables are joined together within a database.

16. To edit a cell (edit mode) you can double click in the cell or press: F2

17. Use this view to display a table in columns and rows: Datasheet view

18. 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 symbol(s)? >

19. If you have a database containing information about students, then the student’s last name would be an example of a field.

20. True • Creating a report in Access gives more control over how data is printed than printing directly from a table’s datasheet.

21. True • A form is composed of a series of objects referred to as controls.

22. Each database must contain at least one table.

23. A lookup field is used when you want to restrict the data entered into the field to a list of values.

24. False • If you accidentally delete a record, click undo to retrieve the record back to its position in the table before the deletion.

25. If you have a database containing information about students, then all the information about one student would be referred to as a record.

26. True • The Field Size property can be used to limit the number of characters that are allowed in a field entry.

27. True • Double-Clicking the column boundary performs the Best-Fit command.

28. Press these keys to move to the first field of the first record in a table: Ctrl + Home

29. What task does the Query Run button perform? It displays the resulting records and fields produced by the query

30. 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 symbol(s)? >>

31. Access is what type of program? Database

32. Within an Access table, each record is represented by one row.