Question: table [ [ Step , Instructions,Points Possible ] , [ 1 , Start Access. Open the downloaded Access file named Exp 1 9 _
tableStepInstructions,Points PossibleStart Access. Open the downloaded Access file named ExpAccessChMLGames. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.,tableOpen the Games table and review the fields containing the game information. Close the table.Create a new table in Design view. Add the field name SystemID and select AutoNumber as the Data Type. Add the caption System ID Set the SystemID field as the primary key for the table.Add a second field named SystemName with the Short Text Data Type. Change the SystemName field size property to Add the caption System Name. Save the table as System.,tableSwitch to Datasheet view and enter the following system names, letting Access assign the System ID:XBOX PSWitNESPC GameNintendo DSDoubleclick the border to the right of the System Name column to set the column width to Best Fit. Save and close the table.Create a new table in Design view. Add the field name CategoryID and select AutoNumber as the Data Type. Add the caption Category ID Set the CategoryID field as the Primary Key for the table.,Add a second field named CategoryDescription and accept S St Text as the Data Type. Change the field size property to Add the caption Category Jescription. Save the table as Category.,
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
