Need Clarification Regarding Copy, Paste, Delete Function ?

[ESAKKI109]

can we do copy/paste/delete multiple cells in Access 2013 as in Excel.

{NeoPa}A separate question was split off to Need Clarification Regarding Undo and Redo{/NeoPa}

[twinnyfo]

There is no undo capability for MS Access, as records in database tables don't work that way.

Also, since Access tables differ greatly from MS Excel Spreadsheets, they do not have "cells" in the traditional sense of the word. They have "fields" in "records" in "tables".

All that aside, it is possible to delete values from a table. However, without additional detail, it is impossible to provide any additional guidance.

[ESAKKI109]

Ya I am talking about Fileds in every record. I can able to copy,paste,dele te single Filed.Is that possible to copy,delete mutilple same fields in different records .

[twinnyfo]

You will have to provide a better description of what you want to do. I know it is possible to do all those things, but I don't quite understand your question.

[ESAKKI109]

in the attached image can we do copy , paste and delete multiple names (ex:john,alex barry) at the same time under student name's column . If yes ,how can we do that .
becoz I can able to copy or delete one name at single time.

[NeoPa]

You can actually copy and paste multiple cells from one grid to another in Access. However, to do so the correct shape of cells must first be selected. This can cover fields in a record; A field across multiple records; or even multiple fields across multiple records. It's not as flexible as Excel and won't duplicate for you (EG. You cannot copy one set of fields and duplicate the same data across many records, as you can in Excel.) but with the proper understanding you can copy vast amounts of data from one grid to another in Access, or even to Access from Excel. Using Excel, you can prepare the data you want with many clever tricks and then Copy/Paste it across to an Access grid.

NB. Selecting a cell in Access is no the same as selecting the data in the cell. Only when the background of the cell is all highlighted is the cell selected. Otherwise only the contents are selected.