Form 8815 Navigation 2022-2023

Hello, my name is k1. In this video, I will show you how to create a login form using Microsoft Access. To begin, open Microsoft Access and click on "Login" in the form that pops up. You will then be prompted to enter your user ID and password. Before doing so, you need to set up a table, such as an employee or user table. In this case, I already have a user table that will be used for verifying log-in information. This table includes the username, login ID, and password. To create the form, we will use the pop-up dialog . In the login form, we need to add two fields - one for the login ID and the other for the password. Format them accordingly to make the form visually appealing. Next, add a cancel button and an OK button. Clicking on the OK button will trigger a procedure that opens the login form. Now, let's add some code to the OK button. First, we want to verify whether the login ID and password fields are empty. If they are empty, we will display a message asking the user to enter the necessary information. The title of the form should be "Login ID Required". If the login ID is entered but the password is empty, we will display a similar message. The title of this form will be "Password Required". Next, we will check if both the login ID and password are correct. If they are, we will proceed to the next step, which is opening the application. In order to check the correctness, we will use a lookup function. This function checks whether the entered login ID and password match the ones in the user table. If they do, we display a message saying "Login successful". Finally,...