Lab Assignment on Creating a Simple Database on MS Access

 Lab Assignment 1: Creating a Simple Database

Objective: Introduce students to the MS Access interface and the basics of creating a database.

Steps:

1.    Launch Microsoft Access:

·         If you have Microsoft Access installed, open the program.

2.    Create a New Database:

·         On the Access startup screen, click "Blank Database."

·         In the "File New Database" dialog, give your database a name (e.g., "StudentDatabase") and choose a location to save it.

·         Click "Create."

3.    Create a Table:

·         You will now be in the database design view. Here, you can create tables to store your data.

·         Click on "Table Design" to create a new table.

·         Define the table structure by specifying the field names and data types. For example:

·         Field Name: ID (Set as AutoNumber for a unique identifier)

·         Field Name: Name (Text)

·         Field Name: Email (Text)

·         Field Name: Phone (Text)

4.    Set Primary Key:

·         In the table design view, select the "ID" field.

·         Click on the "Primary Key" button in the toolbar to set it as the primary key for the table. This ensures that each record in the table has a unique identifier.

5.    Save the Table:

·         Save the table by giving it a name (e.g., "Student Information").

·         Close the table design view.

6.    Enter Data:

·         You can now enter data into your table. Go to the "Datasheet View" by clicking "View" and selecting "Datasheet View."

·         Enter at least 5 records with sample data, such as student names, email addresses, and phone numbers.

7.    Save and Close:

·         After entering data, save the table by clicking "Save" in the upper left corner.

·         Close the table.

8.    Save the Database:

·         Go back to the main Access window.

·         Click "File" and then "Save" to save the entire database.

9.    Assignment Completion:

·         Your simple database is now created, and you've successfully completed Lab Assignment 1.

Students should follow these steps to create the database and table as described in the assignment. This lab assignment aims to familiarize students with the basic features of Microsoft Access, including creating a new database, defining tables, setting a primary key, and entering data. It's a foundational exercise for understanding database management using MS Access.