Microsoft Access

Computing

Quiz 12 :

Managing and Sharing a Database

Quiz 12 :

Managing and Sharing a Database

Question Type
search
arrow
img refers to the protection of a database against unauthorized access, either intentional or accidental.
Free
Essay
Answer:

Answer:

All the objects of a database must be protected from unauthorized access, In order to provide protection to the databases created Security for the database must be provided; security prevents intentional and accidental misuse of database. Security is provided by
• Using data encryption and decryption mechanism.
• By providing the authorized users with login credentials.

Tags
Choose question tag
close menu
arrow
What is a subquery
Free
Essay
Answer:

Answer:

A Sub Query is an Inner query, similar to SQL queries provided by oracle, Access also provides Sub Queries. That is, in a SQL Select query, another Select query is embedded. The second query or the inner query is called as a sub query.
• Sub queries are executed first, the outer query is always evaluated basing on the result of the subquery or inner query.
• For example: user wants to retrieve customers information who are working in department sales.
Select customer_id, customer_name
from tblcustomer
where dept_id = ( Select dept_id from tbldepartment where dept_name='sales');
So here the sub query or inner query "Select dept_id from tbldepartment where dept_name='sales' "is executed first, if suppose the inner query results is one record, that record is used to evaluate the outer query.

Tags
Choose question tag
close menu
arrow
You use the img property to display a multivalued field in expanded form so that each value is displayed in a separate row in a query.
Free
Essay
Answer:

Answer:

Multivalued fields are columns in a datasheet whose data value can be selected from a list of values. That is for a field in a record if the user can enter multiple values which can be selected from a list of values available for that particular field.
While creating a multivalued field, when the user selects the value property, all the multiple values available for that field are displayed in separate row.

Tags
Choose question tag
close menu
arrow
What is a multivalued field
Essay
Answer:
Tags
Choose question tag
close menu
arrow
What is the Database Splitter
Essay
Answer:
Tags
Choose question tag
close menu
arrow
What is a startup option
Essay
Answer:
Tags
Choose question tag
close menu
arrow
You can specify sequential numbering or random numbering for a(n) img field.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
You can save a filter as a(n) img and reuse the filter by opening the saved object.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
When do you use the Linked Table Manager
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Access stores attachments in img form to minimize file size and maximize disk space usage.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Filter By img filters records that match multiple selection criteria using the same Access comparison operators used in queries.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
What is the Performance Analyzer
Essay
Answer:
Tags
Choose question tag
close menu