Assignment 6

By kanat

Download DatabaseExercise.zip and Microsoft-Office-2010.zip and follow this steps

Step 1

Create a table named “Locations”
Be in Design mode
Open Locations.xlsx using Excel
Look at column names in Excel and enter them as fields in Access
Choose appropriate data type.
Save

Step 2

Create a table named “Titles”
Be in View mode
Open Titles.xlsx using Excel.
Copy and paste everything into table.
Save

Step 3

Import From Employees.xlsx (Excel File) to a new table named Employee

Step 4

Define relationships of all tables.

Step 5

Answer the following questions (in comment) and send Microsoft Access file (.mdb) to me by email.
1. Find who live in Boston with less than 50000 salary
2. Find titles of those who live in Boston with less than 50000 salary

Deadline: 7 Apr 2017

11 thoughts on “Assignment 6”

  2. Answer
    1. Ann Manin, Patricia Rubin and Kenneth Charles live in Boston with less than 50000 salary
    2. Their titles are Account Rep.

  6. คนที่อาศัยอยู่ที่Boston และมีรายได้ต่ำกว่า 50,000 มี 3 คน ได้แก่
    1.Ann Manin มีรายได้ 49,500 ตำแหน่ง Account Rep
    2.Patricia Rubin มีรายได้ 45,500 ตำแหน่ง Account Rep
    3.Kenneth Chales มีรายได้ 40,000 ตำแหน่ง Account Rep

  7. • Find who live in Boston with less than 50000 salary
    1. Ann Manin
    2. Patricia Rubin
    3. Kenneth Charles
    • Find titles of those who live in Boston with less than 50000 salary
    The title of those three people who live in Boston with less than 50000 salary is Account Rep.

  9. • Find who live in Boston with less than 50000 salary
    LastName FirstName Location Salary
    Charles Kenneth Boston 40000
    Manin Ann Boston 49500
    Rubin Patricia Boston 45000

    • Find titles of those who live in Boston with less than 50000 salary
    LastName FirstName Location Salary Title
    Charles Kenneth Boston 40000 Account Rep
    Manin Ann Boston 49500 Account Rep
    Rubin Patricia Boston 45000 Account Rep

  10. 1. The person who live in Boston with less than 50000 salary
    1.Ann Manin
    2.Patricia Rubin
    3.Kenneth Charles
    2. The title of those who live in Boston with less than 50000 salary is Account Rep

  11. LastName FirstName Location TitleID Salary
    Manin Ann Boston Account Rep 49,500.00
    Rubin Patricia Boston Account Rep 45,000.00
    Charles Kenneth Boston Account Rep 40,000.00

Leave a Reply