Podcast
Questions and Answers
Which of the following is not an Access object?
Which of the following is not an Access object?
- Table
- Record (correct)
- Form
- Macro
Where is data primarily stored in a database?
Where is data primarily stored in a database?
- Table (correct)
- Query
- Form
- Report
When should you execute the Save command after editing records in Access?
When should you execute the Save command after editing records in Access?
- Immediately after you edit a record
- When you close the table
- Once at the end of the session
- Records are saved automatically; the save command is not required (correct)
Which of the following statements about Access databases is true?
Which of the following statements about Access databases is 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 recovering lost or damaged data in Access?
Which utility is used for recovering lost or damaged data in Access?
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?
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?
Flashcards
Access Object (not a record)
Access Object (not a record)
An Access object that is not a record. Examples include tables, forms, and macros.
Data Storage in Database
Data Storage in Database
Data in a database is stored in tables.
Saving Edited Records
Saving Edited Records
Edit records, then save changes at the end of the session.
Access Database Feature
Access Database Feature
Signup and view all the flashcards
Table View Types
Table View Types
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 Conditions
Selection Filter Conditions
Signup and view all the flashcards
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.
