پروژه اکسل (81398))=/

شرح پروژه

#پروژه_جدید
#کدپروژه : 81398
موضوع : پروژه اکسل =/
سلام وقت بخیر
برای انجام پروژه اکسل پیام میدم
پروژه دانشگاهی هستش

Hide Assignment Information
Group Category
Access Project
Group Name
Group 12
Instructions
Access Group Assignment: Summer 2024 (20%)


COMP1115


The project must be completed as a group assignment.  Please check Brightspace for the group membership.

You are required to come up with a database that contains tables, queries, forms and reports.

Think back to your recent experience.  Examples include the purchase of a good or service, signing up for a course, signing out of a library book, applying for a job, etc.  Can you envision a database that would be involved in that process?  In other words, this assignment is not based on a “fictitious” company or situation.


First think of what information/tables would be needed for the business process.  Then think how they can be related.  You will “make up” your data.  Create a minimum of 10 records for each table.



build three or more related Tables to handle the business data
consider what common field (key) will connect the tables
create a relationship to join the tables together
use “one to many” and “many to many” relationship as we did in class
Ensure your database is using referential integrity.
create at least five Queries to combine information from your tables to answer your query.  All five should be significantly different from each other.
one Query should include a mathematical function using the Expression Builder
one Query should include a statistical function (e.g., sum, average, etc.)
create 3 Forms that displays data based on your tables
one of the forms should include a subform
create 3 Reports with an “image/picture” and some formatting based on your tables or queries.
Create a navigation form (or switchboard) and ensure that when the Access file is opened, the navigation form opens first.


Documents to be submitted


Access database through Brightspace.  Only one submission per group.


Soft copy of a word document, which include the following:

Brief description of the business and the database you have built (rationale for each table).  Describe the business situation that inspired you to do your assignment on. How would your database help with their business process?
Choice and explanation on primary/foreign key
A copy of “relationships report”
Your queries in plain language and the significance of your query (why the query and what did you find out from your query)


Work must be original and should be done by you!  Any suspected plagiarized work will not be accepted.  In fact, you will be reported to the office for academic misconduct.



Due dates:

Topic with a brief description (approx. half a page)                          July 30

Completed Access database (plus the Word doc)                           August

Due on Aug 13, 2024 11:59 PM
Available until Aug 13, 2024 11:59 PM. Access restricted after availability ends.

این فایل در رابطه با موضوع و اسم table هاست

این پروژه شامل 1 فایل مهم است، لطفا قبل از ارسال پیشنهاد حتما نسبت به بررسی این فایل اقدام فرمایید.

مهارت ها و تخصص های مورد نیاز

درباره کارفرما

کاربر386156

عضویت دو سال پیش

4974 پروژه ثبت شده ،

28 پروژه در حال انجام ،

65 پروژه آماده دریافت پیشنهاد ،

نرخ پذیرش پیشنهاد 24%