A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

ACCESS DVD Database



 
 
Thread Tools Display Modes
  #31  
Old May 29th, 2007, 04:21 PM posted to microsoft.public.access.gettingstarted
Tom Wickerath
external usenet poster
 
Posts: 3,914
Default 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  
Old May 29th, 2007, 08:50 PM posted to microsoft.public.access.gettingstarted
StopThisAdvertising
external usenet poster
 
Posts: 334
Default 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  
Old May 30th, 2007, 03:09 AM posted to microsoft.public.access.gettingstarted
JackShephard
external usenet poster
 
Posts: 21
Default 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  
Old May 30th, 2007, 03:13 AM posted to microsoft.public.access.gettingstarted
JackShephard
external usenet poster
 
Posts: 21
Default 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  
Old May 30th, 2007, 04:39 AM posted to microsoft.public.access.gettingstarted
JackShephard
external usenet poster
 
Posts: 21
Default 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  
Old May 30th, 2007, 05:55 AM posted to microsoft.public.access.gettingstarted
Albert D. Kallal
external usenet poster
 
Posts: 2,874
Default 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  
Old May 30th, 2007, 08:27 AM posted to microsoft.public.access.gettingstarted
Keith Wilby
external usenet poster
 
Posts: 812
Default ACCESS DVD Database

"Steve" wrote in message
hlink.net...

X-Complaints-To:

Complaint duly submitted.

Keith.

  #38  
Old May 30th, 2007, 12:14 PM posted to microsoft.public.access.gettingstarted
JackShephard
external usenet poster
 
Posts: 21
Default 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  
Old June 22nd, 2007, 03:24 PM posted to microsoft.public.access.gettingstarted
[email protected]
external usenet poster
 
Posts: 2
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.