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 key
uniquely identifies a record.
Table Views in Access
-
Datasheet view
allows adding, editing, and deleting records. -
Datasheet view
displays the data, not the table design. -
Design view
provides more field properties thanDatasheet view
. - Datasheet view changes are automatically saved when moving between records.
Database Utilities
-
Compact and Repair Database
utility 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 Manager
ormanager
.
Selection Filter Conditions
-
Selection filters
supportequal
andAND
,OR
conditions
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 template
to 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.