tables

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Tables

Tables

resolvedResolved · Medium Priority · Version 2003

Basirat has attended:
Access Intermediate course

Tables

Hi,
How can I alter a table in Acces to add or delete a new field using the sql view?

Basirat

RE: Tables

Hi Basirat,

Thank you for your question and welcome to the forum.

Please find a link below that gives you worked examples of the SQL code you could use.

http://www.w3schools.com/SQL/sql_alter.asp

Kind regards

Simon

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Tue 23 Nov 2010: Automatically marked as resolved.


 

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Server loaded in 0.09 secs.