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! 



This is just to help you with the assignments

Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

5 Star Essays strives for complete client satisfaction at all times. As a result, we never cut corners when it comes to the quality of our homework assistance.


Dissertation Help

At 5 Star Essays, Dissertations are some of the most complex papers that any student is required to write. They require understanding of the subject matter, analysis of existing information and interpretation to develop substantial arguments. Dissertation require significant expertise to ensure that the learner can attain the desired grades. Do these suggestions make you worry? 5staressays.org has all the answers you need. You do not have to struggle doing your dissertations. Hire our professional dissertational writers to get quality and original papers without plagiarism.


Admission Essay Help

Have you been eyeing spots in prestigious institutions? Worry no more. We are here to ensure that your admission papers are written in a professional manner that ensures you get the first chances to your preferred institutions. Through our experts in admission essays, 5staressays.org can develop papers that are professional and guarantee you entry into the institutions.


Research Paper Help

Research paper entail the use of qualitative and quantitative approaches to collect data, implementation of specific frameworks to interpret the data and use of analytical skills to address specific questions. This sounds difficult? 5staressays.org is there to ensure that you don’t strain in meeting these necessities of preparing your research. For answers to your research, get in touch with 5staressays.org.


Persuasive Essay Help

Do you have the right skills and expertise to argue a point persuasively? Writing persuasive essays requires the students to ensure that they argue points in a way that the reader buys into the ideas. This process requires special skills that are not common to all groups of learners. As such, 5staressays.org come in handy to bridge this gap and prepare the persuasive essay for you. The essays are quality, error free and original. Try us now for quality papers.


Application Essay help

Application essays should guarantee you a spot in your preferred institutions. They should be able to be able to provide the reader with an understanding of the writer. How do you begin writing an application essay? What are the contents of the essay? Worry no more this are elements that are covered by 5staressays.org professionals in application essay writers. Get your application essay done for you and you will not regret it.


Scholarship Essay Writing Help

Are you eyeing a scholarship but you are not sure you are in a position to write your essay? 5staressays.org will help you to achieve the desired sponsorship by preparing your scholarship essay at an affordable price. We prepare essays that have a good structure, are plagiarism free and quality. Try us now for quality scholarship essays.