Home / MS-Access / Getting Started

Designing Client Tables

Defining tables in a Microsoft Access 2010 desktop database (.accdb file) is incredibly easy. This tutorial shows you how it is done.

You could begin building a database in Access 2010 much as you might begin creating a simple single-sheet solution in a spreadsheet application such as Microsoft Excel-by simply organizing your data into rows and columns and then inserting formulas where you need calculations. If you've ever worked extensively with a database or a spreadsheet application, you already know that this unplanned approach works in only the most trivial situations. Solving real problems takes some planning; otherwise, you end up building your application over and over again. One of the beauties of a relational database system such as Access is that it's much easier to make midcourse corrections. However, it's well worth spending time up front designing the tasks you want to perform, the data structures you need to support those tasks, and the flow of tasks within your database application.