a value that can connect two
tables simultaneously.
a unique value that identifies
each row within a table.
another name for a candidate key.
a field in one table that is also
the primary key of another table.
Question
2. 2.(TCO 1)
What Microsoft Access feature would give a United Parcel Service (UPS)
manager the ability to ask questions like “How many UPS tubes were shipped
Monday?” and “What was the total revenue generated from UPS Express Box
Large in November 2013?”
(Points : 5)
Question
3. 3.(TCO 1)
Which of the following is NOT an Access interface element? (Points : 5)
Criteria
Navigation Pane
Status Bar
Title Bar
Question
4. 4.(TCO 1) A
filter in Access
(Points : 5)
creates a new table with matching
criteria.
deletes unique records from the
database.
allows the user to edit specific
records.
displays a subset of records based
on specified criteria.
Question
5. 5.(TCO 1)
Which of the following is NOT one of the query wizards in Access? (Points : 5)
Question
6. 6.(TCO 2) A
field that uniquely identifies each record in a table is a (Points : 5)
link.
relationship.
primary key.
foreign key.
Question
7. 7.(TCO 2) A
single Crow’s Foot at the left-most end of a relationship line would
indicate (Points : 5)
a many-to-many relationship.
a one-to-many relationship.
a one-to-one relationship.
no relationship.
Question
8. 8.(TCO 3) All
of the following describe a caption property EXCEPT (Points : 5)
allows for placing spaces between
words.
can take the place of a field name
in Datasheet view.
can be used in place of a field
name in an expression.
the caption appears in Datasheet,
Report, and Form views.
Question
9. 9.(TCO 3) A
functional dependency is(Points
: 5)
a logical relationship between
attributes of a table.
a logical primary key.
a composite key.
a unique identifier.
Question
10. 10.(TCO 3)
Which of the following does NOT apply to the following relationship image?
Image Description: Three Tables are pictured: Table 1: Suppliers with a
primary key of SupplierID and fields: CompanyName, ContactName,
ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and
HomePage. Table 2: Products with a primary key of ProductID and fields:
ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice,
UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3:
Categories had a primary key of CategoryID and fields: Categoryname,
Description, and Picture. There is a relationship labeled 1 attached to
Table 1 or Suppliers and an infinity symbol attached to Table 2 or
Products. (Points : 5)
A one-to-many relationship is
applied.
The display is showing the Design
view of relationships.
One table is not joined to the
other two tables.
A join exists on two primary keys.
Question
11. 11.(TCO 4)
Which function is used to isolate a specific portion of a date, such as
year, month, or day in a date field? (Points : 5)
Date
DateDiff
DateParse
DatePart
1.(TCO 5) Which form type displays
records in a tabular format similar to a Datasheet view but has more
editing options, such as adding graphics? (Points : 5)
Datasheet Form
Multiple Items Form
Split Form
Subform
Question
2. 2.(TCO 5) The
following are form creation tools EXCEPT (Points : 5)
blank form.
form design.
form layout.
Form Wizard.
Question
3. 3.(TCO 6)
Queries are objects in a database based on one or more underlying (Points : 5)
forms.
modules.
tables.
macros.
Question
4. 4.(TCO 6)
After running a query, which view will be shown? (Points : 5)
Datasheet
Design
Query
Result
Question
5. 5.(TCO 9) All
of the following are drawbacks to normalization, EXCEPT (Points : 5)
less tables and larger columns.
CPU usage.
memory usage.
input/output resources.
Question
6. 6.(TCO 2)
Which of the following statements best describes data mining? (Points : 5)
It is the determining of future
volume of sales.
It is the predicting of future
customer buying behavior.
It is identifying patterns or
relationships through a process of analyzing large quantities of data.
It is tracking customer purchasing
behavior.
Question
7. 7.(TCO 8) All
of the following describe a Navigation Form EXCEPT (Points : 5)
click the Create tab and then
Navigation in the Forms group to create a Navigation form.
is another term for a Switchboard
Manager.
helps users open forms and
reports.
has the look and feel of a web
form.
Question
8. 8.(TCO 9)
Open Exclusive means that
(Points : 5)
a password is required to open the
Access database.
only one person has access to the
Access database at any time.
only selected persons can have
access to the Access database.
two or more people cannot open the
same Access database at the same time.
Question
9. 9.(TCO 9) All
of the following are true when a user creates his or her own self-signed
digital signature EXCEPT
(Points : 5)
a time stamp is not required to go
through a commercial service or local server for processing.
a time stamp will prove when the
file was last used.
it is created through another
software application.
it will prove that the creator
owns the database.
Question
10. 10.(TCO 10)
The ACCDT file format type refers to a(n) (Points : 5)
database.
digitally signed database.
executable database.
template.
Question
11. 11.(TCO 4) The
term cascading refers to
(Points : 5)
data changes travel from one table
to another.
data is put in sequential order.
queries can retrieve data at a
faster rate.
records are arranged in order.
1. (TCO
1) Designing a database often involves obtaining different perspectives from
various sources to gather information. Discuss the importance of end-user
interviews in the data requirements-gathering process.
(Points : 40)
2. (TCO
2) Explain the purpose of a conceptual database model and describe the most common
method of creating one. (Points : 40)
3. (TCO
4) What are the advantages and disadvantages of the denormalization process. (Points : 40)
4. (TCO
4) Explain a one-to-many relationship and provide two examples. (Points : 40)
Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A
