Shuffle - 1 - Examine Data in Access that was imported from Excel
Posted on
6,227 Points
7:11
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
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.
0 Comments
Suggested Videos
I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user. I would like to think this is a "le…
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html). I have realized that my coworkers primarily use Excel and So have changed the ar…
Suggested Courses
Next Video:Using Excel's Lambda Function