Elance Access Test Answers 2015




The action of typing a record into a database is:
Data entry
Form entry
Query cultivation
Form making
What is the maximum number of indexes that you can create on an Access table?
15
5
32
10
9


Why use a database instead of a spreadsheet?
Databases and Spreadsheets are interchangeable.
Spreadsheets do not chart well.
Databases are easier to set up.
Multiple data from various tables are needed.


The functions of Avg, Sum, Count, etc. can be found in which tool group?
Sort
Property Sheet
Totals
Append


Microsoft Access does not offer parameterized queries.
False
True


Which one of these is not a valid database relationship?
one-to-many
many-to-many
many-to-pair


What would UCase("Tech on the Net") return?
ECH ON THE ET
TN
FALSE
TECH ON THE NET


True or False: You use an AutoNumber data type when you want unique numeric values to be created automatically by Access when you create a record.
True
False


What can you do to distribute the front-end database?
Send via email
Distribute across a network
All of these
Removable media such as CDs or thumb drives


You want to make sure that a unique number is always recorded on a new record. You would set the data type to:
Currency
Autonumber
Memo
Text


You want to make sure the data in a record is always recorded in dollars. You would set the data type to:
Autonumber
Memo
Currency
Text


How do you sort data in order?
Right-click in cell and select sort order
All of these
Use Filters
Use the sort function in ascending or descending order


In an appointment database, you want to record the time of each appointment. What would you set the data type to?
Text
Date/Time
Memo
Autonumber


What is a drop down list?
The result of a query.
Set by a MACRO.
A way to have a user select from list of values in a table or form.
Only used in forms.


Of these, what could be the purpose for splitting a database?
Makes the database more available to edit by multiple users
Reduce the chance of corruption
All of these
To enhance security


What is a purpose of a report?
To condense data
To rearrange data
To edit data in an expanded format
To represent data in a more aesthetic, professional manner


What would Left("Alphabet", 4) return?
habe
1pha
Alph
abet


An Access file can be exported into:
All of these
Excel
Access
HTML


How do you limit the types of records you are viewing in a table?
Use a different font size
Use a MACRO
Use a filter
Delete the other records


An Access file can import:
Excel Files
Text Files
All of these
Access files


What is an input mask?
Does not apply to Access.
A Zoom setting.
A user-help field setting.
A pattern for all data to be entered in the field.


True or False: Access allows you to import data from Excel.
True
False


What does an ACCDE file do?
All of these
Reduces the size of the database
Prevents copying and editing of files
Prevents use of certain functions of the database


Each customer has one address and each customer can have multiple orders. This is an example of a:
Inverted data set.
One-to-many relationship.
Many-to-many relationship.
A query.


What is VBA?
Used in queries exclusively
A data type that can be selected
The programming language used in Access Modules
A primary key setting


What is a data type?
Required to be set by an Administrator
It determines the kind of values users can store in a field
It is used by MACROs to edit data
It is an attribute of a primary key only


To add a table to a database, you:
Import a table from another file
All of these
Right click on a table, and copy it
Click "Table" on Create menu


What would Format("1267.5", "Currency") return?
$1,264
$1267.5
$1,268
$1,267.50
$1,267.5


Which of the following is not an Access object?
Forms
Spreadsheets
Queries
Tables


How do you save a file?
Click on the Microsoft icon on the top-left, then click save
All of these
Click on the disk icon on the top of the window
Press Control + S


What is an example of a comparison operator symbol?
= (Equals To)
< (Less Than)
All of these
> (Greater Than)


The primary advantage of using indexing is that:
It speeds up searches and sorting on the field.
Uses MACROs effectively.
It reduces the number of records needed.
It forces user compliance in data entry.


What would Format("210.6", "#,##0.00") return?
210
210.6
211
210.60


True or False: You can import an Excel spreadsheet to an Access table.
True
False


Each row of a table is called a:
Record
Database
Spreadsheet
Query


If tables are for storing data, what are queries used for?
Keeping all MACROs operating.
Displaying and printing the data you wish to see.
Enforcing primary key relationships.
Retrieving the data you want from the tables.


Is it possible to create a Crosstab query in Access?
Yes
No


How can you define how various tables of information are related?
Use the Relationships property to define them.
Delete all old files.
Set up Forms with the right data
Build queries.


What would LCase("124ABCd") return?
d
124abcd
FALSE
abcd


What happens when you freeze a column?
It makes the selected column move easier
It prevents all other columns from being moved
It prevents the column from moving positions
It hides a column


How to you ensure that a field is filled out properly?
Adjust the field width.
Delete the field.
Use a validation rule.
Change the font size.


True or False: Embedded macros can be attached to the event property of a form, report or control.
True
False


Can a primary key be used as a non-primary key in another table?
No
Yes
Does not apply to tables.
Only with a MACRO.


The Is Null criteria searches for fields that are ____.
full
empty
None of these
accurate


What is a report?
A way to store data in a database.
The opposite of a query.
A MACRO controlled document.
The best method for printing the results of data in a database.


Conditional formatting...
is an Excel tool and is not available in Access
can only be done on forms in Access
can only be done on reports in Access
allows you to apply formatting to data when a certain criterion is met


Before you split a database, you should:
Convert the database into an Excel spreadsheet
Create queries for all fields
Create a new table in the same file
Back up the database file


What is the maximum number of indexes that you can create on an Access table?
10
15
5
9
32


A primary key can be described as:
The only field in a table
The field the only contains uppercase values
A field or a combination of fields that contain unique values
Any field


In an Access Query, if you would like your result to display blank values, what criteria would you use?
is null
is like 0
is not null


To change the type of data input for a specific field, you:
Change the type in the Datasheet menu, under Data Type
All of these
Change view to Design, and change the data type


This holds data in a database:
MACRO
Form
Report
Table


What is a primary key?
It uniquely identifies each record in a table.
It uniquely defines each list in a report.
It uniquely identifies each list in a query.
It identifies multiple records in a table.


Which query can you delete records?
Update Query
Record Query
None of the above
Delete Query
Removal Query


What is a form?
An Access object where you can enter, edit or display data from a table only
An Access object where you can enter, edit or display data from a query only
An Excell object where you can enter, edit or display data from a table
An Access object where you can enter, edit or display data from a table or query


What kind of relationships can you do in a database?
One-to-one
All of these
One-to-many
Many-to-many


What is the best way to view and print the results of a query?
Table
Form
Export
Report


Of these, which can comparison operator symbols be applied to?
Numbers
All of these
Dates
Currency


Which data type allows for text and numbers to be added to a field?
Number
Text
Hyperlink
Date


In a query looking for salespeople whose first name starts with "L" but last name starts with "O", what kind of condition will you set?
Or
NOT
And
XOR


What would LCase("Tech on the Net") return?
tech on the net
ech on the et
FALSE
tn


You can edit the field size for allowable characters in:
Datasheet View
Pivot Chart View
None
Design View


True or False: You cannot assign a Macro to a Command Button.
False
True


You can import data into Access from:
An HTML file
Dbase
Excel
All of these


What are ways to collect data?
All of these
Type in everything
Import Files
Create an email with the Access File using Outlook


To edit how a form looks, you go to:
Print preview
Query Manager
Design view
Form view


Which are comparison operators?
greater than ">"
less than "<"
equal to "="
All of these


What does field size do?
Restricts the number of characters in a field to a preset amount.
Sets the size of a report.
Keeps the minimum number of characters in a field above a preset amount.
Sets the size of a form.


How do you make sure that a field from a query is displayed in the results?
A Form pushbutton is added
A Report displays the Query
The "Show" checkbox is not checked
The "Show" checkbox is checked


How do you ensure that a field is filled out in a table?
Set the "Required" setting to "Yes"
Make the field set to the "Memo" data type.
Use a filter.
Zoom to the field.


Can relationships be between primary keys and non-primary keys?
Does not apply to tables.
Yes
No
Only with a query.


Which of the following is NOT a valid data type in an Access table?
Text
AutoNumber
AutoIncrement
Memo


Which of these is a proper example of how to write an equation for a query?
(Amount)+(Field Name)
[Amount]+[Field Name]
Amount + Field Name
\Amount\ + \Field Name\


What is a caption?
Used as a user note on an opening form.
The label for a field when used on a form.
Sets a default value.
The same as a text box.


What do you call a value that is automatically entered in a filed for new records?
Date/Time value
Default value.
Primary Key.
Text


A good feature for having a unique primary key is:
Set the font to bold.
Use the AutoNumber feature
Use a MACRO to double check
Double check daily


Which database object acts as a storage container for the data?
Table
Form
Query
Report


What character do you use to concatenate two character strings?
& (Ampersand Operator)
# (Hash Operator)
! (Exclamation Operator)
* (Asterisk Operator)


If you delete a field from a table:
Only the data is erased
Both the field and the data are erased
Only the field is erased
Only a certain piece of data is erased


Which of the following is NOT a valid data type in an Access table?
AutoIncrement
Text
Memo
AutoNumber


When you press the Tab key, which way does the insertion point go?
To the end of the document
The adjacent field
Within the same field
A new record


Which of these would be a proper way to type a parameter?
#Where was this shipped to?
(Where was this shipped to?)
*Where was this shipped to?
[Where was this shipped to?]


True or False: Data in a subdatasheet can be edited.
False
True


What language is used to extend and automate MS Access?
Visual Binary for Applications
Visual C#
Visual Basic .NET
Visual Basic for Applications


What is the shortcut key combination for stopping the execution of a query?
CTRL+ALT+Delete
ALT+F11
CTRL+Break
Shift+Enter
ALT+Enter


The Where function does what?
Counts the number of records that match in a field
Creates a calculated field
Duplicates records displayed
Limit records displayed to those that match a condition


What is the file extension of an Access 2010 database?
.xlsx
.accdb
.mdb
.mdf


Where in an Access window can you search for a specific record?
2 of these are correct
Bottom of the window, with arrows and search bar
Find menu at the top of the window in the tool ribbon
In the help menu


Which of the following takes you through the process of creating a table
Wizard
Table Assistant
Relation
Query


Access _____ the saved query each time it is opened.
protects
deletes
rewrites
runs


To ensure a value no greater than 30 is entered into a field you would use:
A Caption
An Input Mask
A default value
A validation rule


How do you create a new table by importing an Excel Spreadsheet?
Create->export->Excel
External Data tab->Excel button in Import group
External Data tab->Excel button in Export group
Internal Data tab->Excel button in Export group


Which two objects can a report object be based on?
Query and Page
Form and Query
Macro and Table
Table and Query


Why should you enter sample data in tables after creating them?
To review existing data
To check for potential data maintenance problems
To create a preliminary list of fields
To identify primary and foreign keys


Name the object that is linked to a table that is used to enter data?
Report
Query
Macro
Form


You need a shortcut on a form to print a specific report. Which form design tool do you use?
Command Button
Insert Hyperlink
Unbound Object Frame
Attachment


Which of these is considered a record?
1 column of data
The whole table
A diagonal set of cells
1 row of data


What is each column in a table called?
Advanced Feature.
MACRO.
A row.
An attribute.


When you use the Max function, you are searching for...
None of these
The largest value in a record
The largest value in a field
The first value in a field


Your sales entry form does not tab through in the order you want between fields. You should:
Use a MACRO to enter the data
Manually set tab sequence on the form
Import the sales from an Excel spreadsheet
Delete the form and rebuild it


Which Database Tool allows you to identify tables with repeating information and suggest a more normalized table design?
Analyze Table
Analyze Performance
Database Documenter


In Microsoft Office Access 2010, which "Filter By Group" Options available in database objects pane:
Forms
Queries
All Access Objects
Reports
All of Them


What keyboard shortcut key do you press to get help?
F5
F10
F1
F12


What type of query is used to show data but that does not alter data on the table?
Append
Make Table
Select
Update


What would Len("Tech on the Net") return?
9
12
14
13
15


True or false: In the 2007 and later versions of Access, databases are not encrypted when a database password is applied.
True
False


What is the difference between regular version and runtime version of Microsoft Access?
The runtime version allows users to use the Access application and use its design surfaces.
The runtime version does not allow users to use the Access queries.
The runtime version allows users to use the Access application but they cannot use its design surfaces.
The runtime version does not allow users to use the Access application but they cannot use its design surfaces.
The runtime version allows users to use the Access queries.


What would Len("Tech on the Net") return?
12
3
9
15
7


The Input Mask Wizard is used to....
Change the field name in a table
Create a label for a data type
Hide information in a table from query results
Format data being entered into a table


What does setting "Allow Zero Length" to "Yes" in a text field allow?
It forces a string to be at least one character long.
It sets the default value to zero.
It sets the default value to "blank"
It allows zero-length strings in the field.


What are two ways to enter data into your database?
Via a form and directly into a table.
Via a normal query and directly into a table.
Via a form and a report
The only way is directly into a table.


If you wanted to create a query that removed records from an existing table, what kind of query would you create?
Make-Table Query
Delete Query
Removal Query
Update Query


In query design, if you want to find all records where the CITY field begins with the letter D you would enter:
Not A-C and Not E-Z
Is D*
Like "D*"
Like "D?"


On the ribbon with the Window tools, how can you view opened queries, tables, and reports?
Horizontal
Tile Vertically
All of these
Cascade


If you wanted to create a query that removed records from an existing table, what kind of query would you create?
Delete Query
Removal Query
Make-Table Query
Update Query


Access will allow Joins between two linked tables on different servers.
True
False


If you wanted to create a query that added records to an existing table (without overwriting existing records), what kind of query would you create?
Update Query
Append Query
Insert Query
Make-Table Query


What are relationships for?
To move information between tables
To solidify information
To ensure referential integrity


How do you move to the last record in a table?
Press CTRL+End
All are correct
Click the last record button


True or False: To hide repeating data in a column on a report you would set the Hide Duplicates Property to "No."
True
False


Before deleting a query object in your database you need to check whether any report objects are based on it. How do you do this?
Use the Analyze Table tool
Use the Analyze Performance tool
Use the Database Documenter tool
Use the Object Dependencies Task Pane


What are the 3 buttons for sorting data?
Sort numbers, A-Z, clear sort
Erase all sorts, Ascending, Erase one sort
Ascending, descending, clear all sorts
Ascending, descending, clear column


If you wanted to create a query that added records to an existing table (without overwriting existing records), what kind of query would you create?
Append Query
Update Query
Make-Table Query
Insert Query


Can you modify information while viewing a report?
Yes, if the report is active
No - unless you import the data first
No, you can only view information with a report
Yes, if the settings allow it


To find records within two dates you use
The FROM and TO operator
The BETWEEN and AND operator
The WITHIN operator
None of these


Where can you check the number of records you have in a database?
ID number column
Properties of the file
Top of the window
Bottom of the window


You want to limit what people can enter on a Form. They easiest way is to:
Reset the format
Use a drop down menu
Use a toggle switch
Use a text box to state what they should choose from


Where can you find the # of results in a Query?
Pop-up screen
Only in the find window
Lower left of the screen
Data Tools -> Find Query


What would Len("124ABCd") return?
NULL
-1
6
1
7


What is most commonly used for data entry?
Table
Report
Form
Query


You have imported data from Excel. You want Access to help you split your data into different tables. What do you do?
Use the Database Documenter tool
Access cannot do this for you
Use the Analyze Table tool
Use the Analyze Performance tool


What is the name of a query to which you can add records?
add query
additional records query
reference query
append query
update query


A best practice in managing a relational database such as the Access Jet database engine is:
Print a backup copy
Make multiple tables for redundancy
Normalizing the data
Link to the Internet


Do you have to have relationships set up in Access?
Only required if you are using a query.
Yes, it is always required.
Required if you are using a MACRO.
No, but it is a good practice.


An Input Mask is:
Used to set the maximum length of a field
Used to define the way data is hidden
A data pattern that restricts users from entering a specific value
A data pattern which dictates how users can enter data into a field


How does changing the appearance of a datasheet affect the underlying table structure?
It does not change the structure
The appearance is the data structure
Resets all queries
Changes only auto-update fields


You can use SQL to write Queries.
Yes, if you have SQL enabled on your database.
No, queries are made using the Microsoft query builder.
Yes.


Which of these is not a valid aggregate function for a query search?
Avg
Sum
StDev
Quo


When you run a query to find records in related tables, Access, by default, uses...
an Inner Join
a Right Outer Join
a Left Outer Join
Self Join


What would Replace("alphabet", "bet", "hydro") return?
bethydro
alphahydro
hydroalpha
hydrobet


Choose the correct criteria to enter when prompting a user for the Customer Name in a Query.
Like Customer Name *
[Enter the Customer Name]
#Enter the Customer Name#
"Enter the Customer Name"


To create a table relationship you would click on...
Database Tools, Relationships
Insert, Relationships
Edit, Relationships
Create, Relationships


Which of the following is not a valid view for an Access Form?
Design View
Form View
Edit View
Layout View


When can you set referential integrity between two tables?
All of these
When the Matching field is a primary key in one table or has a unique index
You cannot add a record to a table that contains a foreign key, without a corresponding record in the primary key table
You cannot change the definition of related fields on fields that have referential integrity enabled.


How do you resize a column?
Merge two cells together
Use functions in Format as Table
Click and drag along the border of a cell
Click and drag along the right border of a field


The Following statements are all true except:
You write the criteria for a query in the design grid
You can select which fields are chosen and hidden in a query
You may use more than one table in a query
You can only have one criterion per line in the design grid


Which term is used to refer to a single piece of data stored in a field?
Tables
Field
Value
Record


You require a Grand total to be printed on a Report. You create a calculated field and place the control in which section on the report?
Page Footer
Report Footer
Group Footer
Detail section


You require a form control that provides a text box to which a drop-down list is attached. Users can either type a value directly into the text box or select from the list of choices available. Which control will you choose?
Option Group Control
Combo Box control
List Box control
Text Box Control


In which row of the query design grid do you specify what is used to filter the results?
Total
Sort
Criteria
Filter


Normalization is the process of:
combining two or more fields together to create a primary key
All of these
organizing data in a database to produce optimized table structures
adding redundant data to a table to speed up database access


What does it mean to enforce referential integrity.
You can't alter the data in the record.
This isn't a feature in access.
You can now automatically delete all the data related to your record.
You can quickly see all the relationships in your table.
You can't update the data to violate the record's relationship.


What would Mid("Alphabet", 3, 10) return?
Alphabet
phabet
NULL
-1


How would one bypass the the execution of AutoExec Macro when you open Microsoft Office Access database?
Press and hold "m" Key
None of the above
Press Ctrl + Break (in Windows)
Press and hold Shift Key
Press and hold "k" Key


How do you create a switchboard?
Database Tools->SQL -> Switchboard
Database Tools -> Switchboard Manager
Access doesn't have a switchboard option
Create -> Switchboard


When do you use the Lookup Wizard?
You want to lookup the value of a field from another table or create a list of values to choose from
You want to lookup up the contents of a field in a table in Datasheet View
You want to lookup specific objects that are related to the table
You want to bypass using referential integrity between two tables


What happens when Best Fit is used?
Text is formatted to fit the cell better
Numbers are written in word form and vice-versa
Only affects the rows
Text is formatted to fit the form better


You want to create a flexible query that prompts the user for additional criteria. What will you create?
Action Query
Select Query
Parameter Query
Flexible Query


In a loop that begins with "Do Until rs.EOF = True", what problem occurs if you omit "rs.movenext"?
You get a message saying "Recordset Move is Required"
You get error number 3021 "No Current Record"
The code continues executing but Access appears to hang.
The code takes slightly longer to run


What does an Action Query do?
Does not modify data
Modifies data in some way.
Automatically displays a report
Automatically starts a MACRO


Each sales person has many customers. Each customer can have many orders. In building a query for how much in sales a salesperson is generating, what kind of relationship will exist between customer and orders?
Many-to-many relationship
Many-to-one
One-to-many
None exists


How do you password protect your database?
Open Database->Database Tools->Switchboard tools-> Make ACCDB
Open Database in exclusive mode->Database Tools-> Encrypt with Password
Open Database in inclusive mode->Database Tools-> Encrypt with Password
Open Database->Database Tools-> Make ACCDE


What does the Run button do?
Executes and renders the results within a table
Renders a report of the query
Changes the fonts and cells of the query
Executes and renders the results of the query in a new tab


If the "Row Source" property on a combo box was set to "Beginner";"Intermediate";"Advanced", what value would you assign to the "Row Source Type" property on that combo box?
Column List
Value List
Table/Query
Field List


Which of the following helps to study the information in a table and then make changes to streamline the data?
Access Analyzer Wizard
Sync Table Contents
Table Analyzer Wizard
Evaluate Data
Table Data Wizard


Which one listed below is not a valid version of MS Access?
XP
2010
2005
2003
2007


What is one way to run a macro when opening an Access Database?
Press and Hold Shift Key
Use the settings to define which Macro you want to run first, on open.
Select Options from Office Button then change default macro setting to "Run Always"
Create a Macro named AutoExec


When creating or editing a table in design view, the 'Required' field property default value is 'No'.
False
True
There is no Required field property


Double Clicking the Active Tab on the Ribbon will:
Hide or Unhide the Ribbon
Close Access
Close the current database
Open a Dialog Box


True or False: You can upgrade a 2003 or earlier Access file (.mdb) to a 2007 or later Access file (.accdb) while a database password is configured.
True
False


What is the maximum size of Microsoft Access 2010 database file?
2 GB
4 GB
1 GB
2 GB, minus the space needed for system objects
3 GB


What would RTrim("Tech on the Net ") return?
"Tech on the Net"
undefined
false
"TechontheNet"


What format must the filename be in to be protected?
.Access
.ACCDB
.ACDC
.ACCDE


What keyboard shortcut will bypass autoexec macros when opening an Access database?
Hold down Ctrl+Shift while opening the database
Hold down Alt+Shift while opening the database
Hold down Shift while opening the database
Hold down Ctrl+Alt while opening the database
Hold down Ctrl while opening the database


How do you copy a record?
Right-click the start of a row and click copy
Right-click the start of a column and click copy
Press Ctrl + C in a cell
None of these


In Design View, what is the first step to create a query?
Create->Query Design->Split Form
Data->Create-> Query
Create->Query Design-> Double-click on table name
Database Tools->Relationships->Query


When editing a relationship in the Relationships screen, which of these is not an option?
Enforce Referential Integrity
Cascade Delete Related Records
Cascade Update Related Fields
Disable Referential Integrity


Can an access database application be run in a Linux environment?
Yes
No


Which of these aspects of a Linked Table cannot be changed?
Table definition
Record values
Connection string
Table alias


Access is available for a Mac.
False
True


When you move between records on an Access Form, which one of the following events fires?
On Activate
On Got Focus
On Current
On Close


What does DAO stand for?
Database ActiveX Objects
Database Access Objects
Data Access Objects
Data ActiveX Objects


Which of the following is NOT a type of query in Access?
CrossTab
CrossSelect
Pass-Through
Make-Table


The report header displays on:
The first page only
The first and last page of the report
All pages of the report
Every other page of the report


You put the following code near the top of an Access form: Global rs10 As DAO.Recordset The code causes an error because?
Global variables are allowed but disabled by default
Global Variables cannot be declared in Form Objects
Global variables cannot be of type DAO.Recordset
Access does not allow Global Variables


Which of the following are views that a table can be changed to?
Data Entry
Print
Data View
Datasheet


To filter a table in Datasheet view, what do you use?
Filter by Selection
Filter by Field
Filter by Range
Filter by Record


In the design view of a make table query the destination table name is displayed:
In the propery sheet with selection type query properties.
In the table row of the query design window.
In the update to row of the query design window.
In the header, next to the query name.
In the parameters list.


"Yes/No" answers in Access are commonly stored as:
0 or -1
North or South
True or False
0 or 1


The Yes of a Yes/No data type field equates to which?
1
0
-1
2


Which of the following is not included in the Access Built-In Functions for SQL Aggregate
VarP(«expression»)
Count(«expression»)
StDev(«expression»)
Median(«expression»)
Sum(«expression»)


What does a Pass-Through Query do?
Passes data through validation without inserting new records.
Inserts new records, bypassing validation.
Sends a SQL statement to a remote server for execution.
Sends a SQL statement to a remote server for validation, not execution.


True or False: Union Queries must be created by manually writing the SQL.
True
False


Is it possible to use the record MACRO function in Access?
Yes, if your settings allow it
Yes, just as in Excel
No, this is not supported in Access
No, unless you import the data first


What does ADO stand for?
Access Data Objects
Access Database Objects
ActiveX Data Objects
ActiveX Database Objects


In the design view of an update query the top row, labeled field is:
The field name from the table being updated.
Rows that will be included when the query is run.
Fields from the source table that match the table being update.
The criteria field used to select the data to be updated.
The field name from the table used as a source of new data.


Access 2007/2010 theoretically allows how many concurrent users accessing the same .accdb database file?
255
50
1000
256
100


What must be the same for a relationship to work?
Must have the same data type
Must have the same field size
Must have the same field name
Must have same data type and field size


What are the three wildcard characters Access allows you to use when searching?
*, %, #
*, #, ?
*, #, $
*, $, ?


What would Format("0.981", "Percent") return?
98.1%
98%
98.10%
99%


Which of these statements are false?
It is not possible to sort query results.
When a criterion is typed wrong, nothing shows up in results
It is possible to make a query from a query


When you open an Access Form, what is the second event that fires?
On Load
On Open
On Current
On Activate


Field selectors are located...
within the cells
within the field
at the bottom of a table
within the menu command
at the top of a table


What is the "iif" function named?
Inferred If
Immediate If
Internal If
Integrated If


Which of the following Access 2010 macro actions does not require you to select "Show All Actions" in order to use it in Macro Design?
Echo
RunSQL
RunSavedImportExport
SetWarnings
RunCode


You are creating a Macro and you require the SetValue Action, but it does not exist. What do you do?
Click the Macro Tools Design Tab and choose "Conditions" from the Ribbon
There is no such Macro command
Click the Macro Tools Design Tab and choose "Macro Names" from the Ribbon
Click the Macro Tools Design Tab and choose "Show all Actions" from the Ribbon


Concerning the code below, which of the following statement is False? Dim rst as ADODb.Recordset
When configured properly, ADO recordsets can be disconnected from the database and still be bound to a form.
A Reference to ActiveX Data Objects will be required for this code to work.
Recordset variables must always be named 'rst'.
ADO Recordsets can be fabricated without any database connection


What would Format("210.6", "Standard") return?
210
211
210.6
210.60


Which of the following is considered an "Unsafe Action" in an Access 2010 macro and would require you to "Show All Actions" in order to use it in Macro Design?
Beep
RunMacro
Requery
RunCode
SaveObject


How do you widen the columns in the design grid?
Click and drag on the left border of the top of the column
Double Click the right border of the cell
Double-Click on the right border of the top of the column
Double-Click on the right border of the left of the column


You need to create a lookup field where more than one option can be chosen. Where would you do this?
This cannot be done in Access 2010, only one value can be stored at a time
In the Lookup Wizard check "Allow Multiple Values"
In the Properties for the field select "Allow multiple values for this field"
Choose the Multiple Value data type in Table Design View


Concerning encryption, which of the following statement is True?
MD5 Encryption and hashing can be done in Access VBA using .NET functions.
Access has native functions for MD5 encryption and hashing.
Microsoft has addins available for MS Access for doing MD5 encryption.


On printing a report you find that the Comments field is printing </div> for every record in the Comments field. How do you rectify this?
Change the Text Format property for the field to Plain Text
Change the Text Align property for the field to Distribute
Change the text format property for the field to Rich Text
Change the Width Format property for the field to allow for more space


You can add your company logo to a form in:
All Views
Form View
Design & Layout Views
Layout View
Design View


What is typically displayed on a Relationship Report?
The current date and database name
The date and time of the report and the database name
The time of day of the report and the folder name that the database is in
The date of the initial report creation and the user name


What would Instr(20,"Tech on the Net","t") return?
1
0
-1
2
NULL


Which is not a benefit of upsizing to an SQL server?
Time delayed recoverability
Support for large databases
All of these are benefits
Improved security


What key displays the Database Window?
F9
F12
F8
F10
F11


To query two tables that are unrelated you:
First have to add fields to both tables to make them related
First create the relationship in the Relationships Window
Cannot do this
Create a junction table which contains fields common to both tables


How do you print a database?
Use the print option after clicking the View tab
Use the print option after clicking the Microsoft button
Use the print option after clicking the Page Layout Tab
None of these


What does DAO stand for?
Database ActiveX Object
Database Access Object
Data Access Object
Data ActiveX Object


To adjust the length of fields in a report while displaying data you would use:
Print Preview
Report View
Layout View
Design View


Which of these can you apply conditional formating to?
Form
Query
Report
Table


Datasheet views are different from continuous forms in very subtle ways. Which of the following statement is false?
Datasheet views can be embedded as subforms.
Datasheet views can be bound to disconnected ADO Recordsets.
Datasheet views cannot contain buttons inside rows and columns.
Datasheet views have built in features for sorting and filtering.
Datasheet Views cannot have code modules associated with them.


What does a group header or group footer do?
Displays the field label of grouped data on the top or bottom of a query
Displays the field label of grouped data on the left or right of a report
Displays the field label of grouped data on the top or bottom of a report
Displays the group label of data on the top or bottom of a report


Which of these statements is true?
A ? Wildcard is not used to search for single characters
You do not need to put a $ in front of numbers in criteria
You cannot use the same kind of criteria more than once in the same query
All of these


You wish to filter data on a report before printing without changing the design of the report. How do you do this?
You cannot do this in Reports
Modify the Query for the report and enter the criteria
Switch to Print Preview, select the Home Tab and click Filter, uncheck the Select All check box, and check the values you want to filter on
In Layout view, select the Home Tab and click Filter, uncheck the Select All check box, and check the values you want to filter on


What type of database is Access?
File server database
Non-relational database
Inverted database
Client/server database

No comments:

Post a Comment