MICROSOFT ACCESS QUESTIONS (FILL THE BLANKS) Q1. You are given a table Table1 wi

Question

MICROSOFT ACCESS QUESTIONS (FILL THE BLANKS)

Q1. You are given a table Table1 with fields ID (primary key, AutoNumber) and x of type Short Text and a table Table2 with fields ID (primary key, AutoNumber) and y of type Number. You write a query which produces this output:

What can you say about the relationship between the two tables? Complete the following statement:

There is a relationship from field...............in table................... to field  in table............... . Hint: The relationship is between a field of type AutoNumber and a field of type Number.

Table1 contains 3 rows with keys 1,2,3. What can you say about the contents of those rows? Compete the following statements:

What is in field x in row 1................ , row 2................ , row 3................. ?

What is the minimum number..................... of rows that table Table2 must contain?

Fill in the missing information (8 blanks)

Q2.

Peer Feedback with Access: You see the query written by your partner for computing the sum of all orders per customer. You spot an error in the query implementation but the query gives the correct result for the current data base.

The data base contains two tables: Customers and Orders. The Customers table contains:

ID is of type AutoNumber and Customer of type ShortText.

The Orders table contains:

$8.00

ID is of type AutoNumber and CustomerID is of type Number.

There is a relationship from ID in Customers to CustomerID in Orders which is used to compute the (inner) join between Customers and Orders.

The query is an aggregation query which is supposed to sum for each customer the totals across all orders. Unfortunately, your partner made a mistake and used Avg instead of Sum.

The reason why the query gives the correct result is that the average is only for a sequence of one positive number. Would the average be for a sequence of two positive numbers we would get the wrong result.

You provide a minimal change to the Orders table, rerun the query and now it gives the wrong result convincing your partner to rethink his query implementation. The minimal change is to change the first row of table Orders: change field...................... to....................... Hint: change the first row so that Elizabeth has placed two orders.

Explanation / Answer

Question 1 : Answers in bold

There is a relationship from field........ID.......in table......Table1............. to field ....y..... in table.....Table2.......... . Hint: The relationship is between a field of type AutoNumber and a field of type Number.

Table1 contains 3 rows with keys 1,2,3. What can you say about the contents of those rows? Compete the following statements:

What is in field x in row 1....."hello"........... , row 2....."how"........... , row 3....."are"............ ?

What is the minimum number.......3.............. of rows that table Table2 must contain?

Explaination: The query joined the 2 table on Table1.ID=Table2.y so the output is generated as shown in the question. Since there 3 rows from Table1 that matched with rows in Table2, there should be minimum 3 rows in Table2 as well.

Question 2:

The minimal change is to change the first row of table Orders: change field......CustomerID................ to.........2..............

Explaination: when CustomerId in Orders table is changed to 2 in row 1, the Orders table will now have orders from single customer Elizabeth(ID=2), Now for elizabeth, manual calculation leads to the sum of orders =15 whereas average would be 7.5. So cross checking the results with query , we can make out that gives wrong output.

Please do rate the answer if it helped. Thanks

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.