Question: 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
 BBA 2134- Data Management: Individual Assignment 1 4. In Datasheet View,

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!