Access+copying+and+pasting+data+into+a+table

Home / software / microsoft access / Tutorials

> || || > > > > > > > >
 * Practical Learning: Copying and Pasting Data Into a Table ||
 * 1) From the resources that accompany these lessons, open the Cruise2 database
 * 2) In the Navigation Pane, double-click Cabins: Table
 * 3) In the Navigation Pane, double-click Cabins Update: Table
 * 4) In the Cabins Update table, right-click the Size column header and click Copy
 * [[image:http://www.functionx.com/access/tables/copy1.gif width="599" height="390" caption="Copying"]] ||
 * [[image:http://www.functionx.com/access/tables/copy1.gif width="599" height="390" caption="Copying"]] ||
 * 1) Click the Cabins tab
 * 2) Right-click the Size column header and click Paste
 * 1) When you receive a message box whether you want to add the 10 records, click Yes
 * 1) Click the Cabins Update tab
 * 2) Select the last two columns: Available and Description
 * 3) Right-click the selection and click Copy
 * 1) Click the Cabins tab
 * 2) Select the last two columns: Available and Description
 * 3) Right-click the selected columns and click Paste
 * 1) Close the Cabins Update table
 * 2) In the Navigation Pane, double-click New Cabins: Table
 * 3) Click the box on the left side of record number 4
 * 4) Press and hold Shift
 * 5) Click the box on the left side of record number 1
 * 6) Release Shift
 * 7) Press Ctrl + C
 * 8) Click the Cabins tab
 * 9) Click the box on the left side of (New)
 * 10) Press Ctrl + V
 * 11) When asked whether you want to add the four new records, press Enter
 * 12) Close all tables