Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Describe on paper a database for your personal or small business use. Describe the purpose of the database and why it will be useful to

  1. Describe on paper a database for your personal or small business use. Describe the purpose of the database and why it will be useful to you.
  2. What will you name the database?
  3. What are some examples of fields you will need?Have a least 1 text, 1 numeric, 1 currency, and 1 date.
  4. What tables will you need? Name at least 3 because you want to show relationships.
  5. What primary key will you use?
  6. How will you show relationships across your tables?
  7. Give 3 queries you might use and explain the purpose of each.
  8. What would you use a form for?
  9. Describe a report you would need from the database.
  10. solve these as if it was on Microsoft access but don't use access

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Exploring The Hospitality Industry

Authors: John R Walker

4th Edition

0134744934, 9780134744933

More Books

Students also viewed these General Management questions

Question

Speak clearly and distinctly with moderate energy

Answered: 1 week ago

Question

Get married, do not wait for me

Answered: 1 week ago

Question

Do not pay him, wait until I come

Answered: 1 week ago