Microsoft Access 2007 tutorial: Copy and paste tables

Copy and paste tables

V. How to Copy Table

Copying a table is like copying file in your hard drive, flash, or other storage devices. To copy a table follow the steps demonstrated below:

- Right-click the table that you want to copy

- Click Copy

Copy tables

- Past it under other tables

- And when you right-click the navigation pane on the left and click past table, one dialog box will load as figure below:

Paste tables

There are three options to pastes the copied table:

- Structure Only: Copy only structure of a table without the data and the conditions of a table.

- Structure and Data: Copy everything from the table.

- Append Data to Existing Table: Copy data from a table to an existing table.

Note: Both tables must have structure and conditions the same.

VI. How to Delete Row or Record

When enter a wrong data into a row or record, you may want to delete it in a whole row. You can do it and the first thing that you have to do is open the table you want to delete and follow the steps below:

- Select the row

- Click Key Delete or Right-click the row you selected and click delete

VII. How to Copy Row or Record to another Table

Open the table you want to copy the row or record and follow the steps:

- Select the row or record you want to copy

- Right-click the selected row --> Copy

- Past in the table you want to append data.

Note: In this case, both tables must have the number of fields equally unless your data will lose.

Posted comments

Patrick:

Good explanations. Thank you :)

03-22-2013

Dara:

Global and local variables declaration example:
http://www.worldbestlearningcenter.com/tips/Global-variables-in-vba.htm

02-23-2013

ann:

thanks for sharing your knowledge it helps me a lot.

02-11-2013

Tamilan:

Pls post some examples for declaring and calling variables (local and global)

02-09-2013

M.somjate:

Thanks for example color code.

02-08-2013

G G Shah:

Heartly Thanks.God bless you.

01-18-2013

sek sam:

I like this website very much.
It has a lot of helpful helpful materials to learn excel programming.

01-01-2013

limocky:

useful ms access examples...
good web site to to learn access from scratch.

01-01-2013

bakery:

Thank for useful VBA example code...

12-27-2012

prasat:

Thank u for useful website..

11-03-2012

zal:

Thank for really helpful posts

10-28-2012

brasha:

Useful VBA examples for Excel. I really need them.

10-25-2012

.........................................................................................................................	Home \| Forum \| About \| Contact
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.