Overview In this project, you will be able to apply what you learned in this module to something familiar, by creating a database of your own. Objectives Create, open and close a database,Create and u

Overview

In this project, you will be able to apply what you learned in this module to something familiar, by creating a database of your own.

Objectives

1. Create, open and close a database,
2. Create and use tables, queries, forms and reports
3. Design a database to satisfy a collection of requirements
4. Create queries using text and numeric data in criteria
5. Sort data and join tables in queries
6. Add, change, delete, search and filter records

Instructions

The database you use in this Project will be the same database you will use for your Discussion for this Module. Read instructions for both assignments before starting.

You will be using this database for Projects in future modules. Keep that in mind as you develop, as you will be continually adding to this database.

Identify a database that could be useful to you personally or professionally. You may start out relatively simple, but keep in mind that your database will become more complex the semester progresses.

Along with the database, create a doc, rtf, or PDF file with information about who the intended user of the capstone is and what the purpose of the capstone is. Please check spelling and grammar and use complete sentences. This file should be put into the D2L folder alongside the capstone.

• Explain the purpose of your database and who will be using it.
• Create the design of your database, including names of tables, primary keys, and types of relationships.
• Create the database in Access based on your design
  • Tables with all fields according to your database design, and at least 5 records.
  • Form – your choice for the purpose of the form
  • Query – What do you want to know from your database information?
  • Describe the purpose of the Form and the Query you created
• Save and Name your database and include your LAST NAME in the file name.

Upload your database and the planning document you created to the folder. Save a copy to use in the next module. Use the feedback received after this is graded to make changes so that it will be ready to go for the next Module.