User:HStallard

Databases

To get started with your first Access database, launch Access and choose File > New and then click the Blank Database option. Type a name for your database and click Create. On the screen you'll see a dialog containing links to the type of objects that might be included in your application. You won’t use all of these but you will use Tables, Queries, Forms and Reports in most cases.

The Objects list is where you'll find all the elements you've created for your database. Create a Table You start by creating a table. Click the Tables link in the Objects list. Choose Create Table by Using Wizard. The Wizard includes sample table structures that you can use to build your own table. For example, click the Contacts entry to see a list of fields often used in Contacts tables. Add the fields from the list that you want to use in your contacts list. If you don’t need a particular field, don't add it. You will probably want at least first name, last name, address, city, state or province, zip code and phone number field. Select the fields you need for your data file from the Tables Wizard options.