Mis – two access assignment project

What is a database?

database is a collection of data that is stored in a computer system. Databases allow their users to enteraccess, and analyze their data quickly and easy. They’re such a useful tool that you see them all the time. Ever waited while a doctor’s receptionist entered your personal information into a computer, or watched a store employee use a computer to see whether an item was in stock? Then you’ve seen a database in action.

The easiest way to understand a database is to think of it as a collection of lists. Think about one of the databases we mentioned above– the database of patient information at a doctor’s office. What lists are contained in a database like that? Well, to start with, there’s a list of the customer names. Then, there’s a list of past appointments, a list with medical history for each patient, a list of contact information… and so on, and so on.

In this lesson you will learn about databases and learn how to use a program…Microsoft Access to create and maintain your own database.

 

There is a basic sequence of steps with Access that you need to follow in order to successfully create a database.    If you try to perform these steps out of sequence, you may encounter enough difficulties to jeopardize your overall success.   

 

The steps are:

  •  Create your database.   You only have to do this once, after that, you can open your existing database and make the necessary changes to it.  
  • Create each table in the database.    First you create the table, and then you create the fields (columns) that to in the table.    You have to repeat this step for each table in your database.   As you add each field, you must define any special field attributes, such as numeric, alpha-numeric, primary keys, field edits, table relationships, etc.
  •  Load the data into your table.   There are a variety of ways to do this.   You can key it into the table, you can import it in from an Excel spreadsheet, or use a specially designed form that you designed to enter the data. 
  • Create your queries.  These queries will help you select specific records (rows) in your table, as well as update the data in your tables.  
  •  Create your forms.  Forms will provide a structured method to enter and maintain data in your database.  
  • Create your reports.   Reports allow you to select, sort, print, and perform calculations on your data so you can display a report.   Users can look at your reports online or in a hard copy format.

You will create a database in two different assignments.  Complete the first half in assignment one where you will create tables to define the data and add data.

In the second assignment, you will ask questions of the data through queries.

There are numerous tutorials and demonstrations to assist you in this process. Do not procrastinate and wait until the last minute to do this.  Good luck! 

 

SOME HELPFUL VIDEOS:

This is just to help you with the assignments







Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10