Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create this pls using microsoft access and send the file, thanks. 1. Create a new database. Save it using the filename Lastname.Firstname.accdb. (use your own
Create this pls using microsoft access and send the file, thanks.
1. Create a new database. Save it using the filename Lastname.Firstname.accdb. (use your own first and last name) 2. Create a table in your database using the following: Field size or Format 10 Field Name ID Number Name Last Name Telephone Number Date of Birth Department Family Income Data type Text Text Text Number Date/Time Text Currency 15 15 Long integer Medium Date 4 Currency 3. Make the "ID Number" field as the primary key. 4. Save the table as "Student table". 5. Enter 5 complete records. 6. Sort the table in ascending order by surname. 7. Change the field size of the surname to 20. 8. Create a form with all the fields in the student table. 9. Name the form student entriesStep 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