Make a select query with a calculated field for age

Assignment Help Database Management System

Reference no: EM13774483

Queries:

Make a select query with a calculated field for age, to list only guests between 20 and 40 years of age! Make sure to enter a range of ages in your table so you have something to display.

Make a Parameter query that allows the user to choose which birth month to display. So when the user is prompted for a birth month, they might type in 3, for March, and only the records which have a Date of Birth in March, will display.

Make an Update Query that will add the phrase "Free Champagne for this Preferred Guest" to the Comments field, but only if the guest stays for 8 days or more.

Reference no: EM13774483

Questions Cloud

Analyze a subject from any area of your academic life : In the major writing project, you will be writing to analyze a subject from any area of your academic, professional, civic, or personal life.

What should your investment be worth in one year : You have $12,500 to invest and you are considering investing in Fund X. The fund charges a fron-end load of 3% and an annual expense fee of 2.25% of the ending asset value over the year. You believe the funds gross rate of return will be 8% per year...

Physical and social risk factors in heat-related illnesses : Briefly discuss the challenges involved. Does better integrated community planning have an effect on mortality rates? Why, or why not?

Wasteful and ineffective : Republicans asserted that many of president obama's fiscal stimulus spending was " wasteful and ineffective." Does the content of fiscal stimulus spending matter?

Make a select query with a calculated field for age : Make a select query with a calculated field for age, to list only guests between 20 and 40 years of age! Make sure to enter a range of ages in your table so you have something to display.

Describe the legal concepts : For each fact pattern, specify the essential legal issue(s) involved, describe the legal concepts from the text, decide which side should win, and explain your reasoning and how you used the legal concepts to arrive at your decision

Designs must be sold in order to maximize the profit : If $80 is charged for a design fee, and the monthly studio rent is 1,600; write an equation for the profit, P, in terms of x. Then how much is the profit when 50 award designs are sold in a month? How many award designs must be sold in order to maxim..

Improve efficiency and customer service : Write a 700- to 1,050-word proposal, using the Five Step Planning Process, that describes how you might improve efficiency and customer service in your department by focusing on teamwork.

Determine the depreciation rate per mile : A trucking company computes depreciation on its vehicles by a mileage basis. Suppose a delivery truck has a cost of $20,000, a salvage value of $2,000, and an estimated useful life of 200,000 miles. Determine the depreciation rate per mile.

User Account

All Pages