1. Access is a relational database management system.
True False
2. In Access, the primary object of a database is called a table.
True False
3. Form objects are used to find data in a database.
True False
4. The Navigation pane shows each object in your database.
True False
5. The Navigation pane displays your objects by categories and groups.
True False
6. Design view allows you to enter, modify, delete, or view the data records.
True False
7. A template provides you with a complete, ready-to-use database application.
True False
8. Access automatically assigns a generic file name to your database, such as
Database1.accdb.
True False
,9. When you first create an object, Access assigns a generic name, such as Table1 or
Form1.
True False
10. CamelCase notation is the practice of using a prefix to indicate the type of object.
True False
11. Each field in your database must be assigned a specific data type.
True False
12. It is important to save a database file before closing it.
True False
13. The Back Up Database option creates a copy of your database.
True False
14. A primary key is a field that contains a unique value for each record.
True False
15. Each field in a table must have a unique name.
True False
16. In Access, it is not possible to delete fields after you have added data to the field.
True False
17. It is possible to change a limited number of field properties in Datasheet view.
True False
18. When working with a new table, you can save it by clicking the File tab and clicking
the Save button.
True False
19. Access provides many different ways to navigate among the data records stored in
your tables.
True False
, 20. The AutoFit feature helps visually frame the rows and columns in a datasheet with a
border.
True False
21. It is not possible to change the order of fields in an Access table.
True False
22. The Datasheet Formatting dialog box enables you to make several changes at once to
the layout of a datasheet.
True False
23. The Find button is located on the File tab.
True False
24. You can sort a datasheet by one field, or a set of adjacent fields, in ascending or
descending order.
True False
25. If you open a table with a previously saved sort, clicking Remove Sort on the Home
tab removes the sort.
True False
26. The Sort functions are helpful in limiting the number of records that display in your
datasheet.
True False
27. Compound filter criteria combine more than one search value using the AND and OR
logical operators.
True False
28. Once a filter has been applied to datasheet records, it is not possible to return them
to their original unfiltered state.
True False
29. Adding a filter to a second field is an OR condition.
True False
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ExamsExpert. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $31.36. You're not tied to anything after your purchase.
