User Account

All Pages

Create an ms access database called memberledger.mdb

Assignment Help Database Management System
Reference no: EM13947807

Create an MS Access database called MemberLedger.mdb. Add a table called Members with the following columns. (Already done, see attachment).

For clarification, the instructions for the assignment require the creation of the MemberLedger.mdb database. The database should be created and saved as an Access 2007 database with the .accdb extension. The AccessDataSource server control does not recognize the .accdb extension so a SqlDataSource server control must be used to connect to the database. The database must be placed in the App_Data folder in order to create a relative path to the database. A relative path should be used because a relative path will work on any computer. A relative path to the database uses the |DataDirectory| token which is used in the value assigned to the Data Source key in the ConnectionString. The relative path is easily created by selecting the name of the database in the dropdownlist when selecting "Which data connection should your application use to connect to the database?" in the data source configuration wizard.

MemberID - This is the Primary Key with a data type of AutoNumber
FirstName - Data type of Text
LastName - Data type of Text

Add at least 5 rows to this table to facilitate testing of the application.

Create a Visual Studio 2008 ASP .NET Web Site with three Web Forms. The name of your Web site should be based on your last name. For example, if your last name is Jones, then assign the name Jones_IP3.

The first Web Form is a login page that contains a Login server control. Users cannot view the second Web Form unless they have successfully logged onto the application. Authentication and authorization should be implemented in the web.config file to provide this functionality. Three sets of credentials should be added to the web.config file. One set of credentials must use Student as the user name and ITP450-IP3 as the password.

The second Web Form allows the user to view and edit the data in the database. Place a GridView server control on the Web Form and connect it to the database. Configure the GridView server control to allow the user to view the records in the database and to edit a member's data.

The third Web Form allows the user to page through the records in the database and add a record to the database. Place a FormView server control on the Web Form and connect it to the database. Configure the FormView server control to allow the user to page through the records in the database and to add a new record to the database.

Zip the Web Site folder that contains the files

Attachment:- MemberLedger.zip

Reference no: EM13947807

Questions Cloud

How long it take to send the file from source to destination : Suppose the network is a packet-switched datagram network, and a connectionless service is used. Now suppose each packet has 2h bits of header. How long does it take to send the packet?
Estimate the soil friction angle : The ground- water table was located at a depth of 2 m below the ground surface. Given, for the sand: gd  5 14.5 kN/m3  and gsat  5 19.8 kN/m3. The contact stress during the test was 260 kN/m2. Estimate the soil friction angle, f9.
How does water change to steam : As you have learned throughout the course, engaging young students in hands-on science experiments will enhance their knowledge in a fun and interesting way. These simple experiments will prepare them for more complex science experiences in the fut..
Graph that illustrates a recent change in law : Write a 5-paragraph essay that introduces the topic you've chosen, summarizes the various points of view, and concludes with the current status of the issue you are addressing. Be sure to use at least 2 citations to support your essay.
Create an ms access database called memberledger.mdb : Create an MS Access database called MemberLedger.mdb. Add a table called Members with the following columns. (Already done, see attachment).
Determine the variation of the relative density : 1. Refer to Problem 3.19. Using Eq. (3.51), determine the variation of the relative density with depth. Use Qc 5 1.
Prepare a schedule of after-tax cash flows for manual system : Prepare a schedule of after-tax cash flows for the manual and robotic systems. Should the company invest in the robotic system?
Explain and reason how tcp congestion control will react : Explain and reason how TCP congestion control will react: for example, describe what transmission rate TCP would give each of the connections.
Estimate the average peak friction angle : Assuming the dry unit weight of sand to be 16 kN/m3, estimate the average peak friction angle, f 9, of the sand. Use Eq. (3.53).

Reviews

Write a Review

Database Management System Questions & Answers

  Create a function

Create a function that returns the day of the week for a specified date. Create a trigger that displays the message "Emp table updated" when an update to the employee table increases the employee's basic salary.

  Draw a diagram 0 dfd for the order system

Draw a decision tree that describes the merchandise inventory management process.

  Ithis hands-on assignment you will be expected to learn

in this hands-on assignment you will be expected to learn a. how to interactively query a database by using sql

  Create a fourth column labeled metcalfe value

Create a fourth column labeled Metcalfe Value that calculates the value of each social media outlet based on the number of users it has

  Justify a question on database management

When a student has not chosen a major at a university, the university often enters a value of "Undecided" for the major field. Is "Undecided" a way to represent the null value? Should it be used as a default value? Justify your answer carefully.

  Assignment- database administrator for department store

Assignment: Database Administrator for Department Store, The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maint..

  Design a clean and normalized database

Design a clean and normalized database that handles books for a library application. You need to consider the following rules before you design the database: All books are mapped to categories. For example, the book Distributed Operating System bel..

  Provide a sql script file to define the database schema

Provide a SQL script file to define the database schema, HappyCustomerDB. Your script should be organised so that whenever the script is loaded all the database objects will be dropped and re-created.

  Define relational database design

List the details of any works of art (including the Artist who created the work) that have more than one copy recorded in the database.

  You were hired as an analyst to develop a new information

you were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size

  Write sql statements to create the corresponding relations

Write SQL statements to create the corresponding relations to the ER diagram you designed for Exercise 2.8. If your translation cannot capture any constraints in the ER diagram, explain why.

  Explain the diference between hash indexes and b+- ree index

Explain the difference between Hash indexes and B+- ree indexes. In particular, discuss how equality and range searches work, using anexample.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd