Transcript Acess Test Questions

Acess Test Questions
Chapter 1 (Lynda.com)
Question 1
• An access database uses five main components (database objects).
Which is not one of them?
• Tables
• Reports
• Forms
• Graphs
• Queries
Question 2
• You have set a folder as a Trusted Location. You open an Access
database in a subfolder and still receive a security warning. Why?
• Subfolders must be set individually as Trusted Locations
• You neglected to check “Subfolders of this location are also
trusted”.
• The database was created after you set Trusted Location
• Access identified some suspicious macros in the database
Question 3
• Which is a ribbon not available in Access 2013?
• Create
• External Database
• Database Tools
• Format
• Home
Question 4
• You type "Phone" in the Navigation pane search bar. You see
a list of all files with a data field labeled "Phone."
• False
• True
Question 5
• Which are the default Quick Access toolbar commands?
• Undo, Redo and Touch
• Save, Undo and Redo
• Save, Undo, Redo and Email
• Save, Undo, Redo and Print
• Save, Undo, Redo and Touch
Question 6
• To sync your Access files across multiple computers, you
need
• Just SkyDrive, to store your database.
• A Microsoft Live account and SkyDrive to store your
database
• A Microsoft Live account, SkyDrive and an encryption
application
• Just a Microsoft account
Question 7
• You create a backup database simply by using the
command Save As > Back up Database.
• False
• True
Question 8
• How do you set Customer ID as the primary key for your database?
• Right-click on the field CustomerID, then click the Primary Key
command on the popup menu.
• Double-click on CustomerID field, then click the Primary Key
command on the popup menu.
• Click on the field CustomerID, then click the Primary Key command
on the Database Tools ribbon.
• Click on the field CustomerID, then click the Primary Key command
on the Design ribbon.
Question 9
• You wish to set California (abbreviated CA) as a default value.
What do you type into the Expression Builder?
• = *CA*
• =”CA”
• =_CA_
• =CA
Question 10
• A Short Text field size is _____ characters by default.
• 140
• 255
• 250
• 100
Question 11
• The record number is simply the number of an entry
in a database view, assigned by order. It changes if you
sort the table.
• True
• False
Question 12
• You filter a database to show only people in the IT
department. When you use the Toggle Filter command,
which option will you not have?
• Equals “IT”
• Does Not Equal “IT”
• Contains “IT”
• “filter by IT?”
Question 13
• Saved queries appear in a Queries group on the
Navigation pane.
• True
• False
Question 14
• Using the Query Wizard to search for people by
departments, you enter "manufacturing and quality
assurance" under Criteria. What happens?
• You get an error message, “Query Returned No Data”
• You get a list of people who work in either of those
departments
• You are prompted to clarify your query
• You get a list of people who work in both departments
(probably none).
Question 15
• You create a form from the Employees table, which contains
contact information. You add a phone number to an entry.
What happens?
• That number is appended to this and any table that
includes this employee’s phone number.
• Nothing. You cannot add data to tables from forms.
• The number is appended to the Employees table only, but
you may opt to add it to others.
• The number is appended to the Employees table only.
Question 16
• You use Form Wizard to create a form with data from the
Employees table and Employees Phone table. You choose the
Linked Form option. What happens?
• You are prompted to clarify your query.
• You have a form with both employee data and phone
numbers
• You have a form with employee data, and a button to click
for corresponding phone number
• You have two form, which appear side by side.
Question 17
• How do you find the data source when designing a
form?
• Create > Property Sheet > Data > Record Source
• Design > Property Sheet > Data
• Format >Property Sheet > Data > Record Source
• Design > Property Sheet > Data > Record Source
Question 18
• Where do you find the commands to add a button to your
form?
• In the Arrange tab’s View menu, and selecting Design
View
• Using the Home tab’s Button command
• On the Create tab’s View menu, and selecting Design View
• On the Home tab’s View Menu, and selecting Design View