Create a query with all fields from the student table

Assignment Help Computer Engineering

Reference no: EM133516327

Assignment: Create Tables & Queries in MS Access

Using an ERD to create tables in MS Access

Refer to the ERD that you created in the Week 8 assignment (attached). Create an ERD, and perform the following steps in MS Access:

A. Create the tables and relationships from the database design created in the Week 8 assignment.
B. Add at least five records into each table (Note: You must determine the field values).

Include the following screenshots in a Microsoft Word document to show the completion of the steps above:

A. Screenshot depicting the tables created within MS Access.
B. Screenshots depicting the records added into each table. Include one student where the student's last name is your name.

Query tables in MS Access

Perform the following steps in MS Access:

A. Create a query with all fields from the student table, where the student's last name is your name.
B. Create a query that includes students' first names, last names, and phone numbers.
C. Create a query that includes instructors' first names, last names, and courses they teach.

Reference no: EM133516327

Questions Cloud

Compare substantive law and procedural law : You may select a case not on the list with instructor approval. Finally, compare and contrast substantive (outcome) law and procedural (procedure) law.

What are the misconceptions americans have about immigration : What are some of the misconceptions Americans have about immigration and how it impacts cities? What evidence is given that immigration has a positive impact?

Discuss each work as a critic would using the vocabulary : Using a few concise paragraphs for each piece, discuss each work as a critic would and including using the proper vocabulary, what you think the work is about.

Challenge facing the disability health care sector : MBA621 Healthcare Systems, Kaplan Business School - recommendations on the biggest challenge facing the disability health care sector in Australia today

Create a query with all fields from the student table : Screenshot depicting the tables created within MS Access. Create a query with all fields from the student table, where the student's last name is your name.

Identify and discuss one thing about it project management : Identify and discuss the one thing about IT project management that excites you after completing this course.

Create a hierarchy of five of most important topics : CIS 555- Create a hierarchy of five of most important topics you believe a one-day course titled Performance Engineering: The Essentials Presented in One Day.

Provide a description that you would present to your manager : Provide a description that you would present to your managers to persuade them to see matters your way.

Identify a unique piece of information on the users computer : CSIS 352- Identify a unique piece of information on the user's computer such as a picture and include the system date and time in each screen capture.

User Account

All Pages