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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!