Access 2013 Word Scramble
|
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
Question | Answer |
A(n)_____ is a single characteristic of a person,place,object event or idea. | field |
You connect the records in two separate tables through a(n) _______ that appears in both tables | common fields |
a field, or a collection of fields, whose values uniquely identify each record in a table. no two records can contain the same value for this field. | primary key |
The primary key, whose values uniquely identify each record in table is called a(n)______ when it is placed in a second table to form a relationship between two tables. | foreign key |
The ______ is the area of the Access window that list all the objects in a database, and it is the main control center for opening and working with database objects | Navigation Pane |
The new blank table that access created is displayed in _________ ______. | Datasheet view |
A set of field values | Record |
The specific value, or content, of a field is called the what? | field value |
A collection of fields that describe a person, place, object, event, or idea | table |
A software program that lets you create databases and then manipulate data in them. | Database management system |
In a __________ __________ _________ _________, data is organized as a collection of tables. | Relational database management system |
A predesigned database that includes professionally designed tables, reports, and other database objects that can make it quick and easy for you to create a database. | Template |
To Copy the records from a table in one database to another table in a different database, the two tables must have the same _______ | structure |
A(n) _________ is a question you ask about the data stored in a database | query |
The quickest way to create a form is to use the ________ | form tool |
Which view enables you to see the total number of pages in a report and navigate through the report page? | Print Preview |
In the Navigation pane, each database object has a unique _______ to its left that identifies the object's type. | Icon |
________ a database rearranges the data and objects in a database to decrease its file size and enhance the speed and performance of the database | Compacting |
________ a database is the process of making a copy of the database file to protect the database against loss or damage | Backing up |
What is the purpose of the Data Type property for a field? | it determines what field values you can enter for the field and what other properties the field will have |
The _____ property specifies how a field's name is displayed in database objects, including table and query datasheets, forms and reports? | caption property |
For which three types of fields can you assign a field size? | Text, number, and AutoNumber fields |
The default field size property setting for a short text field is? | 255 characters |
In Design view, which key do you press to move from the table design grid to the field properties pane? | f6 |
What is the keyboard shortcut for inserting the value from the same field in the previous record into the current record? | CTRL |
______ data is a process that allows you to copy the data from a source without having to open the source file. | Importing |
The _____ gallery allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually. | data type |
A(n) ____ text file is one in which fields of data are separated by a character such as a comma or tab. | Delimited |
The _____ is the "one" table in one-to-many relationship, and the ___ is the "many" table in the relationship | primary table,related |
____ is a set of rules that Access enforces to maintain consistency between related tables when you update data in a database. | Referential integrity |
insert or delete characters in a field value | database editing mode |
access selects an entire field value | database navigation mode |
Created by:
Rainmaker2123
Popular Computers sets