Update query shift down by 1

[BWI]

I'm using MS Access trying to create an update query that shifts the data in a column down by 1 row.

Example DataTable:
column1 -- column2
data 1 -- other data1
data. 2 -- other data2
data(3) -- other data3

UPDATE DataTable SET DataTable.newcolumn1 = column1 [shifted down by 1 row];

newcolumn1 -- column2
Blank -- other data1
data 1 -- other data2
data. 2 -- other data3
data(3) --


It would also be great if I could reformat the data at the same time.
column1
data 1
data. 2
data(3)

newcolumn1
blank
data1
data2
data3

Any help would be appreciated!