Hello all! I am brand new to Access and to this forum (this is my first post). I am trying to use Access to setup a simple data base to enter my inventory into (I own my own repair shop). The data will be simple. I need to create tables for the following: item number, item description, supplier, manufacturer, item category (software, hardware, network appliance, custom program, etc.), item price, and number of items in stock. I would also like to eventually add information for phone numbers, addresses and url's of the suppliers and manufacturers and maybe a memo field for the items to allow for a more lengthy description or installation notes if needed. I bought a book (Access Bible) thinking it would help but I am totally lost. I understand the need for good planning and with that in mind I figured it would be best to get some help early on. I think I'm going to need at least three tables to start: one for the items, one for the Suppliers, and one for the Manufacturers. but I need help deciding which data to include in each table and how I should setup the relationships among the tables themselves. Can anyone offer some guidance? I know this is probably easy stuff for the initiated, but again, I am a total newbie to Access and would appreciate any help I can get.