(a) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address
Highlight the procedures the captain will follow to create the database
(b) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address
List the steps the captain would take to create the table in Design View
(c) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address
Give the data type suitable for each column/field provided
(d) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address
Which field can be used as the primary key?
(e) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address
Mention one importance of primary keys
(f) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five columns/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address
List three SQL command statements the class captain can perform on the database
(g) A class captain was asked to create a database in MS Access for all the student in the class without using any template and name it Student_Record. The table created is to be named Students and should have five colunms/fields with the following names:
ID_Number
Full Name
Date of Birth
Age
Home_Address
Give the SQL query the captain will use to display all the columns in table Students
Explanation
(a) Steps
1. Open Microsoft Access
2. Select "Blank database"
3. Enter "Student_Record" as the name of the database, select a location and then select create
4. Click on file > open and select the database "Student_Record" if not already opened, and click "open"
(b)1. Click on create tab
2. Click Table design
3. Enter a field name in the field Name column and press enter
4. Click on Data type list arrow and select a data type for the field .
5. Type name of the field
6.Repeat 3 to 5 to add more fields
7 after adding fields click on close button and click yes to save changes
8. Enter "Students" as table name to save table.
(c) Data type for each entry
ID_Number - Number/AutoNumber
Full Name - Short Text (Formally known as Text )
Date of Birth - Date & Time
Age - Number/ Calculated
Home Address - Text
(d) ID_Number is unique, hence can be used as the primary key
(e) - Since the primary key serves as an index, speed-based database operations like sorting and searching for records becomes faster.
- The primary key helps to quickly identify and find unique rows in a particular database table.
- In safe mode, only specific records can be uniquely identified using the primary key to ensure that updates and deletion only affect specific rows rather than larger volumes of data.
- Primary keys are used to easily identify a data entry or data from a table or multiple tables and combine the data in a powerful way
- Also primary key serves as an index to enable quick searching
- Primary key helps to quickly identify unique rows
(f) Command Statements include
1. SELECT
2. UPDATE
3. DELETE
4. CREATE TABLE
5. INSERT INTO
(g)The SQL query is
"SELECT * FROM Students"