Areas of Discussion for the Class Session:
♦ What are the principal objects of a database?
◊ Discuss and define database tables. (See slide 1 following this section.) Tables are the foundation of the database. A table is a collection of related fields (columns) and records (rows). Data in the fields and records are related; for example a table could be a list of customers. The customers' names would be in one field, their phone numbers in another.
◊ Discuss and define database forms. (See slide 2 following this section.) Database forms are layouts of the fields in the table on which they are based. Forms provide an orderly way of accessing and maintaining the table. Changes made in the form are reflected in the table (and vice versa). This is an important concept for new database users. Its early mastery will result in a quick understanding of database object relationships.
◊ Discuss and define database queries. (See slide 3 following this section.) Database queries can sort, filter and display data in ways that make the database more manageable.
◊ Discuss and define database reports. (See slide 4 following this section.) Database reports are the output product of the database. Reports list, group, and can calculate numerical data in databases.
◊ Discuss and define database macros. (See slide 5 following this section.) Database macros allow us to store steps or series of steps to make our database work more smoothly.
♦ Why is learning database "object integration" so important?
◊ Efficient database design depends on tables that will store the data in a way it can be accessed, grouped and reported in useful ways.
◊ The objects that support (or are supported by) tables -- i.e., forms, queries and reports -- must be designed using the underlying field and record structure of the database table. Conversely, database table design must take into account ways the database is accessed and what output (reports) are desired.