Help with tables and index needed

[Guest]

Hi
I'm a bit of a bedroom DJ and I have my records listed in Word as 3 column
tables in BPM (Beats Per Minute) order. Artist Title BPM. Then further on a
more detailed table for each record, Artist-Title, BPM, Tracklist, date,
genre etc

I want to index as
49ers
Title-1 page 12, 100
Title-2 page 14, 120
Artist - Title, page 14, 121

but had loads of trouble. Can this be done with Word or would I need another
non MS package? I can post an example if needed.

TIA

Ian

 

[Guest]

I'm not exactly sure what you want to do, but for organizing lists of data
like that, you'll probably find that Excel has a few more features (like
advanced sorting and filtering) that Word doesn't. If your tables are laid
out fairly simply, a simple copy-and-paste into Excel usually works well. If
that doesn't work for you, let me know and I can try to help you get your
data into Excel.

Once you are in Excel, make sure you have column descriptions, such as
Title, Artist, etc. in the first row (row 1). To view and sort your data,
you have several options. Try these few two to get you started and see what
works best for you:
1. go to Data > Sort and select the columns you want to sort by (ie BPM
then artist, etc.)
2. go to Data > Filter > Autofilter. This will make your row headers into
pull-down menus that will show you a selected set of data at a time


Heidi

 

[Guest]

Heidi, Thanks for the reply.

I started using Excel but changed to Word because it seemed easier for
tables, I decided to scan the record label and add that and I will be
printing it when it's completed. I hadn't thought about an index until last
week. I was in the middle of a mix and I thought "that record will sound good
in there, whats its BPM and what mix is it?" and I couldn't find it straight
off in my existing book/manual so I thought of a database. They are all well
and good but if I need to refer to it when I am mixing to my PC, I might get
stutters, slow downs etc then thought of an index - its easier to flick
through pages.

Hope this is enough info.

Ian