Create an action query that makes a table called westcoast

Assignment Help Database Management System
Reference no: EM13764313

This week you will demonstrate your knowledge of action queries by using all four action queries to accomplish the tasks outlined.

For this exercise, you can use the same database form last week or download a fresh copy, download the Customer database file. The customer database contains 52 records of names and addresses. Before you begin the assignment, you might want to make a copy of the table first, in case you make a mess of things or want to test it out over and over again.

Use the customer table to create the action queries below. Save each one when you are satisfied that it works as it should. There will be 4 queries in Total. Each with its own icon showing what kind of action will take place when the query is run.

Create an action query that makes a table called WestCoast, with the following records. CA, WA, OR Create an action query to add the NV records to the newly created WestCoast table.

Create an action query that would delete the records from the Customer table, that were transferred to the WestCoast table i.e. CA, WA, OR and NV records. (we don't need them anymore in the Customer table)

Add a new field to the table called TAX. Set the data type to number and in the property fields pane, in the second half of the screen, change the format Long Integer to Single or Double (to allow decimals and not just integers. In Access 2013, this might be slightly different).

Create your final action query to "fill-in" the TAX with .085 for all the San Francisco CA customers.

Change the name of the customer database to your name before uploading and submitting for grading

Submit your work by uploading the database with the 4 saved action queries using the Assignment tool.

Be sure to use the discussion board if you need clarification on any topic.

The database you submit will contain 4 Action Queries. If you are using the same database as last week, delete all past select queries.

Reference no: EM13764313

Construct a query that will show the number of days

Construct a query that will show the number of days that exist between the first invoice and last invoice, for each month, for each employee, using the DATEDIFF function. Be

How to design and create tables

Databases are powerful tools for storing, managing, manipulating, and accessing data. Most information systems in use today make use of some form of database. In this less

Create a relational model from your er model

Create a relational model from your ER model. All keys should be clearly identified. Demonstrate that your database is in at least 3rd Normal Form. Write the DDL to create t

Determine the relationship between those areas

For this question, need data mining analysis (using k-means clustering algorithm) shows the relationship between poverty area and violent crime rate (homicide) depending on

Create an erd that represents the entities - attributes

Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by th

Create class named incident that consists of public property

Create a class named Incident that consists of one public property for each column in the Incidents table and a method named CustomerIncidentDisplay that formats an incident

Create a database for flying high travel services

When a FHTS customer wishes to book business flights with accommodation, it is always done by the respective employees of that Australian company, who book online. This mode

Show the records of depositor tables

Create 2 tables customer with fields customer_id, customer_name, customer_street, customer_city and depositor customer_id, account_number, balance Set relation between the two

Reviews

Write a Review

 
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