Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 entries

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 9 For Linux UNIX And Windows Advanced Database Administration Certification Certification Study Guide

Authors: Roger E. Sanders, Dwaine R Snow

1st Edition

1583470808, 978-1583470800

More Books

Students also viewed these Databases questions

Question

Reduce your speech anxiety.

Answered: 1 week ago

Question

3. Identify and describe nine cultural value orientations.

Answered: 1 week ago

Question

=+1 What would you do if you were the IHR manager?

Answered: 1 week ago