Scribd
Upload
86 views

Microsoft Access Exam 2021

The document provides instructions for creating an Access exam database with tables for courses, students, books, and borrowed books along with relationships between the tables and enforcing referential integrity. It also instructs to create forms, enter records, and generate queries and reports between the tables.

Uploaded by

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

Microsoft Access Exam 2021

The document provides instructions for creating an Access exam database with tables for courses, students, books, and borrowed books along with relationships between the tables and enforcing referential integrity. It also instructs to create forms, enter records, and generate queries and reports between the tables.

Uploaded by

Jackson Mwangi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

MICROSOFT ACCESS EXAM

a) Create a folder on the desktop called Database Exam. (2 Marks)


b) Create a database called Access Exam 2021 and save it in the folder created in Question (a)
above.
(3 Marks)
c) In that database, create the following tables:
i. Courses
 Course Code (Primary Key)
 Course Title
 Duration
 Lecturer
ii. Students
 Student Number (Primary Key)
 First Name
 Other Names
 Course Code
 Registration Date
 Fees Payable
 Fees Paid
iii. Books
 Title
 Author
 ISBN Number (Primary Key)
 Price
iv. Borrowed Books
 Student Number
 ISBN Number
 Date Borrowed
 Date Returned (10 Marks)

1
d) Create relevant relationships between the tables above, enforce referential integrity with
referential integrity options selected. (15 Marks)
e) Create forms from the above tables and enter the records using the forms as follows:
i. Five records in the courses table
ii. In the students table, a course must be pursued by at least Two students
iii. Ten books in the books table
iv. A student can borrow more than one book in the borrowed books table.

(20 Marks)

f) Create queries and their respective reports from the following related tables:
i. Between courses and students table; group them by course code and name the
query School registrations query and the report as school registrations report
ii. Between books and borrowed books; group by ISBN Number and name the query
School Books query and the report as School Books report
iii. Between students and borrowed books; group by ISBN Number and name the
query Students borrowed books query and the report as Students Borrowed
Books list. (30 Marks)

=========BEST OF LUCK =========

You might also like