Question: Match each characteristic or feature that a relational DBMS is supposed to support with the MS Access tool that is evidence of this support. Enforces
Match each characteristic or feature that a relational DBMS is supposed to support with the MS Access tool that is evidence of this support.
|
Enforces user security and data privacy within the database.
| |
|
|
Supports backup and recovery management.
|
| 1234567 |
Provides Data Dictionary Management to display and manage DB objects, all object properties and relationships between the objects.
|
| 1234567 |
Manages data storage, storing data and related data entry forms and report definitions in a manner most efficient to support the system.
|
| 1234567 |
Provides database access languages and application programming interfaces that allows us to view the raw data and transform it into information.
|
| 1234567 |
Supports data integrity management - promotes and enforces integrity rules.
|
| Use the Database Tools --> Data Documenter tool and the Table Design editor. | |
| 2. | Use the Query Design tool or wizard to create a query or create a Macro. |
| 3. | Use File->Save and Publish->Backup database |
| 4. | Use File -> Info [Encrypt with Password] feature and Trust Center Settings |
| 5. | Allows us to define Primary Keys to enforce Entity Integrity and to set rules on the relationship between tables to enforce referential integrity. |
| 6. | Tables, forms and reports are logical structures which are saved in an efficient physical format by Access. Users and programmers don't need to concern themselves with those details. |
| 7. | That feature is NOT supported in MS Access. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
