From the current view (Design view), change the Field Size property for the StaffID field to 7.
Question
From the current view (Design view), change the Field Size property for the StaffID field to 7.
Solution
-
Open the table that contains the StaffID field in Design View. You can do this by right-clicking on the table in the Navigation Pane and selecting "Design View".
-
In the design grid, click on the row for the StaffID field to select it.
-
In the Field Properties section at the bottom of the screen, click on the "General" tab if it's not already selected.
-
Find the "Field Size" property. It's usually the second property listed under the "General" tab.
-
Click in the "Field Size" box, delete the current value, and type "7".
-
Save your changes by clicking on the "Save" icon in the Quick Access Toolbar at the top of the screen, or by pressing Ctrl + S on your keyboard.
-
Close the table design view by clicking on the "Close" icon in the upper right corner of the screen, or by pressing Ctrl + W on your keyboard.
Similar Questions
Use AutoFilter to filter the query results first to show only records where value in the StaffID field is Mo and the value in the IncreaseType field is Merit.
Use AutoFilter to filter the query results to show only records where the value of the StaffID field is Mo or Shannon.Font Size
If your workbook is wide, you may want to use _________ orientation to view more columns on one page.(Select the correct answer)portraitlandscapepagebackstage
Did you try changing the width of the viewport? Was there a visible change in the output?1 pointYes, and there were changesNoYes, but no visible changes
Select the correct answerYou can enter data in a table inOptionsdatasheet viewdesign viewformat viewNone of these
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.