Good Examples of MS Access Databases
When starting to learn any new project in Microsoft Office, you want to have good sample documents from which to create your own. The MS Access Samples in this article will get you started creating database objects that you can later tailor to your specific needs.
Design and create the tables
Put a lot of energy and care into table design, because all other objects and tasks in Access depend on your tables. Complete this sample exercise to learn the basics of good table design.
Open Access and select "Create>table" to begin creating a movies database. Enter the following sample data for the table:
For each of the columns in the table, double-click the column's header ("Field1", "Field2", etc.) and replace it with one of the following, in the order given here:
Also, replace the default name of the automatically-created "ID" field with this name: "movieid." Press "control-s" to save the table, and give it the name "movies."
Create the movie sales table
Press "Create>table" again to make another table. Fill the table with this data for just one column:
Double-click that column's header and name it "qtysold." Right-click the column and select "Insert>Field." Give the new field's header the name "totalsales." Rename the "ID" field as "saleID."
Create a column whose values will come from the "movies" table you made previously:
Click "Fields" on the Access toolbar, followed by "More Fields," and then "Lookup & Relationship."
Press "Next" on the Lookup Wizard's first screen, select the "Movies" table in screen 2, select "title" in screen 3. Press "Next" in screen 4 ("What sort order..."), and then press "Finish" on the following screen. Double-click the new field's header and rename it "title." Save the table as "moviesales."
The title field you just created pulls values from the movies table, saving you the effort of typing the full name of the movie for the moviesales table. This step also ensures that only predefined values get entered into moviesales. If random text were allowed into this field, the moviesales data would contain bogus transactions that would invalidate that data.
Click here for more information on creating tables in Access.