Append Data to a Table:
Review the Data
5. Try it: Review the Table Records
Go to All
Access Objects->Tables.
Open a Table: tblMovies.
The Table should open in Datasheet View.
Know
Your Numbers! This Table began with 401 Records. There are now
411 Records, so all 10 new movies were imported from the Excel
spreadsheet.
What Do
You See? There are two copies of the same movie, The Hunger
Games (2012.)
Apparently, there are duplicates in this Table.
Yeah, there's always more
work to do, isn't there? Luckily, there is a
Query Wizard that will help you find the repeats.
Close the
Table. Let's create the Find Duplicates Query.