ms access is a database management system (dbms) that
provides you with the software tools you need to organize
that data in a flexible manner. it includes facilities to
add, modify or delete data from the database, ask
questions (or queries) about the data stored in the
database and produce reports summarizing selected
one of the most important steps in designing a database is ensuring
that the data is properly distributed among its tables. with proper data
structures, the remainder of the application (the queries, forms,
reports, code, etc.) is significantly simplified. the formal name for
proper table design is database normalization.
this article is an overview of the basic database normalization concepts
and some common pitfalls to consider and avoid.