Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Where to find information about designing a database in Microsoft Access
Article ID: 289533 - View products that this article applies to.
This article was previously published under Q289533
Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb and .accdb) and to a Microsoft Access project (.adp).
For a Microsoft Access 2000 version of this article, see 288947
For a Microsoft Access 97 version of this article, see 288949
If you decide to store the data for your solution in an Access database or in another relational database, designing the database structure is likely to be the most challenging part of building the solution. Although it is fairly easy to modify the data model while you are developing the solution, it is much more difficult after you have started to build other database objects. Therefore, you should put as much effort as possible into designing the data model before you begin to create any objects in the database. Developing a solution that is based on a well-designed data model will make it much easier for you to develop the solution.
If you are new to relational database design, start by using the following resources: