Modify Field Size

[curiousmonkey]

On a Access 2013 test, the first question I was asked was to modify the table structure to accommodate field data. Then I was given a long full name to add but it would not let me type it all.
1) How do I modify field size (without using shortcuts) (do I do this on datasheet view or Design view?)
2) Every time I tried to type the name, it shifted back to the top cell (say A1). Why is that? I deleted which I think was a mistake.

Thank you!!

 

[strive4peace]

Hi curious,

I find the best place to modify size is in design view of the table. Make sure nothing is open that uses the table (like a form, report, or query) so the changes get saved. For more information on modifying tables, watch this video:

Learn Access -5- Modify Data Structure (cc) {music by Melanie Phippard} (4:11)
https://www.youtube.com/watch?v=AAMhAk6Hyic
- Rename tables, Add fields, Modify existing fields, and Copy fields from one table to another

and to build the tables to begin with:
Learn Access -4- Tables and Relationships (cc) 36:04
https://www.youtube.com/watch?v=kmECCLqkQtY