|
External Data Ribbon Advanced Access Objectives In this
lesson, you will learn how to: 1. Append new Records to an existing Table. 2. Create an Action Query to Update the data for selected
Records in a Table. 3. Use an Action Query to Make a new Table and copy selected Records to
that new Table. 4. Create a Delete Query and practice with a copy of an
existing Table. From the
External Data Ribbon.
1.
Microsoft Access->External Data ->Import & Link-> Excel, page
282
From the Create
Ribbon.
Create->Queries->Query Design-> Find Duplicates Query Wizard, page
286
From the Report Design Ribbons. 2.
Query Tools ->Design->Query Type-> Update, page
300 3.
Query Tools ->Design->Query Type-> Make Table, page
302 4.
Query Tools ->Design->Query Type->Delete, page
305 |
|
|
|
