Our Services

Get 15% Discount on your First Order

Use Access to construct a database for a college bookstore

December 12, 2021

Use Access to construct a database for a college bookstore store based on the step-by-step instructions listed below.

Create a database and one table:

The name of the database will be Inventory_YourLastname.
Create a table named PRODUCTS based on data in Table 1.
Determine the appropriate data type for each field.
Assign an AutoNumber field to serve as the Primary Key. This should be the first field of the table and named PRODUCTID.
Populate the table with data from Table 1.

PRODUCT_NAMEDEPARTMENTQUANTITYPRICESUPPLIERAvocado DipF60.99Jay’sBall Point PenP1500.89BicChipsF770.65Lay’sClass RingC5098.95BalfourDictionaryB2212.95ColumbiaDoritosF1452.49Lay’sFelt-tip PenP760.98BicLogo T-ShirtC2509.99ChampionPencilP2000.15BicPepsiF4440.65PepsiSchool JacketC10034.95ChampionSchool TieC1517.50Field’sThesaurusB 1218.00ColumbiaThree-Hole PaperA2001.98MeadThree-Ring BinderA1223.50Mead

Add a new table to the Inventory database:

You now want to include the supplier information in the INVENTORY database. Use the information below:

Create a table named SUPPLIERS based on Table 2.
Determine the appropriate data type for each field.
Assign the SUPPLIER field as SUPPLIERS table Primary Key.
Use the Telephone number input mask to format the telephone number.
Populate the table with data from Table 2.

SUPPLIERCONTACTSTREET ADDRESSCITYSTATEZIP CODEPHONE NUMBERBalfourCoffinWall Street PlazaNew YorkNY100052122690800BicZeienPrudential TowerBostonMA22199ChampionOwen3141 MonroeRochesterNY146037163853200ColumbiaQuigleyColumbia College

New York

NY100270Field’s11 N StateChicagoIL606030Jay’s1504 W 44thChicagoIL606530Lay’sBeeby7701 Legacy DrPlanoTX750242146244700MeadRobertsCourthouse PlazaDaytonOH454635134956323PepsiCallowayAnderson Hill RoadPurchaseNY105779142532000

Relating the two tables:

You will need to establish a link between the PRODUCTS and SUPPLIERS tables.

Determine the common attribute between the PRODUCTS and SUPPLIERS tables.
Use the common field and create a relationship.

Perform Sort, Filter and:

Open the SUPPLIERS table and sort the records based on CITY. Save as CitySort.
Open the PRODUCTS table and create a filter of your own choice.
Use the ‘Aggregate’ function to calculate the average price in the PRODUCTS table.

Close and Submit:

Close your database.
Submit your database to the assignment submission folder that follows this page.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

COH 606 NU Low Carb Program for Diabetes Management Presentation Nursing Assignment Help

Article Presentation and Discussion Find a peer-reviewed article that uses epidemiological methods to examine a health-related issue, and present it to the class. Make sure to cover the following points: Background: what is the existing problem and why is it an important issue to study? What were the objectives of

BEFORE ANSWERING THE DISCUSSION QUESTIONS PLEASE READ ENTIRED CASE STUDI.

BEFORE ANSWERING THE DISCUSSION QUESTIONS PLEASE READ ENTIRED CASE STUDI. I HAVE ATTACHED IT TO THIS POST. REFERENCES HAS TO BE IN APA STYLE AND NO OLDER THAN 5 YEARS AGO. DOMAIN: HISTORY1a) Identify two (2) additional questions that were not asked in the case studi and should have been?

2 pages Locate a primary source, which is relevant to

2 pages Locate a primary source, which is relevant to our course, that interests you. Explain the primary source to the best of your ability. Connect your primary source to this class’s content in at least one way. All available information on this source, such as all bibliographic information

Theory of the time

Read the four suggest readings McTaggart, “Time” Prior, “The Notion of the Present” Smart, “The Space-Time World” Lewis, “The Paradoxes of Time Travel” then Describe the A-theory and B-theory of time, briefly stating some prima facie considerations in favor of each theory. Chose A-theory and defend the view you chose

The article reviews should contain a minimum of 500 words,

The article reviews should contain a minimum of 500 words, excluding cover page/references section, and should follow the most current edition of APA formatting. The article is selected by the instructor and is worth 25 points. Please submit Article Review 2 to this Dropbox. Assignment instructions: Step 1: View the

Chapter 5 – Physician Recruitment Chapter 6 – Physician Compensation This is the book Mayer, G. G., & Barnett, A. E. (1992). Ambulatory Care Management an

Chapter 5 – Physician Recruitment Chapter 6 – Physician Compensation This is the book Mayer, G. G., & Barnett, A. E. (1992). Ambulatory Care Management and Practice. Gaithersburg, MD: Aspen. Dialogue #1: (5 Points) Your father is going to visit your grandmother at the nursing home. He realizes her medicine dosage

1) *********Minimum 3 full pages You must submit 3 documents (each one 1 pages) and attach the scholarly article Minimum 1 page per document- not words Cover or reference page not included You must a Nursing Assignment Help

1) *********Minimum 3 full pages You must submit 3 documents (each one 1 pages) and attach the scholarly article Minimum 1 page per document- not words Cover or reference page not included You must attach the article in PDF 2)¨**********APA norms All paragraphs must be narrative and cited in the

Katelyn Chandler Posted Date May 6, 2022, 10:00 PM Unread

Katelyn Chandler Posted Date May 6, 2022, 10:00 PM Unread When implementing an evidence-based practice, one is hoping to improve an organization. In healthcare, evidence-based solutions aim at improving quality care and retaining staff. Additionally minimizing the cost of healthcare is important to consider when implementing new practices. Evaluating the

How do you see Artificial Intelligence (A.I.) affecting your chosen career or field of study in the next five years? Question: How do you see A.I.

How do you see Artificial Intelligence (A.I.) affecting your chosen career or field of study in the next five years? Question: How do you see A.I. affecting your chosen career or field of study in the next five to ten years?

Select an underserved or underrepresented group; it does not need

Select an underserved or underrepresented group; it does not need to be from the list above Create a DE&I initiative focusing on your chosen group for either your current organization or one you are familiar with. If needed, you can find some examples in Creating a Diversity, Equity, and Inclusion

For this milestone, due in Module Three, you will submit

For this milestone, due in Module Three, you will submit a draft of the literature review due as part of your final research investigation using the three articles that were provided for your track and topic in Module Two. In addition, for this milestone, you will need to find two

The objective of this assignment is to enable you to demonstrate your understanding of problems and opportunities related to court security. Providing for

The objective of this assignment is to enable you to demonstrate your understanding of problems and opportunities related to court security. Providing for appropriate security is a challenge faced by court administrators in an age of heightened concern about possible terrorism or other forms of violent outbreaks associated with court processes.

Look at all the civilizations or time periods that we have studied. Which one do you think you would most fit into and why. Please be specific with

Look at all the civilizations or time periods that we have studied. Which one do you think you would most fit into and why. Please be specific with your answers and compare them with your class mates. i chose ROMAN EMPIRE

DISCUSSION 1 In order to attract people to apply for

DISCUSSION 1 In order to attract people to apply for and accept positions, an organization must emphasize the positive aspects of a job. When employees discover their new job also has negative elements, they sometimes regret their choice and leave soon after they are hired. Respond to the following in

It’s spring and you’d like to engage your group of

It’s spring and you’d like to engage your group of three- and four-year-olds in a series of learning activities based on a common theme related to the time of year. You want to make sure the activities will reinforce the basic concepts of math and science, especially the development

Review the Learning Resources for this week and other resources

Review the Learning Resources for this week and other resources you have found in the Library or online, then respond to the following bullet points in a 2- to 3-page: What is the goal of a descriptive statistic? Provide an example of a descriptive statistic HR may use (besides turnover).

Evaluate the advantages and disadvantages of diagnosing and classifying psychological

Evaluate the advantages and disadvantages of diagnosing and classifying psychological disorders. Include in your evaluation responses to the following prompts: Evaluate the advantages of diagnosis and classification in mental health settings. Be specific and provide examples where appropriate. Evaluate the disadvantages of diagnosis and classification in mental health settings.

Sage 50 software has helped experts and companies in many

Sage 50 software has helped experts and companies in many ways. It’s a high-end accounting program with a precise and speedy approach that keeps clients’ files hidden from prying eyes. Sometimes, the Sage 50 software detects an error which is called “Sage 50 Error Connecting to Database.” This can