Just getting started

  • Thread starter Thread starter David McCarthy
  • Start date Start date
D

David McCarthy

Hello,

I am attempting my very first database in access 2000. My thought was to
write a database that tracks investments (mutuals). Does anyone have a link
to an example database that could help me get started?

Thanks,
Dave
 
David said:
Hello,

I am attempting my very first database in access 2000. My thought
was to write a database that tracks investments (mutuals). Does
anyone have a link to an example database that could help me get
started?

Thanks,
Dave
Click to expand...

Why not use one of the online investment sites, such as Ample (free to
register). Your investments are automatically updated and you can buy &
sell online. Alternatively, Quicken & Microsoft Money have online
facilities for investments. If you really want to do it manually, I suggest
that a spreadsheet such as Excel might be a better choice than a database.

Terry D.
 
Terry D said:
Why not use one of the online investment sites, such as Ample (free to
register). Your investments are automatically updated and you can buy &
sell online. Alternatively, Quicken & Microsoft Money have online
facilities for investments. If you really want to do it manually, I suggest
that a spreadsheet such as Excel might be a better choice than a database.

Terry D.
Click to expand...

Hello Terry,

I am just trying to come up with a project that will help me learn access.

Dave
 
Start out at your local bookstore (or library if you are
lucky) and find a copy of "teaching yourself access", or
even "Access for Dummies" (idiots guide to access too).
From there, move up to "complete Access" or "Access ..
bible". Most of these will come with a cd containing a
sample database which follows the examples given in that
book. All of them are excellent references.

Alternatively, go down to your local university or
community college and sign up for any beginning course on
using access.
 
Hi David,

Sample Access databases that you can download and adapt
One of the best ways to put Access to work is to adapt an existing database
or database object (database objects: An Access database contains objects
such as tables, queries, forms, reports, pages, macros, and modules. An
Access project contains objects such as forms, reports, pages, macros, and
modules.) to suit your needs. To help you be more productive, the Access
team provides a number of databases that you can download and adapt for
your own use.

Database of Access 2000 sample forms
The sample forms (form: An Access database object on which you place
controls for taking actions or for entering, displaying, and editing data
in fields.) in this database demonstrate a variety of form types and
techniques, including how to manipulate data, use controls (control: A
graphical user interface object, such as a text box, check box, scroll bar,
or command button, that lets users control the program. You use controls to
display data or choices, perform an action, or make the user interface
easier to read.), and create undo and redo operations.

Download the sample forms database:
http://www.microsoft.com/downloads/details.aspx?FamilyId=7A50205E-A29B-4A43-
8508-78E549ECD14C&displaylang=en

Database of Access 2000 sample reports
The sample reports (report: An Access database object that prints
information that is formatted and organized according to your
specifications. Examples of reports are sales summaries, phone lists, and
mailing labels.) in this database demonstrate a number of techniques,
including how to shade every other row or every nth row in a report, how to
create a table of contents or an index for a report, and how to create a
top 10 report.

Access 2000 Sample: Report Topics
http://www.microsoft.com/downloads/details.aspx?FamilyId=71DB24A5-C76F-4EDA-
BC9A-5FAC336EF7F1&displaylang=en

Database of Access 2000 sample queries
The sample queries (query: A question about the data stored in your tables,
or a request to perform an action on the data. A query can bring together
data from multiple tables to serve as the source of data for a form,
report, or data access page.) in this database demonstrate a number of
querying techniques, including how to rank records within a query, how to
group one set of records and sort on another, and how to use custom
functions in queries.

Access 2000 Sample: Query Topics:
http://www.microsoft.com/downloads/details.aspx?FamilyId=AB5AFF5B-A8BA-4C2B-
BAB7-EEA1F953C040&displaylang=en

For Further Information :
http://office.microsoft.com/assistance/preview.aspx?AssetID=HA011201381033&C
TT=98
Roadmap to Access 2003 training
http://office.microsoft.com/assistance/preview.aspx?AssetID=HA011189511033&C
TT=98

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top