DA 233 Database Tools Data Queries and MS Access Project

DA 233 Database Tools Data Queries and MS Access Project

[ad_1]

reading and come up with questions and answersSeptember 1, 2021wk9 salelizSeptember 1, 2021

Description

ManyBooks.com was developed by JK Rowling as an open marketplace for books online, a one-stop e-commerce search engine where you can search through more than 100 million new, used, rare, and out-of-print books for sale.
Ms. Rowling understands that you have expertise in databases. She needs help developing some custom queries for her sales and marketing team members. She has provided you with a sample data file, DA233_S1X-II.accdb. Specifically, what Jane needs is:

Create a table showing the telephone number of each author. Streamline your database so you don’t have too much redundancy. Be sure to include the input mask for the telephone number. Make sure the formats are correct. You may make up your own telephone numbers. Save the table, giving it and the fields appropriate names. Hint: The input mask can be set if you choose the text data type for telephone number. (2 pts)
Create relationships for the tables and enforce referential integrity. You should be able to generate the necessary relationships for all tables. Hint: To create relationships, click database tools at on the ribbon and you’ll see relationships. Drag the tables you want into the design canvas and build the relationships accordingly. You should be able to tell where the relationships are based on the fields. (2 pts)
A query of all authors who have written a book that costs more than $10 and is a novel. The query needs to have the author’s First Name, Last Name, Title of Book, Price, Category, and Rep displayed. Save the query as AuthorsQuery. (2 pts)
A query that calculates a 15 percent increase in the purchase price of each book. Sort the query on the new calculated field. Save the query as BookPricesQuery. (3 pts)
A query that updates the price of each book by subtracting 50 cents. Save the query as Less50CentsQuery. (3 pts)

 

The post DA 233 Database Tools Data Queries and MS Access Project appeared first on homework crew tutor.

“Is this question part of your assignment? We Can Help!”

"96% of our customers have reported a 90% and above score. You might want to place an order with us."

Essay Writing Service
Affordable prices

You might be focused on looking for a cheap essay writing service instead of searching for the perfect combination of quality and affordable rates. You need to be aware that a cheap essay does not mean a good essay, as qualified authors estimate their knowledge realistically. At the same time, it is all about balance. We are proud to offer rates among the best on the market and believe every student must have access to effective writing assistance for a cost that he or she finds affordable.

Caring support 24/7

If you need a cheap paper writing service, note that we combine affordable rates with excellent customer support. Our experienced support managers professionally resolve issues that might appear during your collaboration with our service. Apply to them with questions about orders, rates, payments, and more. Contact our managers via our website or email.

Non-plagiarized papers

“Please, write my paper, making it 100% unique.” We understand how vital it is for students to be sure their paper is original and written from scratch. To us, the reputation of a reliable service that offers non-plagiarized texts is vital. We stop collaborating with authors who get caught in plagiarism to avoid confusion. Besides, our customers’ satisfaction rate says it all.

© 2022 Homeworkcrew.com provides writing and research services for limited use only. All the materials from our website should be used with proper references and in accordance with Terms & Conditions.

Scroll to Top