(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
(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"
Contributions ({{ comment_count }})
Please wait...
Modal title
Report
Block User
{{ feedback_modal_data.title }}