Scribd
Upload
70 views7 pages

MS Access Database Login Guide

This document provides instructions for creating a login database and form using Microsoft Access and Visual Studio: 1. In MS Access, create a table named "USER" with fields for "Username" and "Password" and enter test data. Save the database. 2. In Visual Studio, create a Windows Form application and add labels, textboxes, and a command button to build a login form. 3. In Access, connect the database to the form by selecting "Data" then "Show Data Sources" and choosing the Access file. Add a table adapter to connect the database tables to the form.

Uploaded by

prettynaugthy
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
70 views7 pages

MS Access Database Login Guide

This document provides instructions for creating a login database and form using Microsoft Access and Visual Studio: 1. In MS Access, create a table named "USER" with fields for "Username" and "Password" and enter test data. Save the database. 2. In Visual Studio, create a Windows Form application and add labels, textboxes, and a command button to build a login form. 3. In Access, connect the database to the form by selecting "Data" then "Show Data Sources" and choosing the Access file. Add a table adapter to connect the database tables to the form.

Uploaded by

prettynaugthy
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd

LOGIN USING MS ACCESS & DATABASE

Diane Loraine S. Tomilloso

Create DATABASE in MS Access


Open the Programs and look for Microsoft Office Access. Click the and choose Blank Database located at the right side of your window. Locate your file to your designated Folder. Click Table in the dialog box. Click Create table using design view. Type USER and PASSWORD in the Fieldname.

View it in Datasheet view to enter data under the Username and Password.

SAVE.

Creating date in MS Visual Studio


Open Programs look for Microsoft Visual Studio. Create and locate your designated folder. Choose Windows and click Windows Form Application. Form dialog box will appear. You can see the environment of MS Visual Studio.

Creating a Form
All available icons are located at the TOOLBOX that can be seen in VIEW on Menu bar.
Ctrl.+ Alt + X to show the toolbox.

Create a form needed for LOGIN.


2 label 2 Textbox 1 Command Button

Dbase Connection from MS Access


Click the DATA on the Menu bar. Click the Show Data Source to connect new database. Click . A dialog box will appear. In Choose your Date Connection click Database then click Next button. Click in Add Connection and click Browse and locate to the Access.

Add query table adapter


Look for your Solution Explore click your dataset. A [Link] will appear. Right click to your TableAdapter, click Add Query.

You might also like