Microsoft Access 2010 Test
Which
of the following rules apply when you use referential integrity?
a. You
cannot delete a record from the primary table if matching records exist in the
related table.
b. You
cannot enter a value in the foreign key field of the related table that does
not exist in the primary key of the primary table.
c. You
can change the primary key value in the primary table, if that record has
related records in the related tables.
d. All
of the above
What
will be the result of the following?
InStr(1,
"John Smith", "S")
a. 5
b. 6
c. 7
d. 4
Which
of the following functions determines if a phrase exists in a longer string?
a. InStr
b. Len
c. Trim
d. Left
Password
protected databases offer:
a. Only
one password with full rights.
b. Different
user rights for different logins/passwords.
c. Integrated
security with Active Directory.
d. Integrated
security with Windows Logins.
This
question is based upon the figure shown below
a. CREATE
Cars (Name TEXT(40), Year TEXT(4), Price CURRENCY)
b. CREATE TABLE Cars (Name TEXT(40), Year
TEXT(4), Price CURRENCY)
c. CREATE
TABLE Cars (Name(40), Year(4), Price)
d. CREATE
Cars (Name(40), Year(4), Price)
Which
of the following is not true regarding Information Rights Management (IRM) for
e-mail messages in Microsoft Access 2010?
a. It
prevents restricted e-mail content from being copied by using the Print Screen
feature in Microsoft Windows.
b. It
restricts the e-mail content from being copied by using third-party
screen-capture programs.
c. It
prevents an unauthorized recipient from accessing e-mail content, including
attachments.
d. It
restricts content wherever the e-mail is sent.
What
is the advantage of a Class Module versus a Standard Module?
a. Encapsulation,
Inheritance
b. Data
Abstraction
c. Polymorphism
d. Reusability
What
is the purpose of Option Explicit?
a. It
is a database object.
b. Requires variable declarations.
c. It
contains all of the data access pages that are currently open in a Microsoft
Access project.
d. It
contains all open standard modules and class modules in a Microsoft Access
database.
When
you run the Compatibility Checker in Microsoft Access 2010, in which of the following scenarios can you
get the error- Access was unable to convert the query for use
on the Web because it relies on an ORDER BY clause that is not supported on the
Web?
a. Name of an order by element is not valid.
b. Name
of source table is not valid.
c. Sort
order is set to an option other than ascending or descending.
d. The
expression is not valid.
e. All
of the above
Which
of the following is not done when you compact a database?
a. Table
records and objects are restructured and then stored in successive memory
blocks.
b. Databases linked to the compacted database
are compacted and repaired.
c. Table
records are restored into their primary key order, if a primary key exists in
the table.
d. The
physical size of the database is reduced by making an exact duplicate of the
database.
How
do you create a report for a Crosstab Query if certain column values are
missing?
a. Set
the Value field in the Crosstab.
b. Set
the Column Heading field in the Crosstab.
c. Set
the Pivot list in the Crosstab.
d. Set
the report's Crosstab property to True
Which
of the following elements are mandatory for the CREATE INDEX command?
a. The
name of the index.
b. The
ON argument.
c. The
list of fields to be included in the index.
d. The
name of the table that contains the fields that you want to index.
e. All
of the above.
Using
which of the following Microsoft Access 2010 database file formats, can we use
the Package and Sign tool?
a. .accdb
b. .accdc
c. .accde
d. .mdb
Which
of the following conditions should be satisfied to create a one-to-one
relationship between tables?
a. The
primary key and foreign key fields must have a unique index.
b. The indexed property for the primary key
and the foreign key fields should be set to Yes.
c. The
common fields must have a unique index.
d. All
of the above
If
you want to encrypt a database by using a password, then the database must be
opened in _____________ mode.
a. Open
Exclusive
b. Open
Exclusive Read-Only
c. Open
Read-Only
d. Open
Password-Enabled
Which
of the following is incorrect about the Quick Access Toolbar?
a. You
can move the Quick Access Toolbar from its default location.
b. Toolbar
can be minimized or collapsed.
c. You cannot display the Quick Access
Toolbar on multiple lines.
d. You
cannot increase the size of the buttons representing the commands by an option
in Microsoft Office.
What
can you do in Report View that you cannot do in Print Preview in Microsoft
Access 2010 Reports?
a. You
can Filter, Copy, Search, etc.
b. You can make most, but not all, changes to
your report.
c. You
can display the structure of your report.
d. Resize
report sections, such as Headers, Detail, and Footers
Which
of the following is not a Relationship and Lookup error?
a. Lookups
require an associated Relationship to be compatible with the Web.
b. Limit
to List must be set to True if Allow Multiple Values is set to True.
c. Enable
Referential Integrity must be False if Allow Multiple Values is set to True for
a lookup.
d. A
table with more than 220 fields is incompatible with the Web.
What
happens when a user has a database open in Exclusive mode and another user
attempts to open it?
a. The
second user can open the database and make changes to objects and data.
b. The
second user receives a 'File already in use' message.
c. The
second user receives a 'File is deleted' message.
d. The
second user can open the database and make changes to data, but not to objects.
Which
of the following is NOT possible when you link to an Excel worksheet from
within Access?
a. You
can append data to an existing table.
b. You
can create a database containing multiple linked tables.
c. You
can edit the Excel spreadsheet by making changes in to the linked table.
d. By
creating a linked table any changes that are made to the data in Excel are
automatically reflected in the linked table.
How
can you tell if a report has no records to display or print in Microsoft Access
2010?
a. By
using the report's Error event.
b. By
using the report's ApplyFilter event.
c. By using the report's NoData event.
d. By
using the report's Filter event.
Using
the Package and Sign tool, how many databases can you add to a package that you
want to distribute to other users in Microsoft Access?
a. Unlimited
b. 5
c. 1
d. 10
Which
one of the following correctly selects rows from the students table that have
null in column1?
a. Select * from students where column1 is
null
b. Select
* from students where column1 = null
c. Select
* from students where column1 EQUALS null
d. Select
* from students where column1 NOT null
e. Select
* from students where column1 CONTAINS null
Suppose
you want to use data from two tables in a query: tblCustomer and tblOrder. The
two tables both have a field, CustomerID, that identifies a customer. Each
record in the tblCustomer table may have one or more corresponding records in
the tblOrder table, and the corresponding values can be determined by values in
the CustomerID field. You now want to join the tables so that the query
combines the records from the tables, excluding records from either table if
there is no corresponding record in the other table. Which of the following
FROM clauses will you use?
a. FROM
[tblCustomer] LEFT JOIN [tblOrder] ON
[tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
b. FROM
[tblCustomer] RIGHT JOIN [tblOrder] ON
[tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
c. FROM
[tblCustomer] INNER JOIN [tblOrder] ON
[tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
d. FROM
[tblCustomer], [tblOrder]
This
question is based upon the figure shown below
a. Select
lastname from students where lastname like '[A,O, Y]*'
b. Select lastname from students where
lastname like '*[A, O, Y]'
c. Select
lastname from students where lastname not like '*[A, O, Y]'
d. Select
lastname from students where lastname not like '[A,O, Y]*'
e. Select
lastname from students where lastname='A' or lastname='O'or lastname='Y'
This
question is based upon the figure shown below
What
is the purpose of the option marked as A (see image), under General options for
working with Access?
a. It
allows users to preview how a formatting option will appear.
b. It
indicates that the text will be displayed in a format that is easier to read.
c. It
enables ScreenTips and Enhanced ScreenTips.
d. Both
b and c.
This
question is based upon the figure shown below
Layouts
are guides to align controls that you add to your forms or reports. Which
layout has been depicted in the image above?
a. Print
Preview
b. Tabular
format
c. Stacked
format
d. Grid
format
For
what reason(s) can a digital signature or certificate be regarded as invalid?
a. The
publisher is not a trusted publisher.
b. The
digital signature has expired.
c. The
certificate was not issued by a certified authority.
d. All
of the above.
Which
feature in Microsoft Access 2010 can be used to ensure consistency in
appearance between forms and reports?
a. Web
2.0-like Controls
b. Web
Browser Controls
c. Office
Themes
d. Backstage View
This
question is based upon the figure shown below
What
is the function of the 'Single Step' in Macros as shown in the image?
a. This
command saves expressions one at a time.
b. This
command executes an action one at a time.
c. This
command saves all queries in a single step.
d. This
command saves all reports in a single step.
What
is the purpose of time stamping a digital signature in Microsoft 2010?
a. It helps mitigate integrity threats.
b. It
ensures that digital signatures remain valid and legally defensible even if the
certificate that is used to sign the document expires.
c. It
enables you to specify cryptographic settings for encrypting documents.
d. It
is a security tool that enables users to designate safe documents.
Which
of the following Microsoft Access 2010 components can pose security risks in an
untrusted database?
a. Action queries (queries that insert,
delete, or change data)
b. Macros
c. Forms
d. VBA code
What
could be the problem when an error message "#Error" is received in a
query?
a. The
query is joining fields that have different data types.
b. A
field's alias conflicts with a component of the expression for that field.
c. The
object or the database is damaged.
d. The denominator of a calculated field is
zero.
Which
text box property in Microsoft Access 2010 Reports allows the text box to be
expanded so that all the text can be fit into it?
a. CanGrow
b. Reading
Order
c. Display
When
d. None
of the above
Which
of the following are reserved for use by SharePoint and is not supported on the
Web?
a. Solutions
b. Docs
c. Lists
d. UserInfo
e. Reports
A
query that uses the BETWEEN operator for two numbers is identical to:
a. >=
and <=
b. >
and <
c. >=
and <
d. >
and <=
How
can you share common objects between multiple projects in Microsoft Access
2010?
a. By
customizing tabs.
b. By
creating Data Macros.
c. By
using a Web Browser Control.
d. By creating Application Parts.
Suppose
you want to apply a calculated field on a TextBox control to concatenate the
values of the firstName and lastName fields, with a space between them.Which of
the following expressions will you enter in the Expression Builder?
a. [firstName]
+" "+[lastName]
b. [firstName]
+" #"+[lastName]
c. [firstName]
&" "& [lastName]
d. [firstName]
&","& [lastName]
This
question is based upon the figure shown below
What
will happen when we select the option "Check for truncated number
fields" (marked as A in the image) under Current Database settings?
a. The
values visible in a column are truncated based on what can fit in the column.
b. Access
displays numbers as "#####" when a column is too narrow to display
the entire value.
c. Access
displays numbers as "*****" when a column is too narrow to display
the entire value.
d. Access
expands the column if it is too narrow to display the entire value.
Choose
the appropriate query for the Products table where data should be displayed primarily in ascending order
of the ProductGroup column. Secondary sorting should be in the descending order
of the CurrentStock column.
a. Select
* from Products order by CurrentStock, ProductGroup.
b. Select
* from Products order by CurrentStock DESC, ProductGroup.
c. Select
* from Products order by ProductGroup, CurrentStock.
d. Select
* from Products order by ProductGroup, CurrentStock DESC.
e. None
of the above.