Unformatted text preview:

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

TCC CGS 2100 - STUDY GUIDE

Download STUDY GUIDE
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view STUDY GUIDE and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view STUDY GUIDE 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?