Prev: 2 different Qty in order details in northwind
Next: setvalue macro
From: .:RoKsTaR:. on 12 Nov 2009 11:45
Hi There,

I have no experience with access, so please let me know if this task is too
big.

Is it feasible for me to develop a databse for my private music students
that tracks and reports on the following:

Contact Info
Individual and overall Attendance
Individual and overall Payments
Material covered in each lesson

Cheers!




From: Jeff Boyce on 12 Nov 2009 14:23
That REALLY depends...!

Here are four areas I suggest folks understand if they intend to build an
application in Access:
1. Normalization & relational database design
2. Access tips/tricks
3. Graphical user interface design
4. Experience building applications

To the extent that any/all of these are new to you, plan on spending time
working your way up the learning curve(s).

So, it depends ...

How much time do you have to get this done?

How much do you need/care to learn?

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

".:RoKsTaR:." <.:RoKsTaR:.@discussions.microsoft.com> wrote in message
news:9355BD4B-D0BA-4329-AD38-B017C39A0A05(a)microsoft.com...
> Hi There,
>
> I have no experience with access, so please let me know if this task is
> too
> big.
>
> Is it feasible for me to develop a databse for my private music students
> that tracks and reports on the following:
>
> Contact Info
> Individual and overall Attendance
> Individual and overall Payments
> Material covered in each lesson
>
> Cheers!
>
>
>
>


From: .:RoKsTaR:. on 12 Nov 2009 15:32
I'm usually pretty quick at learning new programs. I'm constantly having to
learn new ones being in the music business since there's new programs almost
every month.

I think it would make my business a lot easier to run, so I have no problem
devoting the time to it. That being said, I'm not sure where to start...I
did a tutorial on the MS Access page, but what next?



"Jeff Boyce" wrote:

> That REALLY depends...!
>
> Here are four areas I suggest folks understand if they intend to build an
> application in Access:
> 1. Normalization & relational database design
> 2. Access tips/tricks
> 3. Graphical user interface design
> 4. Experience building applications
>
> To the extent that any/all of these are new to you, plan on spending time
> working your way up the learning curve(s).
>
> So, it depends ...
>
> How much time do you have to get this done?
>
> How much do you need/care to learn?
>
> Good luck!
>
> Regards
>
> Jeff Boyce
> Microsoft Access MVP
>
> --
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
>
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
>
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
>
> ".:RoKsTaR:." <.:RoKsTaR:.@discussions.microsoft.com> wrote in message
> news:9355BD4B-D0BA-4329-AD38-B017C39A0A05(a)microsoft.com...
> > Hi There,
> >
> > I have no experience with access, so please let me know if this task is
> > too
> > big.
> >
> > Is it feasible for me to develop a databse for my private music students
> > that tracks and reports on the following:
> >
> > Contact Info
> > Individual and overall Attendance
> > Individual and overall Payments
> > Material covered in each lesson
> >
> > Cheers!
> >
> >
> >
> >
>
>
> .
>
From: Fred on 12 Nov 2009 16:17
It's a little different. From a learning standpoint, Access is more like a
big toolbox than a program. And besides just learning what the tools and how
to use them, yo have to start learing architecture (information and db
structures) to decide what to build with those tools and how to build it.

Sometimes it good to structure/facilitate/move along your learning by trying
to simultaneously. So here's something like that. Try to:

Decide what the fundamental "entities" are that you are trying to database.
My guess is that they are

T1. People
T2. Instances of payment for instruction (of that person)
T3. Instances of a class being scheduled for a person


Make a table for each of those entities, include an autonumber primary key
in each table. For people name the PK Field "PeopleID"

Add an integer (not autonumber) field "PeopleID" in tables T2 & T3.
(these are "foreign keys) and link each of those fields to the "PeopleID"
field in T1

Add fields for each of the attributes that you want to record about your
entities. Here are a few of the more abstract ones:

T1
Current Student? (yes/no)

T2


T3
Showed up? (yes/no)
Description of material covered.


- - -

Now make datasheet style forms for T2 and T2. These will be used as subforms

Make a "one record per page" style form for T1. Then put the T2 & T3
subforms into it.

Then make reports that summarizes T2 records, grouped by Person
Then make reports that summarizes T3 records, grouped by Person

Of courses, explainiing in detail how to do the above is a book, not a post,
but trying to do the above should help driver/direct the learing process.




From: John W. Vinson on 12 Nov 2009 16:21
On Thu, 12 Nov 2009 12:32:10 -0800, .:RoKsTaR:.
<RoKsTaR(a)discussions.microsoft.com> wrote:

>I think it would make my business a lot easier to run, so I have no problem
>devoting the time to it. That being said, I'm not sure where to start...I
>did a tutorial on the MS Access page, but what next?

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


The last three specifically. If you're new to database design, Crystal's video
is a great start.
--

John W. Vinson [MVP]
 |  Next  |  Last
Pages: 1 2 3 4
Prev: 2 different Qty in order details in northwind
Next: setvalue macro