collection database table help...

[greenom]

Hi ppl,


i have access 2007,very noob..im trying to make a data table,that store prices for comics...ive watched the training clips,but the example there is about phone numbers,and because they dont involve much data,it was defined as view list,and manually edit :home mobile work etc.....what im trying to do is,make a table with issue no. then second row the grades(thats the view list part in the example)now there is 20 grades, i dont want to enter them manually all the time.
is the issue number can be a primary key? do i choose auto number? how it can be done?? is there any ready made template i can use?? ive googled it,but only found 2003 version...downloaded it anyway,just created more problems any help is welcome thanks in advance,scott

[June7]

What do you mean by 'second row the grades'? What is grade?

Is this a database to track comics collection? What data do you want to store - series, title, issue, condition, price?

Maybe this site will help you design db http://www.rogersaccesslibrary.com/

Doesn't matter what purpose of db is, once you understand relational database principles, designing any db should be possible.

[greenom]

thanks mate,
i think i meant 2nd field grades,the condition of the mag..so i want to have the issue number (maybe prime key?) then the condition,there is around 20 grades,and price. so i can click an issue ,see all the grades,and their price...i use this as template,so i can title the table different comics(spiderman.. hulk...)so no mix up with the issues numbers...

[June7]

Do not have separate tables for each series.

Do not use issue number as primary key. I am not even sure the table would need a primary key.

Another consideration is whether or not you will have multiple copies of the same issue.

So far I see possibly 4 tables.

tblSeries
ID (primary key)
SeriesName

tblGrades
ID (primary key)
Condition

tblComics
ID (primary key)
SeriesID (foreign key)
IssueNum
Title

tblComicPriceCondition
ComicID (foreign key)
Price
Condition (this can be ID foreign key or the actual description)

[greenom]

thanks mate,every issue will have 20 grades,every grade can have few prices...so i think u need prime key,to make sure every grade field will be associated with the issue in hand..
i can see what u mean with series name,haha,im trying to make it simple as i can,but for sure its quite evident,i should use just another field..i didnt understand your example..i dont know which one should be pk or fk...
its
series name
issue number
grades
price
(maybe date and description also)

[June7]

I labeled the PK and FK fields.

Perhaps you first read my previous thread before I did some edits.

Could add IssueDate to tblComics and a general comment field could go in any or all tables.

[greenom]

sorry i didnt understand...any way i try i dont get the grades,i have problem with the pk....maybe its too big for me this software,i thought it will be easy...ive watched so many clips and training,i dont get it.. back to the old notebook i guess

[June7]

What do you mean 'don't get the grades'? In a combobox? Review http://www.datapigtechnologies.com/f...combobox3.html

If you want to provide db for analysis, follow instructions at bottom of my post.

[greenom]

What do you mean 'don't get the grades'? In a combobox? Review http://www.datapigtechnologies.com/f...combobox3.html

If you want to provide db for analysis, follow instructions at bottom of my post.

sorry mate...i dont know..maybe im in a different view,data,or design or who knows??? too many options,this is unfriendly user software,waste of time and money...ive posted in three different forums with no results...no one can tell me how to do a simple task,this is simple datasheet,yet all the expert and no result,it speaks volume about this software....i cant believe its microsoft product...you need to take a course to use a software made for common people,not for programmers..thanks anyway..

[June7]

Microsoft is very easy relational database software when compared to Oracle, SQL, etc. You want a real challenge, check out those.

I have suggested a db structure with names for tables and fields. Creating tables is the most basic feature of Access. Click the ribbon Create tab, click Table Design.

It is possible to build a functional db without a single line of code (VBA or macro). I have one. That's why Access has such strong appeal over other db apps like Oracle and SQL. Access offers intrinsic tools to build user interface right in the db.

If you had never seen any word processor or spreadsheet software until today, I expect you would find them almost as challenging.

Suggest you get a basic introductory tutorial book.

[ssanfu]

You could post your dB for analysis....

you need to take a course to use a software made for common people,not for programmers..thanks anyway..

You are right, this is powerful software. While it is easy to create tables - takes more work to understand how to make it more functional with queries, forms and VBA.

Remember, not all of us are into comics (gasp) and don't understand your terminology. But a dB can be created that meets your requirements.
A comics database is not that different from a CD/DVD database. Maybe you could adapt one of those...

There is a good tutorial at http://www.rogersaccesslibrary.com/forum/forum46.html

Good luck with your project...