Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BBA 2 1 3 4 - Data Management: Individual Assignment 1 4 . In Datasheet View, add the data below to the Student List table:

BBA 2134- Data Management: Individual Assignment 1
4. In Datasheet View, add the data below to the "Student List" table:
Note: For "First Term Attended" the last two characters are numbers, not letters. For example, 'SPO1' is an abbreviation of "Spring 2001." Thus the '01' should both be numbers - not the letter "O" and number "1."
\table[[\table[[Student],[#]],\table[[Last],[Name]],\table[[First],[Name]],Address,City,State,\table[[Zip],[Code]],Balance,\table[[First Term],[Attended]]],[54783,Williams,Jack,\table[[62 Smith],[Lane]],Chicago,IL,60605,42,SP01],[64589,Metheny,Alexa,\table[[125],[Fairview]],Burlington,IA,60606,26,FA02],[95874,\table[[Van],[Wegan]],Alison,\table[[100],[Quantico]],Chicago,IL,60605,25,SP03],[23895,Jackson,Ryan,\table[[2320 Hills],[Circle]],Decatur,IL,60641,46,FA02],[96312,Berstein,Krista,\table[[126 South],[Street]],Chicago,IL,60605,15,FAOO],[54387,Wylliams,Karen,\table[[43 Jones],[Ave.]],Lovington,IL,60605,28,FAOO],[54123,\table[[(Your],[name)]],\table[[(Your],[name)]],\table[[(type in],[any street],[address)]],Your city,\table[[Your],[state]],\table[[Your],[zip],[code]],54,FAOO]]
Modify the column widths as necessary
Create a form using the Form Wizard based on the "Student List" table
a. Use All Fields
b. Layout: Columnar
c. Form Name: Student Form
image text in transcribed

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

Professional SQL Server 2012 Internals And Troubleshooting

Authors: Christian Bolton, Justin Langford

1st Edition

1118177657, 9781118177655

More Books

Students also viewed these Databases questions

Question

Draw a labelled diagram of the Dicot stem.

Answered: 1 week ago

Question

=+What category does this metric represent?

Answered: 1 week ago