1 / 21

Access Exam

Access Exam. Study Guide. 1. Which statement is FALSE?. Once you enter data into a record, you can go back and make changes to the data. In an Access table, data is saved automatically as soon as you leave the record or close the table.

xanthus-mcmillan
Download Presentation

Access Exam

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Access Exam Study Guide

  2. 1. Which statement is FALSE? • Once you enter data into a record, you can go back and make changes to the data. • In an Access table, data is saved automatically as soon as you leave the record or close the table. • New fields can be added to a table in either Datasheet view or in Form view. • If you accidentally delete a record, click undo to retrieve the record back to its position in the table before the deletion.

  3. 2. Which statement is TRUE? • Field names may contain letters, numbers, symbols, commas, and periods. • Creating a report in Access gives more control over how data is printed than printing directly from a table’s datasheet. • Tables can only be sorted by one column. • The field in a table that makes each record unique is referred to as the constant key.

  4. True or False? • A database is a collection of objects such as tables, queries, forms and reports. • Double-clicking the column boundary performs the Best-Fit command. • Landscape orientation rotates the printout to print wider than it is taller.

  5. 6. Are both of these statements TRUE? • The Field Size property can be used to limit the number of characters that are allowed in a field entry. • When selecting a record in Datasheet view and clicking delete, a message box appears asking you to confirm the deletion.

  6. 7. Are both of these statements true? • The field in a table that makes each record unique is referred to as the primary key. • Once you enter a data field into a table; you can move the field to another location in the table.

  7. 8. What keys do you press to move to the first field of the first record in a table?

  8. 9. If you have a database containing information about students, then the student’s last name would be an example of a a. table. b. field. c. record. d. file.

  9. 10. Which statement is TRUE? • Within an Access table, each field is represented by one row • Each database must contain at least one table. • Use record view to display a table in columns and rows. • Within an Access table, each record is represented by one column. Can you make the other three true?

  10. 11. You can export what type of files from Access: • Word • Excel • Text • All of the above

  11. 12. A ___________ field is used when you want to restrict the data entered into the field to a list of values? a. Lookup b. Foreign Key c. Startup d. Primary Key

  12. 13. When using the Form 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)? a. > b. >> c. < d. <<

  13. 14. Access is called a relational database management system because of the relationships that can be established among. a. Records b. Queries c. Macros d. Tables

  14. 15. A relational database is one in which: a. fields are joined together within a record. b. records are joined together within a table. c. tables are joined together within a database. d. databases are joined together.

  15. 16. What task does the Query Run button perform? a. It saves the query b. It displays the table used in the query c. It brings up the query wizard d. It displays the resulting records and fields produced by the query.

  16. 17. TRUE or FALSE? • To edit a cell (edit mode) you can double click in the cell or press the F2 key to edit.

  17. 18. If you have a database containing information about customers, then all the information about one customer would be a a. table. b. record c. field d. file.

  18. 19. Adding a _________ to the query design will cause Access to display only those records that meet the requirements. a. Check mark in the Show box • Criterion statement (condition) • Join Line • Sort Command

  19. 20. When using the Simple Query Wizard to choose all fields 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)? a. > b. >> c. < d. <<

  20. True or False? • The button used to run a query contains the icon asterisk (*). • A query is an Access object designed to extract data from one or more tables.

  21. True or False? • New record information can be entered into Access by keying into a table in datasheet view or keying into a Form. • A deleted record can be put back using the undo command. • What key can you use to edit an item in Access?

More Related