access training course - Access fields

The UK's most regular instructor-led training courses.
Training information: access training course · Microsoft access courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Access fields

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

by - delegate Lucy [13 posts] (2007 Jun 4 Mon, 11:08) Reply

How do I make a new field?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: access fields

by - trainer Tracy platinum contributer [586 posts] (2007 Jun 4 Mon, 15:36) Reply

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

· MS Access and Database Normalisation
· Innovation with Microsoft Access
· Access VBA Handling Errors and Debugging Code
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Microsoft Access Training Unleashes the Power of the Pivot Table