Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

Database Design and Normalization

By now, you should know that a database is a collection of information related to a specific purpose. But how do you organize this information for maximum efficiency? A good database design is the key.

The table is the heart of the database. It is where most of your database work focuses either directly or indirectly. But just because you have several tables that relate to each other in your database doesn’t necessarily mean that they are ready for database functionality.

Considerations related to database design include

  • the purpose of the database

  • necessary tables and fields

  • necessary relationships between tables

  • how to avoid data redundancy

  • how to ensure data consistency

When you examine these considerations, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book