Podcast
Questions and Answers
Which of the following is not an Access object?
Which of the following is not an Access object?
- Table
- Macro
- Record (correct)
- Form
In which component of a database is data primarily stored?
In which component of a database is data primarily stored?
- Report
- Form
- Table (correct)
- Query
When should you execute the Save command after editing records in an Access table?
When should you execute the Save command after editing records in an Access table?
- Records are saved automatically; the save command is not required (correct)
- When you close the table
- Once at the end of the session
- Immediately after you edit a record
Which statement about Access databases is not true?
Which statement about Access databases is not true?
Which view allows you to add, edit, and delete records in Access?
Which view allows you to add, edit, and delete records in Access?
Which utility is used for recovery in the event of data loss or damage?
Which utility is used for recovery in the event of data loss or damage?
Using a Selection filter’s exact match option for the title 'Manager', which title would be matched?
Using a Selection filter’s exact match option for the title 'Manager', which title would be matched?
Which condition is not available through a Selection filter?
Which condition is not available through a Selection filter?
Flashcards
Access Object (not a record)
Access Object (not a record)
An Access object can be a table, form, or macro, but a record is a single entry within a table.
Database Data Storage
Database Data Storage
Data in a database is stored in tables.
Saving Access Table Edits
Saving Access Table Edits
Edits made to records in an Access table are automatically saved.
Access Database Constraint
Access Database Constraint
Signup and view all the flashcards
Primary Key in Access Tables
Primary Key in Access Tables
Signup and view all the flashcards
Database Recovery Utility
Database Recovery Utility
Signup and view all the flashcards
Selection Filter Exact Match
Selection Filter Exact Match
Signup and view all the flashcards
Selection Filter Condition
Selection Filter Condition
Signup and view all the flashcards
Study Notes
Access Objects
- An Access database comprises various objects.
- Examples include tables, forms, and macros.
- A record is not an object; it's a single entry within a table.
Data Storage Location
- Data in an Access database resides within tables.
Saving Edits
- Changes to records are automatically saved.
- Manually saving records is unnecessary during the session.
Access Database Properties
- Each field in an Access table has a defined data type.
- All records in a table have the same fields.
- Tables in a database do not necessarily contain the same number of records.
- A primary key uniquely identifies a record within a table.
Table Views
- Datasheet view is used for adding, editing, and deleting records.
- Design view outlines the table structure and properties.
- Datasheet view does not provide more field properties than design view.
- Changes to a record in datasheet view are automatically saved upon moving away from that record.
Database Utilities
- Back up and compact/repair utilities are used for database restoration in case of loss or damage.
Selection Filters
- A precise match on "Manager" in a selection filter selects a record containing the exact string “Manager”.
Selection Filter Conditions
- Possible filter conditions include "equal to," and "AND/OR" conditions.
Database Creation
- Access initially creates a blank database with at least one empty table.
- Databases can be created from templates to incorporate pre-defined objects.
- Database templates do not mean that the objects within them cannot be modified.
Adding Predefined Tables
- A database template is used 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
This quiz covers the essential concepts of Access databases, including objects, data storage, and table views. Understand the differences between records and objects, as well as how database properties and views function. Perfect for beginners looking to enhance their knowledge of Access.
