For Order This And Any Other
Course, Assignments, Discussions, Quizzes, Exams,
Test Banks And Solutions Manuals
Or Visit Our website Acehomework.net
(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) Filters are used to do all of the following EXCEPT (Points : 5)
a filter can be removed by selecting Remove Filter from
the Sort & Filter group.
all records in a table will be displayed if all of the
filters are removed.
filter effects are cumulative.
it does not matter whether you apply a filter or a sort
first.
Question 5.5.
(TCO 1) A report creation tool that will automatically pull in the fields from
a table or query is the (Points : 5)
report tool.
report design.
report wizard.
blank report.
Question 6.6.
(TCO 2) Which of the following is not a database system? (Points : 5)
Hierarchical
Network
Relational
SQL
Question 7.7.
(TCO 3) Which of the following should be considered when designing a database?
(Points : 5)
How calculated fields are used
Store data in its smallest parts
The relationship between attribute keys
The relationships between records
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) All of the following summarize characteristics of a PivotTable EXCEPT
(Points : 5)
can display information that is typically found in
Datasheet totals.
can only be created from a table.
data is organized and summarized in an easy-to-read view.
is created by dragging fields from a field list into
appropriate drop zones.
Question
10.10. (TCO 3) Which of the following does NOT describe a caption property?
(Points : 5)
A label can substitute for a field name in Datasheet View.
The caption appears in Datasheet View, Form, and Report.
The label allows spaces between words.
The label can be used in place of a field name in an
expression.
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) A bound control (Points : 5)
always contains a label.
contains text and number values entered by the user.
is unique and contains a data field from another
underlying source.
must contain a formula.
Question 3.3.
(TCO 6) Which of the following is a term used to describe the names of
controls, fields, or properties? (Points : 5)
Function
Identifier
Operator
Value
Question 4.4.
(TCO 6) Using the rules for order of operations, what is the result of the
following expression: (4 * 3) +1 + 4 - 2 * 3 + 5 ? (Points : 5)
11
16
18
50
Question 5.5.
(TCO 7) Which term best describes demographics? (Points : 5)
It is a bar code on a card that contains information about
you.
It defines population into segmented groups such as age,
income, gender, and race.
It is the quantity of merchandise a store will purchase.
It is tracking customer purchases.
Question 6.6.
(TCO 7) Discrete data (Points : 5)
are easily scaled.
are used to measure time or money.
cannot be subdivided into meaningful information.
may be subdivided into smaller and smaller units.
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.
Of the following security techniques available in Microsoft Access to keep a
database application safe, which choice would make the database virtually
impossible to break into: (Points : 5)
Creating a menu system
Encrypting and password-protecting the database
Digitally signing and publishing the database
Saving the database as an ACCDE file
Question 9.9.
(TCO 9) Database security is a specialty within computer security that protects
a database application from unintended use. Unintended use includes: (Points :
5)
unauthorized viewing of data
inadvertent mistakes made by employees
malicious attacks
all of the above
Question
10.10. (TCO 10) After creating an ACCDE file, you (Points : 5)
can convert
it back to its source format.
will see a "file already in use" message that
continues to display to all other users.
will be able to modify forms and reports but not tables.
will need to go back to the original file if an underlying
object requires a change.
Question
11.11. (TCO 4) Which of the following is NOT true of a ship date field? (Points
: 5)
A ship date is considered a constant.
A ship date would be defined as a date/time field.
A ship date would be defined as a calculated field.
Date arithmetic can be applied to a ship date field.
1. (TCO 1)
Let’s imagine this scenario. Development of a database system is about to
start. Before development actually starts, the Director of Systems Development
asks you to evaluate the database schema design and report your observations.
Given this scenario what would you look for? Please discuss and explain.
(Points : 40)
Question 2.
2. (TCO 2) What is a conceptual model? Explain its importance. Conceptual
models are typically made up of three main parts. Name these parts giving a
full definition and purpose. Give two possible examples of each part. (Points :
40)
Question 3.
3. (TCO 4) What are the advantages and disadvantages of de-normalization
process. (Points : 40)
Question 4.
4. (TCO 4) Explain 1NF, 2NF, and 3NF as related to database design. (Points :
40)
Question 3: Explain the terms
entity and attribute. Describe an example of an entity and then list two
attributes. Using your examples, explain the data types that would be used to
capture the attributes.
Question1: TCO 1) Justify the decision to use a Report instead of a Form
to present Last Month's Sales Results to the Sales Managers at the Monthly
Business Meeting.
Question 2: (TCO 2) the relational model relies on primary keys to
identify entities and on foreign keys to create relationships to preserve the
integrity (validity) of the keys. Discuss the two rules that ensure the integrity
of keys within a database.
For The Students Who Need Grade ‘A’
In Their Studies
Hi, hope you are having a
great day…
We are a group of 24 writers having profound expertise in Business and
Computer Science subjects. We can help you score A grade in your Accounting,
Marketing, Finance, Economics, Management, Mathematics, Statistics, Information
System, System Modeling, C++, Java Programming, Network Administration,
Enterprise Administration, Database, Web Design, Networking, Internetworking,
Data warehouse etc…
We can also provide help
with Psychology, Nursing, Health, History, English Literature, Political
Science, Ethics, Humanity etc classes.
We can help with essays,
term papers, research papers, dissertation, Ilabs, mymatlab, Wileplus, quizzes,
exams, discussion questions etc.
You can expect:
We understand each
student has different requirement and we tend to treat each student according
to his/her satisfaction.
We will provide original
assignments, plagiarism free and to custom requirement.
We will always meet
deadlines.
Our support will be
24/27, even in holidays.
Our pricing will be fair.
We will do free revisions
if you want to make changes in provided work.
Email us for more information, query and quote.
No comments:
Post a Comment