Summary: Using Advanced Database Management in Access
About the Lecture
The lecture Summary: Using Advanced Database Management in Access by Sonic Performance is from the course Using Advanced Database Management in Access 2013. It contains the following chapters:
- Summary: Using advanced Database Management in Access
Included Quiz Questions
Identify the valid sources of external data. (Choose three.)
- Excel Spreadsheets
- Other Access Databases
- A plaintext file
- A Microsoft Word Document (DOC or DOCX)
True or False? Opening a database in exclusive mode prevents other users from using the database.
- True
- False
What are the two object dependency types?
- Objects that depend on me and objects that I depend on.
- Objects with events and objects with property sheets.
- Objects that depend on tables and objects that depend on macros.
- Objects that depend on me and objects that have no dependency.
Why is important to document a database?
- It helps when troubleshooting problems.
- To assess performance problems with the database.
- To point out potential design problems and suggestions for their remedies.
- It forces you to get to know your database.
What is the best reason for running the Performance Analyzer?
- As part of regular database maintenance.
- To provide faster access to the Macro Builder.
- To encrypt the database with a password.
- For testing purposes only.
Author of lecture Summary: Using Advanced Database Management in Access
Sonic Performance
Customer reviews
5,0 of 5 stars
| 5 Stars |
|
5 |
| 4 Stars |
|
0 |
| 3 Stars |
|
0 |
| 2 Stars |
|
0 |
| 1 Star |
|
0 |
