Please help me understand the way to create a database that can solve
issues like: Inventory Control, Sales Tracking, Employee Sales,
Deliverables DLL,
How can I create DML tables, Insert test values, and Update queries.
What are DLL & DML and how do they work? |
Request for Question Clarification by
hammer-ga
on
31 Oct 2002 05:19 PST
The first part of your question is awfully general. The issues that
you list are very broad with solutions that vary greatly depending on
requirements.
When you say DLL and DML, do you mean DDL and DML? DDL is Data
Definition Language. DML is Data Manipulation Language. Simply put,
they are the two major categories of SQL statements. DDL is the
statements that define your data structure, like CREATE TABLE. DML is
the statements that operate on your data itself, like INSERT.
Judging from some of your other posted questions, you have already
been building tables in Access and starting to work with them, so you
are already using DML! Access does not support the full range of SQL
statements so you will need to work with a different product, such as
SQL Server if you want to experiment with a wider range of DDL and DML
capability.
Does this answer your question? If not, please be more specific about
what sort of information you want, and I will try to help.
|
Clarification of Question by
fahd-ga
on
01 Nov 2002 08:53 PST
Thank you,
Yes by-now I know how to create MS Access tables.
But for this question what I need help with is that:
what kind of formula do I need to use to solve Inventory Control,
Sales Tracking and Employee Sales, and where & how do I use such
formula.
Please Help
Truly,
fahd-ag
|
Request for Question Clarification by
hammer-ga
on
01 Nov 2002 10:04 PST
Hi Fahd,
There is no "formula" for Inventory Control, etc. Each of the topics
you mention is a subject for several books, not a several paragraph
answer.
The Northwind sample database that comes with Access includes simple
examples of the functionality that you mention. I recommend that you
use that as a starting point. This will give you an idea of some of
the issues involved in designing and implemeting an Inventory Control
system, or a Sales Tracking system.
Best of luck with your learning process.
Hammer
|
