Reference no: EM131965608
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:
Relationships View showing both related tables
Table Design Views of both tables
Datasheet Views of both tables showing the two records
Query Design View of your query
SQL View of your query
Datasheet View of the query results
|
How is backup data files different
: Research 2 software-based backup utilities for Linux. describe and explain several important features.
|
|
Calculate the price-recovery component
: Calculate the cost of inputs in 2015, assuming no productivity change from 2014 to 2015. Calculate the price-recovery component.
|
|
Determine the net present value of project based on discount
: If the projects are not mutually exclusive, which project(s) would you accept if the discount rate is 9 percent?
|
|
What will the share price be when the market learns
: what will the share price be when the market learns of the new product - Equity holders will prefer projects that pay off slower even if these projects
|
|
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
|
|
In how many months would you have enough saved for roof
: You decide to replace the existing roof on your house for a cost of $25,000. You decide to save $1,200 per month in an account that pays 4 percent annual.
|
|
What is the market value of corporate bonds
: In order to get an estimate of cost of capital, KHC collect the following information. KHC has 310,000 shares of common stock outstanding, 15,000 shares.
|
|
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}.
|
|
How many balloons were in process at the end of january
: The production process to make balloons began January with 20,000 balloons in process. How many balloons were in process at the END of January?
|