The Record Collectors Guild Forum Index

Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
OnTheRecordOffline
Post subject:   PostPosted: Dec 10, 2006 - 06:50 AM
R.C.Guild-SM
R.C.Guild-SM


Joined: Aug 11, 2005
Posts: 1726

Status: Offline
Vinyl1: You need this book: http://www.amazon.com/I-T-Wars-Managing-Business-Technology-Millennium/dp/1419627635
 
 View user's profile Send private message  
Reply with quote Back to top
Diaz-oOffline
Post subject:   PostPosted: Dec 10, 2006 - 07:55 AM
R.C.Guild-SM
R.C.Guild-SM


Joined: Feb 28, 2005
Posts: 984
Location: San Anto TX
Status: Offline
Atlantic_CTI_Jazz wrote:

You can pretty much do that in Excel. I have a seperate worksheet for Jazz, Soul, Rock/Pop, Library.


The problem with Excel is that it isn't a database. The data isn't sortable based on user specified criteria, unlike say, Accces.
 
 View user's profile Send private message  
Reply with quote Back to top
vinyl1Offline
Post subject:   PostPosted: Dec 10, 2006 - 08:04 AM
R.C.Guild-SMR
R.C.Guild-SMR


Joined: Feb 12, 2006
Posts: 1960
Location: New York, NY, USA
Status: Offline
My 28-table database was as complicated as it was because of classical records. It addressed the problem of records that contain works by multiple composers performed by multiple artists. You can't implement a data structure like that in a spreadsheet.
 
 View user's profile Send private message Send e-mail  
Reply with quote Back to top
KimmoOffline
Post subject:   PostPosted: Dec 10, 2006 - 09:20 AM
R.C.Guild-M-SMR
R.C.Guild-M-SMR


Joined: Mar 16, 2004
Posts: 3459
Location: Finland
Status: Offline
Quote:

You can pretty much do that in Excel. I have a seperate worksheet for Jazz, Soul, Rock/Pop, Library.

The problem with Excel is that it isn't a database. The data isn't sortable based on user specified criteria, unlike say, Accces.


you always can import the excel to access, and work it there ...
 
 View user's profile Send private message Send e-mail  
Reply with quote Back to top
earthnomadOffline
Post subject: Filing/Cataloging Questions  PostPosted: Dec 10, 2006 - 01:07 PM
Level 3
Level 3


Joined: May 01, 2006
Posts: 42

Status: Offline
I use Excel for both albums and music-related books (separate spreadsheets for each). But I also have recently cataloged my music-related books on librarything.com Does anyone know if there is something similar online for albums?
 
 View user's profile Send private message  
Reply with quote Back to top
annaloogOffline
Post subject:   PostPosted: Dec 10, 2006 - 03:57 PM
R.C.Guild-M-SMR
R.C.Guild-M-SMR


Joined: Jun 03, 2003
Posts: 12491
Location: Nashville, TN (USA)
Status: Offline
Diaz-o wrote:
The problem with Excel is that it isn't a database. The data isn't sortable based on user specified criteria, unlike say, Accces.

One of the problems with Access is its data entry/editing interface is cumbersome to use, not as easy as with a good spreadsheet program. Its 'visual' report designer and query integration could be improved -- I've seen much better implementations in competing SW, but I doubt that Microsoft will spend the time/money to do it. And as Kimmo mentioned, the data can be exported to Access or other DB tables.
 
 View user's profile Send private message Send e-mail  
Reply with quote Back to top
Diaz-oOffline
Post subject:   PostPosted: Dec 10, 2006 - 06:52 PM
R.C.Guild-SM
R.C.Guild-SM


Joined: Feb 28, 2005
Posts: 984
Location: San Anto TX
Status: Offline
Programmed properly, Access data entry and editing should be seamless. Therein is the problem, Excel is simpler from a creator's standpoint. I don't program in Access but I have used consultants to create an Access database for work.

I'm not sure how or why you would export to Access, since you need to create a database to be able to make any use of the information once you transfer from Excel. I've transferred from Access to Excel, when all you need is a simple table.
 
 View user's profile Send private message  
Reply with quote Back to top
B_big.Offline
Post subject: Using Access for record collection cataloging  PostPosted: Feb 08, 2009 - 05:52 AM
R.C.Guild-SMR
R.C.Guild-SMR


Joined: Mar 04, 2006
Posts: 10694
Location: Berlin/Germany/Europe
Status: Offline
Diaz-o wrote:
Programmed properly, Access data entry and editing should be seamless . . . .
( ( ( ( ( ((((((( Cool
    You're absolutely right, I've created an data-entry-mask and use it constantly. This is even more easy than using an Excel spread sheet.
    Smile

_________________
.

the fine art of record cover & sleeve & more
berlin/germany/europe/planet earth/milky way/universe
 
 View user's profile Send private message Send e-mail Visit poster's website  
Reply with quote Back to top
liboriofrikiOffline
Post subject:   PostPosted: Apr 11, 2013 - 08:34 PM
Level 1
Level 1


Joined: Apr 11, 2013
Posts: 3

Status: Offline
alphabetical
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2007 The PNphpBB Group
Credits