Question 1: Customers Table and CustomerForm
Inserting Records into the Table
Customer records were entered using Datasheet View. The CustomerID field was not manually
entered because it is an AutoNumber field. MS Access automatically generated the CustomerID
for each new record.
A total of four customer records were successfully added to the table.
Purpose of Using a Form
Forms make data entry easier and faster.
Users do not need to access tables directly.
Forms reduce data entry errors.
Forms allow viewing, editing, and adding records one at a time.
TASK 2: Inventory Management System
Fields Description:
ProductID (AutoNumber, Primary Key):
Automatically generates a unique ID for each product.
ProductName (Short Text):
Stores the name of the product.
Category (Short Text):
Stores the category of the product.
Quantity (Number):
Stores the available stock quantity.
Price (Currency):
Stores the price of each product.
The ProductID field was set as the primary key to maintain uniqueness.
InventoryForm
A form named InventoryForm was created using the Form Tool to simplify product data entry
and inventory.
TASK 3: Create a Student Records Database
Creating the Students Table
A table named Students was created using Design View in MS Access.
Fields Description:
StudentID (AutoNumber, Primary Key):
Automatically generates a unique identification number for each student. It ensures that
every student record is unique.
FirstName (Short Text):
Stores the first name of the student.
LastName (Short Text):
Stores the last name of the student.
Program (Short Text):
Stores the academic program in which the student is enrolled (e.g., BCA, BSc, BCom).
YearOfEnrollment (Date/Time):
Stores the year in which the student was enrolled in the college.
The StudentID field was set as the Primary Key to maintain data integrity.
Inserting Records into Students Table
Student records were entered using Datasheet View.
The StudentID field was automatically generated by MS Access.
Creating StudentForm
A form named StudentForm was created using Create → Form option in MS Access.
Purpose of StudentForm:
Provides a user-friendly interface for data entry
Allows users to add, edit, and view student records
Reduces chances of data entry errors
Avoids direct interaction with the table
TASK 4: Create an Order Tracking System
Creating the Orders Table
A table named Orders was created using Design View.
OrderID (AutoNumber, Primary Key):
Automatically generates a unique order number for each order.
CustomerID (Number, Foreign Key):
Stores the CustomerID from the Customers table to identify which customer placed the
order.
OrderDate (Date/Time):
Stores the date on which the order was placed.
Creating the OrderDetails Table
Fields Description:
OrderDetailID (AutoNumber, Primary Key):
Uniquely identifies each order detail record.
OrderID (Number, Foreign Key):
Links each order detail to the Orders table.
ProductName (Short Text):
Stores the name of the ordered product.
Quantity (Number):
Stores the quantity ordered.
TotalPrice (Currency):
Stores the total price of the order item.
OrderForm:
Easy order entry
User-friendly interface
Allows viewing and editing of order records
Reduces data entry errors
Question 5: Create an Employee Payroll System
Creating the Employees Table
Fields Description:
EmployeeID (AutoNumber, Primary Key):
Automatically generates a unique ID for each employee.
Name (Short Text):
Stores the name of the employee.
Position (Short Text):
Stores the job position of the employee.
Salary (Currency):
Stores the salary amount of the employee.
PayCycle (Short Text):
Stores the payment cycle (Monthly or Biweekly).
Creating PayrollForm
PayrollForm:
Simplifies employee salary data entry
Allows viewing and updating payroll records
Provides a professional interface
Reduces manual errors