Tuesday, February 9, 2010

Analysis of a sample database

I looked at the Contacts objects, table, query, form, and report in the sample files of Access 2007 Inside Out CD. The table is laid out the way it is because you can enter data in the column, such as, a name or an address, in the field. And in the row data is collected, such as, a department name.

A Query object lets you see a custom view of data from a table and lets you define queries to select, update, insert, or delete data.

A Form object is for data input, display, or for control of application execution. You can use forms to customize the presentation of data that your application gets from queries or tables. Forms are also printable.

A Report is an object where you can format, calculate, print , and summarize a selected data and you can view your report before you print it.

I think I could use a similar format for my database because I am doing a contacts database project for this course. After all I am a novice in Access 2007.

1 comment:

  1. Yes, it seems you could do something similar to this for your project.

    ReplyDelete