Liberty University
BUSI 201 Group Project Part 2 solutions answers right
Intermediate Business
Computer Applications
Group Project – Part 2 Instructions
After
learning about the Access program, you have determined that some of your data
from the budget is better suited for Access. The Members spreadsheet you have
created could be a great way to keep track of church members and their
donations. Keeping this data in a two-dimensional spreadsheet could become
difficult as you begin to add multiple donations for each member. Instead, you
will use the relational power of Access to keep member data in multiple related
tables.
Requirements:
1. Members (Relevant chapters – Access
1–2)
a. Import your data from the Members spreadsheet into a new
Access database table named Members.
b. Be sure to add a primary key—a field that will uniquely
identify each member. Remember that you must not use names or information that
could potentially be repeated as a primary key.
c. Create a second table that will house the donations from each
member. Identify an appropriate field to exist in both tables that will serve
as a common field.
d. Create a relationship between your 2 tables. Resolve any
potential errors in your database design at this point.
e. Add data to the new Donations table. Include at least 30
donations and ensure that some members have multiple donations entered.
2. Enter Donations (Relevant chapter – Access
3)
a. Develop a form for entering new data called Enter Donations.
b. This form must be designed so that you can easily enter new
donations without going to the Donations table.
c. The goal here is a clean, comprehensible appearance that
allows any user to quickly add new information to the database.
3. Major Donors (Relevant chapter – Access
4)
a. Create a query that will display all users with donations
over an amount of your choosing.
b. Name the query Major Donors.
4. Mailing Labels (Relevant chapter – Access
3)
a. Create a report that will allow you to print mailing labels
for all members in the database.
b. Name the report Mailing Labels.
In
addition to Excel and Access, you have learned some advanced features of
PowerPoint. Develop a PowerPoint that will summarize the work that you have
done in your group.
Requirements:
1. Member Introduction and
Group Summary
a. Briefly introduce each group member. Include a picture and a
short description of the individual’s strengths and contributions to the team.
b. Add each group member’s favorite Bible verse and an
explanation of how this verse has served as a guiding light in his/her work
with the team. (If it has not, have the member be honest and describe why or explain
how he/she can better use the verse to guide his/her actions in the future).
c. Your PowerPoint must walk the audience through your group’s
process and the highs and lows that may have occurred along the way.
2. Ethical Implications
and Biblical Worldview
a. Add several slides considering the ethical implications of
using software applications to house real data similar to that which you have
used in your project. What responsibility do the creators and users of technology
bear in ensuring the truth is conveyed in the use and manipulation of data?
Discuss the balance between absolute truth and using data to reach a particular
goal. How does this relate to your conduct as a student and in a real-world
setting? Support your ideas from a biblical worldview and include at least 3
Bible verses. Outside sources are not required, but if they are used, you must cite
them correctly using current APA format.
b. Remember that this is a presentation and not a paper—bullet
points and short statements are preferred over longer paragraphs, but your
message must be clear. Source information and additional comments can be placed
in the Notes section of your slides.
3. Required Elements
a. In your presentation, you must include a table, pictures, SmartArt,
slide transitions for all slides, slide numbers, a title for each slide, and a
theme.
b.
There is no slide number
requirement—use as few or as many slides as you need to effectively complete
the project.
Submit Group Project – Part 2 by 11:59 p.m.
(ET) on Friday of Module/Week 8.
No comments:
Post a Comment