WorksheetsSecuring and Sharing Information
Total questions: 12
Worksheet time: 11mins
Your goal as a database developer is to provide adequate protection without imposing
unnecessary restrictions on the people who should have access to your database.
True
False
If your database will be opened by more
than one person at a time, you must worry about ...
You don't have to worry about the potential for corruption
The potential for data corruption
You must use Excel to open de database.
To create a secure password in Access 2007,
keep the following in mind:
A good password includes uppercase letters, lowercase letters, and symbols or
numbers, and isn't a word found in a dictionary.
Is not a good idea to include symbols, and numbers in a password.
You can not include , accented characters, or numbers.
A benefit of assigning a password to your database is that will automatically be
Encrypted each time you close it.
The database will be saved in the cloud.
Anyone can access the database using Excel.
Decrypting a file prevents people who don't have a copy of Access from being able
to read and perhaps make sense of the data in your file.
False
True
To assign a password to a access database you must open the file with the _________option.
Open
Open Read-Only
Open Exclusive
Open Exclusive Read-Only
Encrypt with Password option is located in the ...
Database Tools Tab
External Data Tab
Create Tab
Home Tab
The Visual Basic Editor launch option is located within the ____ Group in the Database Tools Tab.
Macro
Show/Hide
Analyze
Move Data
An Access Database Executable (ACCDE) file is...
A type of file for secure distribution.
A type of file that allows to be edited
A Type of file that allows to modify VBA code.
User can add, delete, or change reference to to the
In Access 2007 ,if you set a password for the code, it remains available
for editing by anyone who knows the password.
True
False
If you save the database as an
ACCDE file, people using the file can run your code, and edit it.
True
False
You can encrypt a database, which does not prevent it from being opened and
viewed in Access, but does keep people who don't have a copy of Access from
reading or making sense of the data.
True
False
