MS Access Database
Creating Access Table
Steps in building a database
Open a new database: You must save a new database file before you can begin creating database objects.
Design and create tables: Design tables to hold your data.
Tell Access how your tables are related: If you have multiple tables with related data in your database you have to tell Access how the tables are related (This is done with the repetition of a field in two tables).
Create forms to make data entry easier. Forms can provide a more familiar environment to enter data because they're more like the paper forms you may be used to. You can design a form so that all fields in one record are visible at the same time, which is not always possible in a table. Like reports and queries, forms can display the fields from more than one table, providing an easy way to view related records.
Enter you data: You can enter data directly into tables, or use one or more forms to enter data into the underlying tables.
Create queries to give you the information you need: Once you have data in your database you may want to look at subset of the complete database. Queries allow you to specify which data you want to see. You may also use queries to calculate new fields.
Create reports to display data and summarized data on paper. Simple reports can be used to format and display data.
More complex reports are useful for analysis- they can group and summarize data.