Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access training course - access fields

Forum home » Delegate support and help forum » Microsoft Access Training and help » access training course - Access fields

access training course - Access fields

ResolvedVersion Standard

Lucy has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course
Access Intermediate course

Access fields

How do I make a new field?

RE: access fields

Hi Lucy,

Thanks for the question.

If you double - click into the table you want to add an extra field into, go into the Design view. Simply type the name of the field under the heading "Field Name" and change the Field Type accordingly and now if you were to switch back into your table (Datasheet View) you will see an extra field has been added.

Tracy

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.