Access Chapter 1 – Flashcards

Unlock all answers in this set

Unlock answers
question
Database
answer
A collection of data organized in a manner that allows access, retrieval, and use of that data.
question
Database management system
answer
Software that allows you to use a computer to create a database and preform other function with the database.
question
Database management system
answer
Allows you to edit, ask and answer questions about, and create forms and reports using the data in the database.
question
Relational database
answer
A database consisting of a collection of tables, each of which contains information on a specific subject.
question
Records
answer
Contains information about a given person, product, or event.
question
Field
answer
Contains a specific piece of information within a record.
question
Unique identifier
answer
A field used to uniquely identify each record in the database.
question
Database design
answer
The arrangement of data into tables and fields in a database.
question
Redundancy
answer
The storing of a piece of data in more than one place in a database.
question
?, ", /, , :, *, |, >, <
answer
These characters cannot be used in a file name.
question
Reserved words
answer
Words that have a special meaning to Access, and cannot be used as field names.
question
64
answer
Maximum number of characters in a table and field name.
question
., !, ', [, ]
answer
These characters cannot be used when naming fields or tables.
question
Fields
answer
The same name cannot be used for two different ____ in the same table.
question
Data type
answer
Indicates the type of data that can be stored in the field.
question
Text, Number, Currency
answer
Three of the most commonly used data types
question
Text
answer
The data type in which the field can contain any characters, a maximum of 255.
question
Number
answer
The data type in which the field can contain only numbers, positive or negative, usually used for arithmetic operations.
question
Currency
answer
The data type in which the field can contain only monetary data, in which values appear with currency symbols and with two digits following the decimal point.
question
Blank
answer
If you already know the tables and fields you want in your database, you would use this database option.
question
template
answer
If you do not already know the tables and fields you want in your database, you would use a ____.
question
Access window
answer
This consists of a variety of components to make your work more efficient and documents more professional.
question
Access Window
answer
Consists of the Navigation Pane, Access work area, Ribbon, shortcut menus, and Quick Access toolbar.
question
Access work area
answer
Where you work on objects such as tables, forms, and reports
question
Object tabs
answer
Appears at the top of the Access work area to indicate objects that are open.
question
Navigation Pane
answer
Contains a list of all the objects in the database, used to open an object, you can customize the display of objects.
question
Status bar
answer
Located at the bottom of the Access window, presents information about the database object, the progress of current tasks, the status for certain commands and keys, and viewing options.
question
Primary key
answer
To create a table, you must describe all of the fields that make up the table and their characteristics, and indicate the ____ ____.
question
Datasheet view and Design view
answer
The two views that you can use to create a table in Access.
question
Datasheet view
answer
The view in which the data in the table is presented in rows and columns, like a spreadsheet, used to update data and modify the structure of the table.
question
Design view
answer
The view that is only used to create a table or modify its structure.
question
Design view
answer
Out of datasheet view and design view, which one has more functionality for creating a table?
question
Click to Add
answer
To define an additional field, click this column heading to select the data type and enter the field name.
question
Dim
answer
If there is nothing to undo in Access, the Undo button on the Quick Access toolbar will be this.
question
right-click
answer
Do this to the column heading to get a shortcut menu to delete the column or change the name.
question
Insert Field
answer
To insert a field between existing fields, right-click the column heading for the field that will follow the new field and click this on the shortcut menu
question
drag
answer
To move a field, click the column heading and then do this.
question
Create
answer
Click this on the ribbon and then click the Table button to create a table.
question
Shutter Bar
answer
Click the _______ ______ Open/Close Button to close the Navigation Pane.
question
right-click
answer
Do this to the table in Navigation Pane that you wish to open and then select the desired view in which you wish to view it.
question
Backspace
answer
If you make a mistake when typing, correct it by pressing this key.
question
Primary key
answer
Access will reposition new records(table rows) automatically based on this.
question
Record
answer
A row in a table.
question
Delete
answer
To delete a record, click the record selector and press this key.
question
screen
answer
To change the contents of one or more fields in a record, the record must be on the _____.
question
INSERT
answer
You can use this key to switch between Insert and Overtype mode while editing fields in records.
question
stuck
answer
When you are "this" on the record, Access neither allows you to move to another record nor allows you to close the table until you have made the correction.
question
ESC
answer
To remove from the screen the record you are trying to add if you get "stuck", press this key.
question
Green computing
answer
This involves reducing the environmental waste generated when using a computer.
question
Portrait orientation
answer
The orientation in which the printout is across the width of the page.
question
Landscape orientation
answer
The orientation in which the printout is across the height of the page.(sideways)
question
list
answer
The form that data is stored in in which the first row contains column headings describing the data in each of the columns, and the remaining rows contain the data.
question
Import
answer
To make a copy of data from another source in a table in the Access database.
question
Table
answer
When importing data, you have two choices: create a new ____, or add the records to an existing _____. (Same word)
question
wizard
answer
The process of importing into an Access database uses this, which takes you through basic steps.
question
Import Spreadsheet
answer
If the data is imported from an Excel worksheet, the process will use the _____ ______ Wizard.
question
External Data
answer
To import an Excel worksheet, click this on the Ribbon and then click the Excel button.
question
Queries
answer
Simple questions, the answers to which are in the database.
question
Simple Query
answer
When you are creating a query, if there are no restriction involved in the query, you can use the ____ ______ Wizard.
question
Query Wizard
answer
To create a query, select the appropriate table in the Navigation Pane, click Create on the Ribbon, and then click the ______ _____ button to display the New Query dialog box.
question
Recovery
answer
The process in which invalid data in the database is returned to a correct state.
question
backup copy
answer
The copy of data created while backing up a data base.
question
Backing up
answer
The simplest approach to the recovery process, involving periodically making a copy of the database.
question
live database
answer
If a problem occurs while backing up a database, you can correct the problem by copying this backup copy over the actual database, called this.
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New