Podcast
Questions and Answers
Which of the following is not an Access object?
Which of the following is not an Access object?
Where is data primarily stored in a database?
Where is data primarily stored in a database?
When should you execute the Save command after editing records in Access?
When should you execute the Save command after editing records in Access?
Which of the following statements about Access databases is true?
Which of the following statements about Access databases is true?
Signup and view all the answers
Which view allows you to add, edit, and delete records in Access?
Which view allows you to add, edit, and delete records in Access?
Signup and view all the answers
Which utility is used for recovering lost or damaged data in Access?
Which utility is used for recovering lost or damaged data in Access?
Signup and view all the answers
If using a Selection filter’s exact match option for the title 'Manager', which title would be matched?
If using a Selection filter’s exact match option for the title 'Manager', which title would be matched?
Signup and view all the answers
To add a predefined table to an existing database, which option should you choose?
To add a predefined table to an existing database, which option should you choose?
Signup and view all the answers
Study Notes
Access Objects
- An Access object is not a
Record. Tables, forms, and macros are Access objects.
Data Storage in a Database
- Data in a database is stored in a
Table.
Saving Edits in an Access Table
- Changes made in a table are saved automatically when moving to a new record. You do not need to manually save.
Access Database Characteristics
- Each field in an Access table has a specific data type.
- All records within a table have the same fields.
- Tables in a database do not necessarily have the same number of records.
- A
primary keyuniquely identifies a record.
Table Views in Access
-
Datasheet viewallows adding, editing, and deleting records. -
Datasheet viewdisplays the data, not the table design. -
Design viewprovides more field properties thanDatasheet view. - Datasheet view changes are automatically saved when moving between records.
Database Utilities
-
Compact and Repair Databaseutility is used to recover data if lost or damaged.
Selection Filter Matching
- Using an "exact match" filter for "Manager" would only match the entry
Manager, notSales Managerormanager.
Selection Filter Conditions
-
Selection filterssupportequalandAND,ORconditions
Database Creation
- A blank database starts with a blank table.
- Access opens a blank table in datasheet view.
- Database templates save time as they include pre-defined objects.
- Predefined objects in templates can be modified.
Adding Predefined Tables to a Database
- Use a
database templateto add predefined tables to an existing database.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge on Access database concepts including objects, data storage, and table characteristics. This quiz will cover key features of Access such as Views, primary keys, and the utility functions available for database maintenance.
