Save popularkids.xlsx (on your M: drive) from Blackboard

Read Overview worksheet

In a browser, open the URL given in cell A1 of the Overview worksheet

Highlight the data on the Web page and Copy

Paste the data into a text file (Notepad) and save it

Insert a new worksheet RawData

Populate worksheet with data from file: Data > From Text (Delimited > Tab > Finished)

Copy RawData to a new worksheet named Data

Add range names for each column: Gender, Grade, Age, Race, UrbanRural, School, Goals, Grades, Sports, Looks, Money

Insert a new worksheet RangeNames to document the names that you have defined (Formulas > Use in Formula > Paste Names)

Access:

Open Access 2013 and create an empty database called popularkids

Import the Data Excel worksheet into a table called data External Data > Excel

Choose Import the source data into a new table in the current database Browse to your Excel file and click OK

Choose Data worksheet to import and click Next>

Select box First Row Contains Column Headings and click Next

General format is OK for now, click Next>

Let Access add primary key;Next>

Import to Table: Data; Finish; Close

Explore Access:

Home tab Sort & Filter Advanced > Filter by Form > Toggle Filter Send attachments of final products in Access and Excel to markmurph61@gmal.com Link for data: http://lib.stat.cmu.edu/DASL/Datafiles/PopularKids.html