CGS2100 ACCESS TEST STUDY GUIDE In Datasheet view clicking a row selector selects an entire record Joined tables are separate tables but you can use the data in them as if they were one table A query is a question you ask about data stored in a database A one to many relationship exists between two tables when one record in the first table matches zero one or many records in the second table A field name A field that is defined in a table and that is also defined as a primary key in a different table is a n foriegn key A field or a combination of fields that has a unique value is a primary key A primary key uniquely identifies each record in a table A query can be run at any time during the creation of the query by clicking the View button in the Results group on the Query Tools Design tab A query defined in Access can Display selected fields and records from a table Sort records Perform calculations Generate data for forms reports and other queries Update data in the tables in a database Find and display data from two or more tables A relational database is a collection of of related tables A selection condition that dictates that the value in the specified field must precisely match the condition is known as a n exact match match A table can be logically connected to another table by defining a common field Certain Access data types have a predefined field property that cannot be changed Data from two or more tables can be connected by specifying a relationship Every foreign key must match the field value of a primary key in a related table Given a relationship between the two tables in the figure below in the Contract table shown the COMPANY field is a redundant field In the figure above the primary key is in the CUSTOMER table and the foreign key is in the CONTRACT table Martha would like to create a query that lists fields for members who joined the fitness center between June 1 and June 30 2010 What should her criterion in the Date Joined column look like for this query Between 6 1 2012 And 6 30 2010 Operators used in selection criteria in a query such as equal not equal or greater than are known as comparison operators or filters operators Parkhurst Health Fitness Center Martha Parkhurst needs to change a few records in the Fitness database and analyze the records for members enrolled in different programs at the fitness center The arrow labeled 1 indicates that Martha has chosen City as the company field Queries can be created by using the Query Wizard which prompts you for the information required to build the query Referential integrity is a feature built in to Access to prevent data inconsistency in related tables Selection criteria that are placed in different rows in the query design grid indicate an logical operator Statistical information such as totals and averages can be calculated in a query by using a n Aggregate function The data type determines what field values are allowed and what other properties the field will have The data type determines what type of values can be entered for a field The AND operator will cause a record to be selected only if two or more conditions are satisfied The characteristics of a field such as name size and type are called the field PROPERTIES The first step in organizing data into a database is to define the fields The order in which fields are displayed in a query depends on the order of the fields in the design grid To divide records into groups based on the values in a specified field you would use the Group By operator operator To find the TOTAL for the Monthly Fee column Martha should look in the above figure at the section labeled 4 To see the results of a query you must RUN it When defining a field the field size determines how much physical storage space the field requires When you define a query that performs a calculation you must add a new field When you use the number data type to define a field you should set the Field Size property based on the largest value you expect to store in that field Which of the following could be defined as a field in a database all of the above