Your perfect assignment is just a click away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

CIS 107 Georgia Military W8 Knowledge of Microsoft Access 2016 by Creating a Database

CIS 107 Georgia Military W8 Knowledge of Microsoft Access 2016 by Creating a Database

Nursing Experts

Description

Week 8 Capstone Project Information

Objective: Demonstrate your knowledge of Microsoft Access 2016 by creating a database from scratch. In creating this database, you will analyze and synthesize a combination of database concepts, terms, components, tools, and objects (forms, queries, and reports).

Database Information: Now that you have learned the basics of Microsoft Access and relational databases, you will create your own database from scratch. You may create a database of your books, coupons, comics, music, movies, videogames, household inventory items, etc. This assignment can be fun and useful at the same time!

The database you create is required to have the following objects:

(2) Tables that relate with a primary/foreign key relationship

In each table, create a minimum of 8 fields which use each of the data types in the following list (Short Text, Long Text, Number, Date/Time, Currency, Yes/No, Calculated, and Hyperlink)

In each table, create a minimum of 2 fields that are setup using Lookup Wizard

Create a minimum of 1 Lookup Wizard field that is multivalued

In each table, create a minimum of 3 validation rules

In each table, create a minimum of 20 records

(2) Forms

1 form needs to be created for a table and 1 form needs to be created for a query

(6) Queries

Queries must be different types (e.g., top-down query, parameter query, crosstab, etc.)

1 query needs to have joined tables (2 tables create the query)

2 queries need to have a calculated field

(4) Reports

At least 1 report needs to be created for a table and 1 report needs to be created for the query with joined tables

At least 2 reports need to have a column total

NOTE 1: If you would like to create additional tables with more detailed information, please do so. If you would like to create additional forms, queries, or reports, please do so. Do whatever you need to do in order to create the database but make sure you meet the minimum requirements!

NOTE 2: When creating your objects (forms, queries, and reports) from the supplied data from the imported spreadsheets, it is VERY important that you make the objects user-friendly and professional.

Written Information: When you finish creating the database and the objects, answer the following questions in a minimum of one paragraph (3-5 sentences) each.

Where did the information come from and why did you choose to create this database?

How is this database useful to you?

What types of queries did you use and what question/s did the queries help answer?

What types of reports did you generate and why? Why did you create the total for the report?

Do you think you could share this database with friends or family to help them?

This is an academic assignment, so no “text-talk,” no conversational tone, and ABOVE ALL OTHER THINGS… don’t plagiarize!! Lastly, spell-check and proofread your work! Failure to follow these steps will negatively impact your grade.

Upload your database to the Week 8 Capstone Project Database activity in Week 8 as a Microsoft Access 2016 (.accdb) database using the following naming protocol: LastnameFirstnameWK8Database

Upload your written information to the Week 8 Capstone Project Written Information activity in Week 8 as a Microsoft Word 2016 (.docx) document using the following naming protocol: LastnameFirstnameWK8Explanation

Discuss your plan for the Week 8 Capstone Project.

Tell the class about the type of database you plan on creating and why.

Discuss with the class any challenges you foresee or encountered while working on the project

seen

Nursing Experts

Nursing Experts

Our Service Charter

1. Professional & Expert Writers: Nursing Online Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Nursing Online Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Nursing Online Papers is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Nursing Online Papers, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.