If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
ACCESS DVD Database
Hi Jack,
Back in 2002, when I was teaching a beginning Access course, I once spent some time with Michael Hernandez at a local Starbucks shop talking about a design for a Video database. In particular, I had a "unique" design that a student submitted to me, that I wanted an expert opinion on. You may recognize the name. Michael is a database design expert, and author of Database Design for Mere Mortals. After discussing the student's design, Michael proposed a design that is very similar to that which John Vinson just volunteered. I thought you might want to have a look: http://home.comcast.net/~tutorme2/sa...rVideosMJH.snp You will need to have the Microsoft Access Snapshot Viewer installed, in order to open this .SNP file: Microsoft Snapshot Viewer is available in download center http://support.microsoft.com/Default.aspx?id=175274 Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "John W. Vinson" wrote: I've been watching this thread with interest, Albert - let me ask you what you think of an idea I've had. Not only might some (small?) fraction of movies have multiple directors; but perhaps you might want to keep track of other people, neither actors nor directors. Producers, costumers, set designers, key grips and best boys... well, this could get silly... but might another modification involve tblPeople PersonID LastName FirstName other bio data tblPeopleInvolved DVD_ID PersonID RoleID tblRoles RoleID Role e.g. Leading Actor, Director, Associate Producer, ... Just throwing out the idea for consideration! John W. Vinson [MVP] |
#32
|
|||
|
|||
ACCESS DVD Database
"JackShephard" schreef in bericht ... And you are exactly what? A money grubber, at best. Do you not have a day job? Hi Jack, Just thought you might be interested... http://home.tiscali.nl/arracom/whoissteve.html Arno R |
#33
|
|||
|
|||
ACCESS DVD Database
On Tue, 29 May 2007 08:21:02 -0700, Tom Wickerath AOS168b AT comcast DOT
net wrote: You will need to have the Microsoft Access Snapshot Viewer installed, in order to open this .SNP file: Microsoft Snapshot Viewer is available in download center http://support.microsoft.com/Default.aspx?id=175274 Tom Wickerath Microsoft Access MVP Thank you. I grabbed that one right away (the viewer). It was funny, the site calculated 1 min DL for T1 at 1.5Mb/s. I got it in less than 5 seconds! I just love fast hooks! |
#34
|
|||
|
|||
ACCESS DVD Database
On Tue, 29 May 2007 21:50:44 +0200, "StopThisAdvertising"
StopThisAdvertising@Data**** wrote: "JackShephard" schreef in bericht ... And you are exactly what? A money grubber, at best. Do you not have a day job? Hi Jack, Just thought you might be interested... http://home.tiscali.nl/arracom/whoissteve.html Arno R He sounds like an illegal LAMEigrant (sorry if that doesn't sound PC). |
#35
|
|||
|
|||
ACCESS DVD Database
On Tue, 29 May 2007 02:30:14 -0700, JackShephard
wrote: I am starting to get you guys' lingo down a bit too. I have a question. I have an already populated "Purchasing table, imported from my spreadsheet. It has about forty records, and uses the DVD_ID as a key. I want to add those fields to my new "DVD_Main table, and then import those records to the appropriate DVD_ID records in the main table. Is this a quick, dialog based job, or do I have to jump through a few hoops to pump the data in? Also, I had some relationships made, then deleted them, but my main table still has little plus symbols in front of the record that drops down this purchasing table. I thought that deleting the relationships would get rid of that, but it has not. After I make the fields, and import the data, I can delete the table, and that should kill it, no? Or is that plus merely showing additional, off screen fields when I drop it down? |
#36
|
|||
|
|||
ACCESS DVD Database
I have an already populated "Purchasing table, imported from my
spreadsheet. It has about forty records, and uses the DVD_ID as a key. I want to add those fields to my new "DVD_Main table, and then import those records to the appropriate DVD_ID records in the main table. Is this a quick, dialog based job, or do I have to jump through a few hoops to pump the data in? Well, you could write some code, but it much easier to use the query builder... So just create a blank new query, and drop in your main table (DVD_main). Now, drop in this table with the purchase data. Now, draw a join line from the primary key in main table to the child table. Now, simply start double clicking on all the fields from the "main" table that will receive merged data from the child table. You can double click on a field name from the list of fields, or you can use drag and drop. Or even use the combo box that appears in each empty grid slot to select the field name. So, we are ONLY placing fields from the main table that will receive our data. Ok, now use the access menu, and go: query-and select "update query". You just changed a select query to a udpate query. You note a new "row" called update to: appears. Now, in the update to field, you have to type in the field name from your 2nd table. Unfornalty drag and drop does not work... So, you type in: MyPurchaseTable.NameOfField You ahve to reapt the above typing for each collum you need. once done, you simply hit the ! buttion to run the query....... Of ocue, you will test this on a copy. Right....of couse you test this on a copy...right??? -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
#37
|
|||
|
|||
ACCESS DVD Database
|
#38
|
|||
|
|||
ACCESS DVD Database
On Tue, 29 May 2007 22:55:24 -0600, "Albert D. Kallal"
wrote: Right....of couse you test this on a copy...right??? Or just NOT save if it fails... Thanks. I need some query construction practice, and this is perfect. |
#39
|
|||
|
|||
ACCESS DVD Database
On May 29, 11:55 pm, "Albert D. Kallal"
wrote: I have an already populated "Purchasing table, imported from my spreadsheet. It has about forty records, and uses the DVD_ID as a key. I want to add those fields to my new "DVD_Main table, and then import those records to the appropriate DVD_ID records in the main table. Is this a quick, dialog based job, or do I have to jump through a few hoops to pump the data in? Well, you could write some code, but it much easier to use the query builder... So just create a blank new query, and drop in your main table (DVD_main). Now, drop in this table with the purchase data. Now, draw a join line from the primary key in main table to the child table. Now, simply start double clicking on all the fields from the "main" table that will receive merged data from the child table. You can double click on a field name from the list of fields, or you can use drag and drop. Or even use the combo box that appears in each empty grid slot to select the field name. So, we are ONLY placing fields from the main table that will receive our data. Ok, now use the access menu, and go: query-and select "update query". You just changed a select query to a udpate query. You note a new "row" called update to: appears. Now, in the update to field, you have to type in the field name from your 2nd table. Unfornalty drag and drop does not work... So, you type in: MyPurchaseTable.NameOfField You ahve to reapt the above typing for each collum you need. once done, you simply hit the ! buttion to run the query....... Of ocue, you will test this on a copy. Right....of couse you test this on a copy...right??? -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada Hello Albert, I've been following your posts here and found it quite interesting in helping me build my DVD collection database also. I've been trying to do the following for msyelf: 1) hold a list of owned movies 2) hold a list of movies I'd like to own (a wish list) 3) a maintenance section that will allow me to update/move/delete/add movies, movie info, and wishlist/owned sections. 4) maybe keep a list of who is borrowing what from me. However, I'm new at learning this stuff, and I think I got some of my relationships down, based on what I have read on your posts. I'd like to get your view point on some stuff and would like to email you what I do have and tell me what you think on the relationships I have setup so far. Please let me know. |
Thread Tools | |
Display Modes | |
|
|