Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2012, 01:05 PM
Slurpyga Slurpyga is offline Using excel to track video game collection - questions Windows 7 64bit Using excel to track video game collection - questions Office 2007
Novice
Using excel to track video game collection - questions
 
Join Date: Jul 2012
Posts: 2
Slurpyga is on a distinguished road
Default Using excel to track video game collection - questions

Over the past year or so I've been meaning to finally create a database of sorts to track my game collection(retail boxed/digital games, guides etc). I'm moving within the month, and am in the process of packing everything up so now is my best time to create said database. To be blunt, I've used excel for very basic items but never a large database with multiple 'categories'. I have opened excel but that's as far as I got because I want to make sure the best way to go about this. My first thought-through was I'll have about 10 columns(all ofwhich I would like to be able to sort by). And about a thousand rows(one row for each individual item). My question is really about entering the data and 'locking the rows of info together'. Should I just start entering data from left to right(title/release/genre/etc/etc)? I assume there is some way to lock all cells in a row together which will make this possible? IE: so that I can sort each column and 'all the data' in that row gets sorted as well. In essence I need to know: -Is there any special way I should enter the data(special cell) or just start typing the data in in each cell then format later? -How do I lock each row of information together? So that each row is 'one entry' rather then a row of 10 columns -Any special way to create sortable columns? Or will just clicking the header and hitting sort work? Thanks in advance, and sorry for the noob questions - but I'll probably never ever use excel after this so I don't really want to invest in a book and video guides that cover everything.
Reply With Quote
  #2  
Old 07-05-2012, 03:31 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Using excel to track video game collection - questions Windows 7 32bit Using excel to track video game collection - questions Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Welcome to the forum.

Excel isn't a very good database, but I guess it should be sufficient for your needs because you don't have much data, you're not worried about security and you don't have plans to create sophisticated queries to analyse the data.

Yep, a good starting point would be to column headers across the first row and then you can start inputting your data. If you're feeling adventurous then you could look into using a table in Excel.

In Excel 2007 there are a couple of ways you could use to sort your data. If you use a table then you will automatically get some filter buttons in the header row and you can use these to sort the data. Alternatively, if you want to use the Sort button on the Data tab, then just make sure you select all of your data before clicking on the button and Excel will understand that it needs to keep each row of data together. If you accidentally miss a column in your selection Excel will probably be clever enough to spot your mistake and it will ask you if you would like it to expand the selection to include the missing column.
Reply With Quote
  #3  
Old 07-05-2012, 03:34 PM
macropod's Avatar
macropod macropod is offline Using excel to track video game collection - questions Windows 7 64bit Using excel to track video game collection - questions Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Slurpyga,

If you input the data for a given game on a single row, with one column for each of your categories, you can use Excel's filtering tools to display only those records that match the filtering criteria. You can also sort your data for a more permanent ordering. The only thing to ensure there is that all the data columns are selected for sorting.

PS: With 1000+ games, I think you need to get out more
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 07-05-2012, 05:48 PM
Slurpyga Slurpyga is offline Using excel to track video game collection - questions Windows 7 64bit Using excel to track video game collection - questions Office 2007
Novice
Using excel to track video game collection - questions
 
Join Date: Jul 2012
Posts: 2
Slurpyga is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi Slurpyga,

If you input the data for a given game on a single row, with one column for each of your categories, you can use Excel's filtering tools to display only those records that match the filtering criteria. You can also sort your data for a more permanent ordering. The only thing to ensure there is that all the data columns are selected for sorting.

PS: With 1000+ games, I think you need to get out more
Thanks for the reply. As for the amount of stuff, I'm a gamer(and a collector). Most of my collection is actually not stuff I play[old NES games] that I have for collections sake. Everyones got a hobby, mine just takes up a good portion of my basement
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Game Development mic101 PowerPoint 0 03-06-2012 01:53 PM
Game of Life VBA lor Excel Programming 0 06-22-2011 12:32 PM
Using excel to track video game collection - questions Questions on making a form to track research; please help Lacrosseboss18 Excel 3 03-13-2011 07:46 PM
Using excel to track video game collection - questions Making Jeopardy-like game - need assistance darkskye PowerPoint 1 07-28-2010 06:35 AM
Using excel to track video game collection - questions Excel 2009-10 Video Tutorials?! Zaur Excel 3 07-04-2010 03:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft