Question: This is an assignment for my module in data base systems and not quite sure on what to do Create/save the following 6 queries in

This is an assignment for my module in data base systems and not quite sure on what to do

Create/save the following 6 queries in the Access database UNIVERSITY_ASSIGNMENT:

Q1. Produce a list of students studying law.

Q2. Produce a list of students who are counselled by Joe Bloggs.

Q3. Find the subjects taken by Cahill Patricia.

Q4. Create a parameter which will allow you to find the subjects taken by any particular student.

Q5. Create a parameter query which will allow you to produce a list of students studying any course.

Q6. Create a form for adding new student records.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Part 2: Provider Database (MS Access) Use the project description HERE to complete this activity. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then...

Q:

Create a provider database and related reports and queries to capture contact information for potential PC component providers that might be used to purchase the equipment your specified in your MS...

Q:

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Q:

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Q:

BA630 - Systems Analysis & Design Exercise (Team Project) Maximum Word Count: 4000 words The purpose of this project is to pull several ideas together that we have covered throughout the semester and...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

Q:

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

Q:

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

The pH after the addition of 25 mL of 0.05 M NAOH to 20 ml of 0.05 M Malic acid equals (for Malic acid, Ka, = 3.84x10 Ka, 8.0sc10 Answer:

Q:

Gaudy Gift Gallery Corporation (owned 100 percent by Barbara) operates a gift shop. Barbara employs her daughter, Jenny, after school and on weekends. Other employees with similar responsibilities...

Q:

4 points Item 1 Which of the following statements is true? Multiple Choice A flexible budget is a comparison of actual revenues and costs at the actual level of activity to the actual revenues and...

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...