Creating a Microsoft Access database requires at least a few basic steps to get started, such as creating tables and queries. To add a little pizzazz and a user interface for your Access database, forms and reports also need to be created.
Microsoft Access tables are the heart and soul of Access databases. A detailed tutorial is available on Brighthub for creating tables. This tutorial also takes you step by step through creating tables and forms.
Access queries help you organize, add, edit and manipulate data in your Access database tables. Queries can be as simple or complex as needed. To get started creating queries in your database see these Access tips for query creation.
After you’ve created a few tables and queries, consider creating forms for your users. Forms allow your users to access your database through an easy to understand graphical user interface. Users can run reports, add data, view existing data or even edit data from a form. In an Access database, you can create forms either manually or through a wizard.
Forms and reports both can have sub-sections. In a form, this is called a subform. Subforms allow you to create a form within a form. This allows you to show data from multiple, related tables in a single main form.
The final main element of a great Access database is the report. At any point in time, a user can run a report to gather a set of data from your database. This data set is based upon criteria such as dates, ranges, names and even locations. Reports can be organized and sorted based upon any data listed in the report.