Scribd
Upload
2 views2 pages

Microsoft Access Computer Questions

The document outlines practical and theoretical questions related to Microsoft Access, covering basic concepts such as databases, tables, records, and queries. It includes practical tasks like creating a database for student registration, generating queries, forms, and reports, as well as challenge questions for a comprehensive student registration system. Additionally, it addresses theoretical aspects such as the importance of primary keys, advantages of databases, and the necessity of regular backups.

Uploaded by

cwanyama053
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
2 views2 pages

Microsoft Access Computer Questions

The document outlines practical and theoretical questions related to Microsoft Access, covering basic concepts such as databases, tables, records, and queries. It includes practical tasks like creating a database for student registration, generating queries, forms, and reports, as well as challenge questions for a comprehensive student registration system. Additionally, it addresses theoretical aspects such as the importance of primary keys, advantages of databases, and the necessity of regular backups.

Uploaded by

cwanyama053
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

MICROSOFT ACCESS – COMPUTER PRACTICAL

QUESTIONS
Section A: Basic Questions
1. What is Microsoft Access?

2. State three uses of Microsoft Access.

3. What is a database?

4. What is a table in Microsoft Access?

5. What is a record?

6. What is a field?

7. What is a primary key?

8. Give two examples of data types used in Microsoft Access.

9. What is a query?

10. What is a form?

11. What is a report?

Section B: Practical Questions


Question 1: Create a Database
Create a database named Student_Registration. Create a table named Students with the fields below.
Set StudentID as the primary key and enter at least 10 student records.

Field Name Data Type

StudentID AutoNumber

FirstName Short Text

LastName Short Text

Gender Short Text

DateOfBirth Date/Time

Class Short Text

PhoneNumber Short Text

Question 2: Create a Query


Create a query displaying StudentID, FirstName, LastName, Gender and Class. Sort students by
LastName in ascending order.

Question 3: Create a Form


Create a form based on the Students table. The form should allow a user to add, view, edit and navigate
between records.
Question 4: Create a Report
Create a report showing all registered students. Include the school name, title STUDENT
REGISTRATION REPORT, StudentID, student name, gender, date of birth, class and phone number.

Question 5: Filtering Records


Create a query displaying only students belonging to Form 2. Create another query displaying only
female students.

Question 6: Sorting
Create a query that sorts students according to DateOfBirth, from oldest to youngest.

Question 7: Searching
Create a query that allows the user to enter a student's name and find the student's record.

Section C: Challenge Question


Create a simple Student Registration System containing: (1) a Students table, (2) a Registration form,
(3) a Student Search query, (4) a Class query, and (5) a Student Registration report. Add suitable buttons
for New Record, Save Record, Search, Next Record, Previous Record and Close Form.

Section D: Theory
1. Differentiate between a table and a query.

2. Explain the importance of a primary key.

3. State four advantages of using a database.

4. Explain the difference between a form and a report.

5. What is the purpose of a query in Microsoft Access?

6. Why should important database fields have appropriate data types?

7. State three examples of information that can be stored in a school database.

8. Explain why databases should be backed up regularly.

You might also like