Constructing tables with microsoft access

Assignment Help Basic Computer Science
Reference no: EM131963251

Constructing Tables with Microsoft Access Construct an Access database with two tables using the graphical capabilities of the product (vs. SQL). One table is called STUDENTS and has fields for Student_ID, Last_Name, First_Name, Major, DOB (i.e., date of birth), Zip_Code, and GPA. The other table is called ZIP_CODES and has fields of Zip_Code, City, and State. Use appropriate Access data types for all fields. Ensure both tables have primary keys and there is a foreign key in the STUDENTS table referencing the Zip_Code field in the ZIP_CODES table. Populate each table with two records, ensuring that each student has a zip code that matches a value in the ZIP_CODES table. Develop a query that shows the Student IDs of both students along with their last names, first names, date of birth, GPAs, zip codes, cities, and states.

Submit the following screen snapshots, in this order and appropriately labeled, in a single Word file:

  1. Relationships View showing both related tables
  2. Table Design Views of both tables
  3. Datasheet Views of both tables showing the two records
  4. Query Design View of your query
  5. SQL View of your query
  6. Datasheet View of the query results

Reference no: EM131963251

Questions Cloud

Computerized operating systems : Computerized Operating Systems (OS) are almost everywhere. We encounter them when we use out laptop or desktop computer.
Cloud-based file synchronization : How is backup data files different from a cloud-based file synchronization?
What is current bond price : If the YTM on these bonds is 10.2 percent, what is the current bond price?
What are the most critical issues facing healthcare system : What are the most critical issues facing the healthcare system in the United States today? Find at the websites of these major health organizations.
Constructing tables with microsoft access : Construct an Access database with two tables using the graphical capabilities of the product (vs. SQL).
Implement the binarysearchtree class : Please assist me on this assignment. Implement the BinarySearchTree class. The BinarySearchTree class extends the BinaryTree class which implements
Discuss the sociological research design method : Imagine you are a sociological researcher studying academic dishonesty at your University. Identify at least one research question you would address.
Prepare a interview essay based on clinical reasoning cycle : Prepare a interview essay based on clinical reasoning cycle. The main essay topic is interview essay on topic healthy ageing based on clinical reasoning cycle.
Test a field for membership in a set of values or fields : After the field name, use the 'in' operator followed by the set items surrounded by braces . Use the following filter tcp.port in {80 53 8080}.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Research on failover clustering for hyper

Do some research on failover clustering for Hyper-V. Create a table showing how clustering can help with both storage and network failure.

  Public encryption key case

SKEYID is supposed to be something that is not computable except by Alice and Bob. Why canât an eavesdropper or active attacker calculate SKEYID?

  Emerging markets and product lines

Pricing decisions often relate both to knowing your costs as well as to the strategy of pricing. Competition, loss leaders, and other elements may be discussed in the MD&A section.  Emerging markets and product lines are also an issue for some compan..

  Create a java gui application using netbeans that calculates

Create a Java GUI application using Netbeans that calculates a restaurant bill from the prices of the appetizers, main course and desert.

  Create a business budget sheet using microsoft excel

Create a business budget sheet using Microsoft Excel. In the budget sheet. Create a label called "Income" and add your monthly business income in the next cell: $25,000.

  Describe constraints on the number of each product produced

Write the inequalities that describe the constraints on the number of each product produced next week. Begin by identifying what x and y represent.

  Identify multiple matching words in the user’s input

Identify multiple matching words in the user's input, and respond with a more appropriate answer in that case.

  Draw a possible class diagram,uml diagram for the system

Ship A has two instruments, which provide digital information for navigation: (1) A global positioning system (GPS) measures the position and velocity of Ship A.

  Bond duration, interest rate risk

Consider a non-callable bond with 5 years to maturity and an annual coupon of 4%. The bond yields 3% and you may assume that the yield will remain constant.

  Write a function called tallenough

(function, two-way if statement) Write a function called tallEnough() that takes a single parameter, the user's height in inches. If the height is 48 or more, the function should return "You can go on this ride." Otherwise it should return the str..

  Give an example of the use of sets

1) Give an example of the use of sets. Illustrate the operations of union and intersection using these sets.

  Write a combined state transition and output table

Choose state encodings and write a combined state transition and output table using your encodings. Write the next state and output equations and sketch your FSM schematic.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd