Mis – two access assignment project

What is a database?
A database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, 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!


This is just to help you with the assignments

Related Posts

Quality Writing Features

Price Start $10
  • 24/7 Customer Support
  • All Subject Areas
  • Money-Back Guarantee
  • Timely Delivery
  • Originality report
  • Confidentiality guaranteed

Ordering Homework Writing Service

You can get our ideal online homework help services with four easy steps. All you have to do is inform us of your requirements. Immediately we will match with a specialist in your academic discipline. After that, we will track your order, review it to ensure it meets your requirements, and submit it to your email.


Submit Requirements

Fill in your assignment instructions on the order form


Writer match

Immediately you contact us for homework help; we will assign your assignment to an academic expert.


Quality review

We have a team of editors, who will thoroughly review your assignment, ensuring there are no errors before submission


Get Your Completed Paper

Once we have completed the assignment, we will deliver it to your account. Additionally, we will send a notification to your email.



Budget-friendly writing services



We don’t share our client’s information with a third party



We write every assignment from scratch

Amazing Homework Writing Features

Once you consult us for homework help online services, you will attest to why we are among the USA's best essay writing services.

Read on and find out some of the features that make our services superlative.

Free Homework Writing Services

Free plagiarism checker

You can confirm that the content you get is original for free using our plagiarism checker.

Free samples

We offer unlimited access to our essay homework samples.

Free title page and bibliography

Once you place an order, we format it accordingly without demanding additional charges.

Free unlimited revisions

We offer free unlimited revisions until your assignment is of your desired quality..

Free editing and proofreading

We have a team of specialized editors who review your assignment before submission.

Free customer support

You can track the progress of your homework for free.

Request for Homework Writing Service Today!

We have over 500 homework writing experts, ready and waiting to help you improve your writing skills