Question

Lab Assignment – Database Implementation and Security

In this lab you will create a Microsoft Access database of employee information and secure the table username and password security.

Steps

1. Enter data for five employee records.
   1. Each record should have fields: Employee ID (5 digits), First Name, Last Name, Home Address, Hire Date
2. Create a query that displays Employee ID, First Name and Last Name.
3. Create a form that requires entering username and password to access employee table.

Error message should be displayed if incorrect username or password is entered. Use admin for the username and 1105 for the password.

Please explain the steps that i should take to implement and run this

Answer 1

1. Create table emp, then create table login using create table option highlighted

2. select login table and click on create->form design

n国幽@ O L' Controls

2.1 add form fields select the combo button (rename the buttons in properties pallet)

click next on dialogbox -> select the table -> select the userid and username field -> click next and next

2.2 get one textbox for password

2.3. now select
O0XX Button
and click cancel
Add Existing Property Fields | Sheet Tools
click on this to add code

add the following code

e sub clogin_ciick0). pLookup ("password". If Me . Tpassword .Value DLookup ("password", "Login", "(ID) " Me.combolo.Value) Then & = = MsgBox "Password correct", vboKOnly Else MsgBox "Password incorrect", vbOKOnly End If End Sub

Databasel.emp: Database (Access 2007) Microsoft Access Table Tools Home CreateExternal Data Database Tools Datasheet PivotChart Blank Form Labels Blank Report TableTable SharePoint Table Form Split Multiple Form Report ReportQuery Query Macro Form ItemsMore FormsD Report Wizard Design Wizard Design Other Templates. Lists. Design Tables Forms Reports All Tables Login E Form EmployID Emp FirstName LastName HomeAddreHireDate Add New Field 12345 abc 12346 aaa 12347 bblb 12348 ccc 12349 ddd 5/5/2019 4/17/2019 4/16/2019 3/4/2019 2/12/2019 def Emp Table in Login: Table Unrelated Objects Form1 ссс

Emip Form Header Login form Detail design view of form 1 username Unbound PaSrdbound Unkxouurnec Login Form Footer

Login form username admin password 110 × Microsoft Office Access Password incorrect Login OK

To create a query

Create External DataDatabase Tools Design Labels Blank Report PivotChart Blank Form ▼ Design SharePoint Table Form Split Multiple 5" Lists ▼ Design Tables Form Report ReportQuery Query Macro Form Items More Forms Forms Report Wizard Design Wizard Design Show Table Query1 Login-_-| Form1 Emp Tables Queries Both Login le cts Add Close

click on run now

Creat ① Union Insert Rows Delete Rows Builder Insert Columns Delete Columns Return: All Pass-Through Run Select Make Append Update Crosstab Delete Show Data Definition Table Table Query Type esults Query Setup Query1 in Form1 Run Performs the actions specified in a El quey Emp EmploylD Login Table ated Objects Form1 FirstName LastName HomeAddress HireDate Field: EmployID Table: Emp FirstName LastName Emp Emp Sort: Show Criteria: scendin