View the step-by-step solution to:

Question

Programming Assignment 7 Instructions

Matthew 6:21

"For Where your treasure is, there your heart will

be also."

This week you have been asked to create SQL Server Database to keep track of donations from members of the church. You are tasked with creating the database, the form, and a query. Please see the requirements below.

1.      Project

a.     You must save your project using your initials in the name

**This is required and the project will not be accepted otherwise.

 

2.      Create a SQL Server Database

a.      Create a Service-based Database in the project called yourinitialsDonations.mdf with the following fields and their settings to the database.

b.      Primary Key should be ID, Set the Identity Specification (Is Identity) = True

Name

Type

Null?


c.      The following data is required for your database. Please remember you do not need to enter the ID as it will be entered for you. **You must enter four entries of your own with your name, your instructors name, and two names of your choice. The amounts and dates can be of your choice for your entries. Your assignment will not be accepted without this.


3.      Create a dataset


 

 

4.      Create a Data form like the one below using the Donations.mdf database file.

a.      Update the backcolor to the color of your choice.

b.      Use appropriate naming conventions for controls.

c.      Lock the controls on the form.


5.      Create a Try Catch for the Save Item Click and create a message box for the Changes saved and the Exception if not saved.

6.      Create a SQL Query (SELECT which returns rows) using the query builder to display all donations greater than or equal to $100.

 

This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 7.




Screenshot (112).pngScreenshot (111).png

Screenshot (111).png

AutoSave . Off)
CSIS 208 Assignment 7 Instructions.docx - Protected View - Saved to this PC
A [email protected]
X
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
Acrobat
Search
Share
Comments
PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
Enable Editing
X
2. Create a SQL Server Database
Create a Service-based Database in the project called yourinitialsDonations.mdf with the
following fields and their settings to the database.
b. Primary Key should be ID, Set the Identity Specification (Is Identity) = True
Name
Type
Null?
ID
int
Not Null
FirstName
Varchar(50)
Not Nul
LastName
Varchar(50)
Not Nul
Amount
Money
Not Null
DonationDate
Date
Not Null
c. The following data is required for your database. Please remember you do not need to
enter the ID as it will be entered for you. **You must enter four entries of your own with
your name, your instructors name, and two names of your choice. The amounts and dates
can be of your choice for your entries. Your assignment will not be accepted without this.
ID
FirstName
LastName
Amount
DonationDate
Christopher
Woods
15.0000
10/15/2018
IN
Brayden
Bost
35.0000
1/20/2017
Mary
Freyer
75.0000
1/25/2018
Emma
Elliott
300.0000
2/20/2018
Stewart
Trunball
100.0000
3/4/2018
Nathanael
Smith
65.0000
12/2/2017
3. Create a dataset
Page 1 of 2 312 words
Focus
- -
- + 100%
edmw xu
1:29 PM
O Type here to search
10/2/2019

Screenshot (112).png

AutoSave . Off)
CSIS 208 Assignment 7 Instructions.docx - Protected View - Saved to this PC
A [email protected]
X
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
Acrobat
Search
Share
Comments
PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
Enable Editing
X
Create a Data form like the one below using the Donations.mdf database file.
a. Update the backcolor to the color of your choice
b. Use appropriate naming conventions for controls.
c. Lock the controls on the form.
Assignment?
114 41 of 6 ) +XL
ID:
First Name:
Christopher
Last Name:
Woods
Amount:
15.00
Donation Date: Monday . October 15. 2018
5. Create a Try Catch for the Save Item Click and create a message box for the Changes saved and the
Exception if not saved.
6. Create a SQL Query (SELECT which returns rows) using the query builder to display all donations
greater than or equal to $100.
This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 7.
Page 2 of 2 312 words
Focus
- -
- + 100%
O Type here to search
emw xu
1:29 PM
10/2/2019

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes