Busy. Please wait.
or

show password
Forgot Password?

Don't have an account?  Sign up 
or

Username is available taken
show password

why


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

Remove Ads
Don't know
Know
remaining cards
Save
0:01
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

"Know" box contains:
Time elapsed:
Retries:
restart all cards




share
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

Access

CH 1: Introduction to Access

TermDefinition
Access A database management system included in the Microsoft Office 2013 Professional suite.
Ascending A sort that lists text data in alphabetical order or a numeric list in lower to highest order.
AutoNumber A number data type that is generated by Access and is incremented each time a record is added.
Back Up Database An Access utility that creates a duplicate copy of the database.
Comparison operator An operator used to evaluate the relationship between two quantities.
Criterion A number, text phrase, or an expression used to select records.
Custom Web app A database that can be built, used, and shared with others through the use of a host server (e.g., SharePoint or Office 365).
Database A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported.
Database management system (DBMS) A software system that provides the tools needed to create, maintain, and use a database.
Datasheet view A view that enables you to add, edit, and delete the records of a table.
Descending A sort that lists text data in reverse alphabetical order or a numeric list in highest to lowest order.
Design view A view that enables you to create tables, add and delete fields, and modify field properties; or to change advances design settings not seen in Layout view, such as a background image.
Enforce referential integrity A relationship option that ensures that data cannot be entered into a related table unless it first exists in a primary table.
Field The smallest data element in a table, such as first name, last name, address, or phone number.
Field property A characteristic of a field that determines how a field looks and behaves.
Field selector The column heading of a datasheet used to select a column.
Filter Displays a subset of records based on a specified criterion.
Filter by Form A filtering method that displays records based on multiple criteria.
Filter by Selection A filtering method that displays only records that match selected criteria.
Foreign key A field in one table that is also a primary key of another table.
Form A database object that is used to add, edit, or delete table data.
Join line A line used to create a relationship between two tables using a common field.
Macro A series of actions that can be programmed to automate tasks.
Module An object that is written using Visual Basic for Applications (VBA) and adds functionality to a database.
Navigation bar Bar located at the bottom of a table, query, or form that is used to move through records.
Navigation Pane An interface element that organizes and lists database objects.
Normalization The formal process of deciding which fields should be grouped together into which tables.
Object A main component that is created and used to make a database function.
Primary key The field (or combination of fields) that uniquely identifies each record in a table.
Query Enables you to ask questions about the data stored in a database and then provides the answers to the questions by providing subsets or summaries of data.
Record A group of related fields representing one entity, such as data for one person, place, event, or concept.
Record selector A small box at the beginning of a row used to select a record.
Relational database management system (RDBMS) A database management system that uses the relational model to manage groups of data (tables) and rules (relationships) between tables.
Relationship A connection between two tables using a common field.
Report An object that contains professional-looking formatted information from underlying tables or queries.
Sort The process of listing records or text in a specific sequence, such as alphabetically by last name.
Table An object used to store and organize data in a series of records (rows) with each record made up of a number of fields (columns) and is the foundation of every database.
Template A predesigned file that incorporates formatting elements, such as theme and layouts, and may include content that can be modified.
Which sequence represents the hierarchy of terms, from smallest to largest? Field, record, table, database
You edit several records in an Access table. When should you execute the Save command? Records are saved automatically; the save command is not required.
Which of the following is not true of an Access database? Every table in a database contains the same number of records as every other table.
Which of the following is true regarding the record selector box? An orange border surrounds the record selector box and the active record.
Which of the following will be accepted as valid during data entry? Entering numbers into a text field.
You have finished an Access assignment and wish to turn it in to your instructor for evaluation. As you prepare to transfer the file, you discover that it has grown more than double in size. You should: Compact and repair the database before sending it to your instructor.
Which of the following conditions is available through Filter by Selection? Equals condition.
An Employees table is open in Datasheet view. You want to sort the names alphabetically by last name and then by first name (i.e., Smith, Andrew). To do this, you must: First sort ascending on first name and then on last name.
Which of the following is not true when creating relationships between tables? The common fields used to create a relationship must both be primary keys.
All of the following statements are true about creating a database except: The objects provided in a template cannot be modified.
View that enables you to add, edit, and delete the records of a table. Datasheet view
An Access object that enables you to enter, modify or delete table data. Form
An Access utility that reduces the size of the database and can repair a corrupt database. Com[act and Repair.
A main component that is created and used to make a database function. Object
A filtering method that displays records based on multiple criteria. Filter by Form
A system that uses the relational model to manage groups of data (tables) and rules (relationships) between tables. Relational database management system (RDBMS)
A database that can be built, used, and shared with others through the use of a host server. Custom Web app
An object that contains professional-looking formatted information from underlying tables or quires. Report
An object used to store data, and the foundation of every database. Table
An Access utility that creates a duplicate copy of the database. Back Up Database.
A predefined database that includes professionally designed tables, forms, reports, and other objects. Template
A filtering method that displays only records that match selected criteria. Filter by Selection
A connection between two tables using a common field. Relationship
A method of listing records in a specific sequence. Sort
View that enables you to create tables, add and delete fields, and modify field properties. Design view
An Access interface element that organizes and lists the database objects in a database. Navigation Pane
A question you ask that can help you find and retrieve table data meeting conditions you specify. Query
The smallest data element in a table, such as first name, last name, address, or phone number. Field
Complete set of all the fields (data elements) about one person, place, event, or concept. Record
The field (or combination of fields) that uniquely identifies each record in a table. Primary key
Created by: TroyIS2241