Ben Posted January 25, 2009 Share Posted January 25, 2009 Hey, I need to create a database for an organisation I'm with. It is for storing all data regarding uniforms. We keep all of the uniforms in a room called 'Stores' and uniform gets loaned out to people and then returned when they're finished with it. So I'm sure from that description you can understand how the database would be used. Basically, some sort of interface needs to be created where the database user can search for a certain person (to see what uniform they have), a uniform size or a particular type of uniform or a combination of any of these. If anybody is experienced in creating databases (using Microsoft Access 2007) then I'd appreciate any advice on the best way to create this database. Thanks Quote Link to comment Share on other sites More sharing options...
Eldmannen Posted January 26, 2009 Share Posted January 26, 2009 How many uniforms does your organization have? in Microsoft Access, you can create databases, then I think you can create some report interface thing via a wizard or something. You create a couple of fields, such as UniformNumber, DateBorrowed, DataReturned, BorrowedByPerson. Or something, like that. I've mostly used the MySQL database, although I've also used SQLite a bit. Remember, to export the database to .sql files, and back it up. Quote Link to comment Share on other sites More sharing options...
Ben Posted January 31, 2009 Author Share Posted January 31, 2009 Thanks Eldmannen, I'll bare that in mind. I should mention however that I have no intention of using the database on a website but just within Access via a form or something. Quote Link to comment Share on other sites More sharing options...
Eldmannen Posted January 31, 2009 Share Posted January 31, 2009 Then you might be able to get away not using a "real" database. If you don't need remote connections, and database connectivity via scripts or applications, then perhaps you could away with using just a spreadsheet software, such as Gnumeric, OpenOffice.org Calc, or Microsoft Excel. Quote Link to comment Share on other sites More sharing options...
Monalisa Posted February 2, 2009 Share Posted February 2, 2009 You can have 2 tables, one is of person detail and other is of uniform details and you can create primary keys Person_id in person details form and uniform id in uniform details and then by using foreign key concept you can fetch the required record Quote Link to comment Share on other sites More sharing options...
Eldmannen Posted February 2, 2009 Share Posted February 2, 2009 You can have 2 tables, one is of person detail and other is of uniform details and you can create primary keys Person_id in person details form and uniform id in uniform details and then by using foreign key concept you can fetch the required record Wow! You seem to know about databases. You know about 'primary key' and 'foreign key', the difference and how to use them. Nice. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.