Access Test Chapters 1 and 2.rtf

7 Pages
Unlock Document

Concordia University
Business Technology Management
BTM 481
Raul Valverde

Access Test Chapters 1 and 2 True/False Indicate whether the statement is true or false. ____ 1. A collection of fields describing a person, place, object, event, or idea is a table. ____ 2. A single set of field values within a table is a record. ____ 3. A database is a collection of related tables. ____ 4. When two tables are related by a common field, users can tie together facts from the two tables. ____ 5. A DBMS controls the storage of databases on disk by carrying out data creation and manipulation requests. ____ 6. The Access window is the first window that appears when you launch Access. ____ 7. The navigation buttons allow you to step through a table record by record, or to quickly go to the first or last record in the table. ____ 8. The fastest way to display all fields from an open table on a form is to use the Form Wizard. ____ 9. Records in a database can be displayed in a custom format by creating a form. ____ 10. When designing a database, the first thing you should do is to identify the fields that will be required. ____ 11. Primary keys uniquely identify records in a table. ____ 12. Every table defined in Access must have a primary key. ____ 13. Redundant fields waste storage space and can result in inconsistent data within the database. ____ 14. A common field is a field that is defined as a primary key in one table and is defined as a foreign key in a sec- ond table. ____ 15. A field in one table that establishes a relationship to another table is called a redundant field. ____ 16. A field defined as an AutoNumber data type cannot serve as a table’s primary key. ____ 17. Records in a table are stored on disk in the order they are entered but are displayed in primary key sequence. ____ 18. A primary key is allowed to have a null value. ____ 19. Certain Access data types have a predefined field size that cannot be changed. ____ 20. The spacebar works as a toggle for check boxes in Yes/No fields; you press the spacebar to insert a check mark in an empty check box and to remove an existing check mark. Modified True/False Indicate whether the statement is true or false. If false, change the identified word or phrase to make the statement true. ____ 21. A(n) relational database management system provides protection for your data through the use of security, control, and recovery facilities. ____________________ ____ 22. Databases you create in Access 2007 use the Access 2003 database file format. ____________________ ____ 23. Most of the Database window screen components are the same as the components in other Windows pro- grams. ____________________ ____ 24. Access saves changes to the active database when a record is changed or added and when you close the data- base. ____________________ ____ 25. Backing up a database rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly. ____________________ ____ 26. A field name can consist of up to 255 characters. ____________________ ____ 27. A primary key that is made up of more than one field is called a(n) aggregate key. ____________________ ____ 28. You use a(n) composite field to connect one table logically with another table. ____________________ ____ 29. Integer is the default Field Size property setting. ____________________ ____ 30. You can import a table from another Access database into your current database using the Import button on the Ribbon. ____________________ ____ 31. When you import a table from one Access database to another, you place a(n) copy of the table in the data- base into which you import it. ____________________ ____ 32. The F5 key is a toggle that you use to switch between the Table Design grid and the Field Properties pane. ____________________ ____ 33. The data type determines what field values you can enter for the field and what other properties the field will have. ____________________ ____ 34. Like calculations with Number data type decimal values, calculations performed with the Currency data type are not subject to round-off error. ____________________ ____ 35. Access allows you to change a field’s size in Datasheet view. ____________________ Multiple Choice Identify the choice that best completes the statement or answers the question. ____ 36. When you first open a(n) ____, Access selects the first field value in the first record. a. object c. query b. datasheet d. macro ____ 37. A field can be described as a(n) ____. a. object c. attribute b. record d. table ____ 38. Access allows you to ask questions and obtain information about your data through use of a built-in ____. a. inquisitor c. table generator b. query language d. report generator ____ 39. Which of the following is NOT an example of an Access object? a. report c. form b. query d. Report tool ____ 40. You open a table, or any Access object by double-clicking the object name in the ____. a. Views group on the Ribbon c. Navigation Pane b. Home tab d. Office Button ____ 41. The final step in the creation of a table is to save the table ____ to disk. a. values c. key set b. records d. structure ____ 42. Given a relationship between the two tables shown in the figure above, the field values labeled 2 show ____ data. a. redundant c. variation b. inconsistent d. irrelevant ____ 43. A field name ____.
More Less

Related notes for BTM 481

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.