Work

       data type.        query.        hyperlink.        primary key.

       There must be at least two tables.        Many matching records exist in each direction between the tables.        A junction table is used.        You can connect to tables in other databases such as Oracle.

       fields.        records.        relation.        tuples.

       A child of two parent tables that are in a many-to-many relationship        A child of a parent table that is in a one-to-many relationship        A child of a parent table that is in a one-to-one relationship        None of the above

       relationships focus on query filters while relational tables focus on filters only.        that there really is no difference.        a relational table defines a logical association between two relationships.        relational table is a two-dimensional structure while the relationship defines an association between the tables.

       AutoNumber        Currency        Date/Time        Number

       an example of a setting is Yes (Duplicates OK).        indexed records are scanned sequentially.        indexing a table speeds the retrieval time.        primary keys must be indexed.

       A hire date is considered a constant.        A hire date would be defined as a date/time field.        Date arithmetic can be applied to a hire date field.        The years of service field, which shows how long an employee has been with the company.

       Text        Currency        Name        Date/Time

       Delimiter        Operand        Wildcard        Operator