Preview

Database for the Burchard Museum Of Science and Discovery: Relationships between Tables and Queries within Database

Satisfactory Essays
Open Document
Open Document
402 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Database for the Burchard Museum Of Science and Discovery: Relationships between Tables and Queries within Database
Museum Volunteers

Project Description:

In this project, you will create a new table and share data with Excel in a database for the Burchard Museum of Science and Discovery. Additionally, you will establish relationships between tables, and then create queries within the database.

Instructions:

For the purpose of grading of the project you are required to perform the following tasks:

Step
Instructions
Points Possible
1
Start Access. Open the downloaded Access database named Exploring_a02_Grader_IR.accdb.
0
2
Create a new table, save the table using the name StartDates and switch to Design view. Add the field name VolunteerID using the default data type (Text). Add the field name StartDate and change the data type to Date/Time.
14
3
In the new table, set the field name VolunteerID as the primary key.
3
4
View the StartDates table in Datasheet view. Add the following records to the table:

VolunteerID StartDate
1020 9/24/2007
1021 6/30/2008
1022 11/3/2008
1023 3/16/2009
1024 2/15/2010
1025 12/6/2010

Close the table.
6
5
Begin to import the downloaded Exploring_a02_Birthdays.xlsx workbook as a new table in the current database. Click Next two times.
8
6
Set the VolunteerID as the primary key, and then click Next.
3
7
Import the table with the name Birthdays, click Finish, and then click Close.
4
8
Begin establishing relationships in the database by adding the Department Managers and Volunteers tables to the Relationships space.
4
9
Create a one-to-many relationship between the Department field in the Department Managers table and the Department Field in the Volunteers table, being sure to enforce referential integrity. Close the Relationships window, saving the changes.
10
10
Begin to create a query using the Simple Query Wizard. From the Volunteers table, add the following three fields to the

You May Also Find These Documents Helpful

  • Satisfactory Essays

    For the purpose of grading the project you are required to perform the following tasks:…

    • 639 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    M1 Unit 4 Assignment

    • 438 Words
    • 2 Pages

    1. Update the employee table, add a salary column (Number type with 7 length) into the employee table. Use a number format with a 2 digit decimal from the right.…

    • 438 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Unit 18 M1 Research Paper

    • 268 Words
    • 2 Pages

    Link to target grade/ presentation of work/content/knowledge. Signature Date Launch Date 11/12/2014 Submission Date 22/01/2015…

    • 268 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    For the purpose of grading the project you are required to perform the following tasks:…

    • 496 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Taxation and Home Tab

    • 1215 Words
    • 5 Pages

    For the purpose of grading the project you are required to perform the following tasks:…

    • 1215 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Chid Abuse

    • 829 Words
    • 4 Pages

    For the purpose of grading the project you are required to perform the following tasks:…

    • 829 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    A1 Instructions

    • 522 Words
    • 3 Pages

    For the purpose of grading the project you are required to perform the following tasks:…

    • 522 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Results count of violation of a contract on the bases of 16A Violation, 16C Violation and No Obligation"…

    • 208 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    For the purpose of grading the project you are required to perform the following tasks:…

    • 788 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    cold pizza

    • 420 Words
    • 3 Pages

    For the purpose of grading the project you are required to perform the following tasks:…

    • 420 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    * A Team can have one or many club so that comes out to many to many relations that can be broken to one too many relations.…

    • 410 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Working with Database Design

    • 2266 Words
    • 10 Pages

    Various other aspects and needed requirements are to be introduced and implemented into Jim and Tim’s new ACCESS™2010® Relational Database Management Systems from concepts, theories, analysis, import/export, referential integrity, primary/foreign/ non keys, data-modeling, and normalization. Needs to assure value, structure, relationship, and integrity are implemented in the relational database management systems (RDBMS) for the explicit users ability to flawless query information/data which allows by logical authentication to request, add, modify, and view correct, understandable intellectual organizational RDBS while using the export and import functions of ACCESS™2010®, EXCEL 2010, and MS SQL SERVER. One issue with almost all software (any type) is because humans write the code for software and on the other hand other humans reverse engineer written software finding weakness, and design script or bot code, which will become a threat agent in a form of a Trojan-horse, viruses, Dos, DDoS, and other forms of illegal hacking to steal intellectual data. A suggestion is using a specific tool called CAPTCHA “(Completely Automated Public Turing Test to tell Computers and Humans apart),” also known as “Gausebeck-Levchin Test.” This is to create anti-fraud detection, which prevents a script or a bot from being able to complete authentication. Although, this tool used in Pay-Pal transactions, its use for on-line of other types of internet web transactions to assure a live human interaction. This tool implementation into the accounting section between customers to RoboBoys and even between Jim, Tim, and vendors, which helps prevent the…

    • 2266 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Oppel, A. J. (2009). Databases: A Beginner 's Guide. New York, NY: McGraw-Hill Professional. Retrieved from the Walden Library: http://site.ebrary.com/lib/waldenu/docDetail.action?docID=10286217…

    • 1007 Words
    • 4 Pages
    Good Essays
  • Good Essays

    slp 5

    • 420 Words
    • 2 Pages

    This is a web software project; the main logic part consists of PHP pages which are hosted on a Linux server. The web server must have PHP version 4.0 or above installed on it. The server should also support MySQL database as all the tables are developed in MySQL. The client part is a simple HTML page which contains some javascript as well.…

    • 420 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    R4Es

    • 1428 Words
    • 6 Pages

    Example 1: Create the employee with three data members: name, job, salary, and hire date, and a…

    • 1428 Words
    • 6 Pages
    Satisfactory Essays

Related Topics