access database

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » ACCESS DATABASE

ACCESS DATABASE

resolvedResolved · Urgent Priority · Version 2003

Felice has attended:
Excel Introduction course
Word Advanced course

ACCESS DATABASE

I have a database in place and I should like to move columns with the existing data.
I know if you go into design view you can add more columns but I cannot seem to be able to move the columns.
I have not done any queries or reports on this database so I cannot effect them. Help please

RE: ACCESS DATABASE

Hello Felice

Thank you for your question.

When you are in the table design view, click on the grey box to the left of the field you wish to move; then hold the left mouse button down and drag the field to where you want it to appear in the table.

Save and close the table.

I hope this helps.

Kind regards
Amanda


 

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips


Server loaded in 0.09 secs.