I wrote a database a couple of weeks ago for an assignment, the assignment for this week is to take that Microsoft SQL Database, which I wrote in Microsoft SQL Server 2014 Managment Studio. I am supposed to password protect the database, I have tried a couple of different things I found online but nothing has worked, so I need help trying to figure out how to do this apparently. I also have to create a matrix to indicate the permissions (read, insert, delete, modify) I would grant to different users of my database. I have to create at least 2 different users, and implement their permissions unsing SQL statements. I also need assistance with a major project in doing the Index and the screen views (forms in access). I am willing to pay up to $30 depending on the level of help that you are willing to give me on it. The big issue is the person that I have a deadline of tomorrow by noon or earlier, the earlier the better.

Title: Securing and Administering a Microsoft SQL Database

Introduction:
In this assignment, the task at hand involves securing a Microsoft SQL database and implementing user permissions for different levels of access. Additionally, creating an index and screen views (forms) are required for a major project. This document will provide a step-by-step guide on password protecting the database, defining user permissions using SQL statements, and insights into creating indexes and screen views in Access.

Securing the Database:
To password protect a Microsoft SQL database, various methods can be employed based on the version being used. As the database was created in Microsoft SQL Server 2014 Management Studio, we will outline the process for securing the database in this specific version.

1. Open Microsoft SQL Server 2014 Management Studio.
2. Connect to the SQL Server instance where the database is stored.
3. Locate the database in the Object Explorer pane and right-click on it.
4. From the context menu, select “Properties.”
5. In the Database Properties dialog box, navigate to the “Options” page.
6. Under the “State” section, find the “Restrict Access” option.
7. Select the “Single User” or “Restricted User” option to limit access to the database to only one or a few specific users respectively.
8. Click “OK” to save the changes and implement the security settings.

Defining User Permissions:
To grant different levels of access to individual users, SQL statements can be utilized to define user permissions.

1. Open Microsoft SQL Server 2014 Management Studio.
2. Connect to the SQL Server instance where the database is stored.
3. Expand the “Security” folder in the Object Explorer pane.
4. Right-click the “Logins” folder and select “New Login.”
5. Enter the appropriate login name and password for the first user and select the desired authentication method (Windows or SQL Server).
6. Click “OK” to create the login.
7. Right-click the desired database and select “Properties.”
8. Navigate to the “Permissions” page.
9. Click on the “Add” button to grant permissions for the newly created login.
10. Enter the user’s login name, select the desired permissions (read, insert, delete, modify), and click “OK” to apply the changes.
11. Repeat steps 4-10 to create and assign permissions for additional users.

Creating an Index:
Indexes improve query performance by allowing the database engine to quickly locate and retrieve data. To create an index, the following steps can be followed:

1. Open Microsoft Access and open the database containing the desired table.
2. In the Navigation Pane, locate the table and right-click on it.
3. From the context menu, select “Design View” to open the table in design mode.
4. Select the column(s) that need to be indexed.
5. On the “Design” tab, click the “Indexes” button in the “Tools” group.
6. In the “Indexes” dialog box, click the “Add” button.
7. Specify the index name, select the desired column(s), and choose the appropriate index type (e.g., primary key, unique, or indexed).
8. Click “Save” to create the index.

Creating Screen Views (Forms) in Access:
Access forms provide a user-friendly interface for interacting with data stored in the database. To create a form in Microsoft Access, follow these steps:

1. Open Microsoft Access and open the database containing the desired table.
2. In the Navigation Pane, locate the table and right-click on it.
3. From the context menu, select “Form” to create a basic form using the table’s fields.
4. Modify the form layout and design as desired using the form design tools provided by Access.
5. Add controls and arrange them on the form to display the desired data and enable user interaction.
6. Save the form with an appropriate name.

Conclusion:
This guide has provided a comprehensive overview of securing a Microsoft SQL database, defining user permissions through SQL statements, creating indexes, and designing screen views (forms) in Access. By following these recommended steps, you should be able to fulfill the requirements of your assignment successfully.