CGS2100 ACCESS TEST STUDY GUIDEIn 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
View Full Document