Scribd
Upload
14 views1 page

MS Access Lab: Database Creation Guide

The document provides step-by-step instructions for creating a database in MS Access, including creating tables for 'Student' and 'Section', entering records, setting primary keys, and generating queries, forms, and reports. It outlines specific tasks such as defining relationships between tables and naming conventions for queries and forms. The instructions are designed for a lab exercise in a Community College's Administrative Sciences department.

Uploaded by

mohamedortiga536378
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views1 page

MS Access Lab: Database Creation Guide

The document provides step-by-step instructions for creating a database in MS Access, including creating tables for 'Student' and 'Section', entering records, setting primary keys, and generating queries, forms, and reports. It outlines specific tasks such as defining relationships between tables and naming conventions for queries and forms. The instructions are designed for a lab exercise in a Community College's Administrative Sciences department.

Uploaded by

mohamedortiga536378
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Department of Administrative Sciences

Community College

MS Access Lab

Open MS Access and DO THE FOLLOWING:


1. Create a new database and save as your name (0.5)
2. Create new Table as shown below and name it (Student) (2.5)
Field Name Data Type
SID Number
Name Short Text
Age Number
Mobile Number

3. Set (SID) field as the Primary Key (0.5)

4. Enter the 4 records as shown below: (0.5)


SID Name Age Mobile
44 Reem 20 50000000
45 Asmaa 25 51111111
5. Create Query that returns Name and SID of who their Name =“Asmaa” and name it “Rank Query “ (1)

6. Create a form and name it " Student Form” (0.5)


7. Create a Report that return Name and Age then name it " Student Report” (1)
8. Create new Table as shown below and name it (Section) (1.5)
Field Name Data Type
Section ID Number
Section Name Short Text
Instructor ID Number

9. Set (Section ID) field as the Primary Key (0.5)


10. Enter the 4 records as shown below: (0.5)
Section ID Section Name Instructor ID
112 14M 2343242
113 18M 2397100

11. Define a relationship between the two tables (Student and Section) (1)

You might also like