<

Shuffle - 1 - Examine Data in Access that was imported from Excel

Posted on
6,106 Points
6 Views
1 Endorsement
Last Modified:
Experience Level: Beginner
7:09
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
Examine data that was imported from Excel. Filter data in Access just like you do in Excel, for just what you want to see.
Turn on a totals row to sum columns. Best-fit columns and change column widths. See how a new AutoNumber value  is automatically assigned, and totals are changed, when a new record is created. Look up a customer code using a quick query.

Here are the other videos in this series:

Shuffle - 2 - Totals Query
https://www.experts-exchange.com/videos/61035/Shuffle-2-Totals-Query.html

Shuffle - 3 - Table Design
https://www.experts-exchange.com/videos/61036/Shuffle-3-Table-Design.html

Shuffle - 4 - Append Query
https://www.experts-exchange.com/videos/61037/Shuffle-4-Append-Query.html

Here is the video that shows how to do the import:

import an Excel spreadsheet into an Access database
https://www.experts-exchange.com/videos/60914/import-an-Excel-spreadsheet-into-an-Access-database.html

Video Steps

1. Open a table in Datasheet view to look at information

2. Click the Filter dropdown at the top of a column to specify criteria for the rows displayed

3. Resize columns to be wider or narrower, double-click to best-fit

4. Add new records at the bottom

5. Look at each column and determine what type of object it is.


      There needs to be a table to describe each type of object.
1
0 Comments

Featured Post

Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Do you want to increase the data integrity of your Excel worksheets?  Do you input something repeatedly?  Would it be handy to pick the item from a predetermined (by you) list?  READ ON!
To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order. But how to rank dupes? Five methods exist, and th…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month