work

       Can you envision more than one instance of the entity?        Is there a variation over time?        Is the item to be modeled a person, place, thing, or an event?        Is the item to be modeled an attribute?

       Database Design        Maintenance and Redevelopment        Performance        Testing

       a primary field uses an index.        adding an index to a table might decrease overall database performance slightly.        an index can reduce the amount of time it takes for Access to run queries and reports.        indexes are created using the Index property type.

       is a Boolean field.        is used to describe attributes.        points to the child table.        points to the parent table.

       a junction (associative) table is used.        many matching records are found in each direction between tables.        may be used to connect to Oracle and other databases.        there must be at least two tables.

       used to identify primary keys between tables.        a child of two parent tables that are in a many-to-many relationship.        an integrity element within a table relationship.        a tool that allows you to locate an excel file.

       a set of constraints that helps control illegal data entry.        correcting data errors after they are entered into a table.        duplicating a primary key in a table.        typing data accurately into a table.

       fields.        files.        records.        tables.

       changes the way text data is formatted.        determines the maximum length of a Text field.        requires correct text data input.        specifies the error message when a rule is violated.

       What is the organization's structure and core business?        What are the existing problems with the current database?        Will the database interface with other systems?        All of the above.