CIT201 DB Module 1 Terms
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
database | Collection of data organized in a manner that allows for access, retrieval, and use of that data.
🗑
|
||||
database management system | Software that allows you to use a computer to create a database; add, change, and delete data in the db; ask and answer questions; and create forms and reports using the data.
🗑
|
||||
relational database | Database containing a collection of tables, each of which contains information on a specific subject, but are related.
🗑
|
||||
records | Rows in db table. Contain information on a given person, product, or event.
🗑
|
||||
fields | The columns in the table. Contains a specific piece of information within a record.
🗑
|
||||
unique identifier | Way of uniquely identifying each record in the db. Also called a primary key.
🗑
|
||||
autonumber field | Primary key created automatically by Access. Starts with 1, next 2, and so on.
🗑
|
||||
data type | Type of data that can be stored in the field. Examples: Short text, Number, etc.
🗑
|
||||
short text | Data type that can contain any characters up to 255 characters.
🗑
|
||||
number | Data type that can contain any positive or negative number and can be used in arithmetic calculations.
🗑
|
||||
currency | Data type can only contain monetary data and will appear with currency symbols. Can be used in arithmetic calculations.
🗑
|
||||
date and time | Data type can contain dates and/or times.
🗑
|
||||
long text | Data type can contain any characters over 255 characters.
🗑
|
||||
autonumber | Data type can store unique sequential number that Access assigns to record. Increments by 1.
🗑
|
||||
yes/no | Data type can store 1 of 2 values. Yes/No, On/Off, True/False
🗑
|
||||
OLE object | Data type can store OLE object which is object link to or embedded in the table.
🗑
|
||||
Hyperlink | Data type can store text that can be used as Hyperlink address.
🗑
|
||||
Attachment | Data type can contain an attached file.
🗑
|
||||
Calculated | Data type specifying a calculation based on other fields. Value is not actually stored.
🗑
|
||||
caption | Allows you to display caption instead of actual field name when creating a db table.
🗑
|
||||
Portrait orientation | printout will be across the width of the page
🗑
|
||||
Landscape orientation | printout will be across the height of the page
🗑
|
||||
import | Make a copy of the data as a table in the Access db.
🗑
|
||||
queries | Questions that can be answered using the data stored in a db.
🗑
|
||||
database properties | Details about a db that helps you organize and identify the db. Also known as metadata. Include such information as the author, title, or subject.
🗑
|
||||
Keywords | Words or phrases that further describe the db such as a class name or db topic
🗑
|
||||
Standard Properties | Associated with all Microsoft documents and include author, title, and subject.
🗑
|
||||
Automatically Updated Properties | Include file system properties and include the date you create or modify a file, the file size, etc.
🗑
|
||||
Recover | Process of returning a damaged db to a correct state.
🗑
|
||||
Backup Copy | Important to backup the db so you may recover if damaged. Makes a copy of the db.
🗑
|
||||
Live db | Database currently working on.
🗑
|
||||
Database Design | Process of determining the tables and fields that make up the db.
🗑
|
||||
Redundancy | Storing the same fact in more than one place. Try to avoid this while creating db tables.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
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
Created by:
Leisac
Popular Computers sets