Question
Create a table with the following specifications on a new database program (databases): Field name Data type Employee number auto numbering Employee Name text Function
Create a table with the following specifications on a new database program (databases):
Field name | Data type |
Employee number | auto numbering |
Employee Name | text |
Function | text |
Monthly Salary | coin |
Date of joining work | Date / time |
Married | Yes / no |
1 - Fill out (10) records. 2 - Add two fields named (Work phone, Home phone) with data type (Text) directly below the (Job) field. 3 - Arrange the names of the fields / columns of the table so that they appear in the order: (employee number - employee name - date of joining work - job - work phone - monthly salary - home phone - married). 4 - Change the name of one of the fields in the table with a name synonymous with the old name. 5 - Adjust the column widths and row heights for the open table. 6 - Use the navigation bar to move between records: (first, last, previous, next, new record). 7 - Request to move to record No. (3), then delete the record permanently. 8 - Save the changes to the table, then close the database, and then the (databases) program.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started