Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Access Lesson 1-3
Test Review
| Question | Answer |
|---|---|
| If you were applying for a loan online and forgot to enter your address, you would receive an error message “you must enter a value.” The address field property was probably set as | required field |
| When viewing a table in Design view, the bottom half of the Table window is called the Field | properties |
| If you are entering data for customers and all of your customers live in Texas, you may want to enter Texas as the _____________ value property the the State field | default |
| If a row selector for an ID field has a(n) ____ symbol in it, it indicates that the field is the table’s primary key. | key |
| To create a database, start Access. On the ____ tab in Backstage view, click the template you want to use. | New |
| When you create a blank database, Access creates the first table in the database for you and names it ____. | table1 |
| A database is a collection of ____. | objects |
| If you make changes to the layout of a datasheet and try to close the table, Access will ____. | prompt you to save your changes |
| In ____, you can rearrange the order of the fields in a datasheet by dragging them to a new location. | datasheet view |
| In Datasheet view, the table displays its data in rows and columns in a ____. | datasheet |
| When you change the row height of a datasheet, the change ____. | affects all the rows |
| Access opens in ____ view. | backstage |
| ___ is a program known as a database management system (DBMS). | Access |
| When you open a query object, you ____ the query. | run |
| An easy method to change the way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the ____ group on the Home tab. | sort and filter |
| After applying any filter to a field, clicking the ____ button in the Sort & Filter group on the Home tab removes it and displays all records again | toggle filter |
| When you need to sort data first based on the values in one field, and then by the values in a second field, you can set the sort orders for the two fields using the ____ in the design grid. | sort boxes |
| You can run the query by clicking the Run button in the ____ group on the Query Tools Design tab. | results |
| In a one-to-many relationship, one record in the first table (called the ____ table) can match many records in the second table (called the related table). | primary |
| When you relate tables, Access uses a set of rules to ensure that there are matching values in the common field used to form the relationship. This set of rules is called ____. | referential integrity |
| The ____ symbol next to a field name in a field list indicates the table’s primary key. | key |
| The ____ operator selects records that match at least one of two or more conditions in a query. | or |
| The ____ operator selects records that match all of two or more conditions in a query. | and |
| Accepts field values containing letters, numbers, spaces, and certain symbols. | text |
| Stores long passages of text. | memo |
| Stores Yes/No, True/False, or On/Off values. | yes/no |
| Accepts monetary values and displays them with a dollar sign and decimal point. | currency |
| Stores dates, times, or a combination of both. | date/time |
| The data entered into a field. | field value |
| Used to identify the fields. | field name |
| Appears at the top of each column in a table and contains the field name. | field selector |
| Each record is made up of one or more of these. | fields |
| A complete set of data. | record |
| You can create a new table in a database by clicking the ____________________ tab on the Ribbon, and then clicking the Table button in the Tables group. | create |
| When you create a blank database, the table that Access creates for you contains one field named ID. Access sets the ID field as the table’s _____. | primary key |
| Sorting a field in ____________________ order arranges records from A to Z, or smallest to largest. | ascending |
| In _______________ view, you can add, delete, and make changes to the way that fields store data. | design |
| A(n) ____________________ is a collection of objects. | database |
| A(n) ____________________ is used to search for and retrieve data from tables using conditions. | query |
| To add a condition to a field, click in the field’s _____________ box, and then type the condition. | criteria |
| Data in the database is stored in a ______________ which is similar to a worksheet in Excel. | table |
| A combination of numbers and text is also called _______________ data. | alphanumeric |
| Sorting a field in __________________ order arranges from Z to A, or largest to smallest. | descending |
| If you were creating a query that matches a range of values, you would need to include a relational ____________ in the condition. Example of these are >, <, =, >=, <=, <> | operator |
| The ___________ property specifies how you want Access to display numbers, dates, times, and text. | format |
| When you enter a new record in the table, you do not need to type a value in the ID field if it has an ______________ data type for that field. | autonumber |
| The ______________ property specifies whether you must enter a field value in a record. | required |
| The ___________ property enters the same field value in a field every time a new record is added to the table. | default |
| Queries that are based on more than one table are referred to as ________. | multiple queries |
| To create a(n) ____________________ between two tables, you must design the tables so they contain a common field. | relationship |
| Each object in the navigation pane has a different ____________________ to identify its function. | icon |
| A field’s ____________________ determines the kind of data that you can enter in the field, such as numbers or text. | data type |
| A(n) ____________________ is a collection of objects. | database |
| Rows must all have the same height, however ________________ can have different widths. | columns |
Created by:
rweynand