Info. Man.: Terminologies, Data Names, and definition Classification of Attributes
StudentDatabase.mdb (Access 2003) or StudentDatabase.accdb (Access 2007).
Example of Database File
Names
Example of atomic attribute
Address, Birthday
Example of composite attribute
age can be derived from birth date of student.
Example of derived attribute
every student has unique student no
Example of key attribute
Phone numbers
Example of multi-valued attribute
there may be chance when a student has no phone no.
Example of null valued attribute
Age, Birth date
Example of single-valued attribute
birth date cannot derive from age of student.
Example of stored attribute
tables, queries, forms, and reports.
Examples of database objects
Datasheet view. Pivot Table view. Pivot Chart view. Design view.
Four Views of Table: - _________ view used to create a table, edit data, or view data. - _______________ view used to create a pivot table. - ________________ view used to create a pivot chart. - _________ view used to create a table or modify an existing table.
Modules
Like macros, these give you the ability to automate tasks and add functionality to a form, report, or control.
list of macro actions, Visual Basic for Applications
Macros are created by choosing from a ______________________________, whereas modules are written in ___________________.
Relational Databases
Many tables that are linked through common fields and can ensure greater accuracy and less input of data. These increase flexibility of data and allow ease of collecting and maintaining historical data.
Relationships
Relational databases are databases in which common fields of information join tables. They are classified as one-to-one and one-to-many.
Database
Tables comprise the __________.
Relate to business, not technical characteristics. Meaningful, must be to the point. Unique. Readable. Composed of words taken from an approved list. Repeatable meaning that different people or the same person at different times should develop exactly or almost the same name.
What are the general guidelines about naming any data object?
tables, queries, forms, reports, macros, and modules.
What does an Access database consists of?
Use an existing database.
You may use recently opened or created databases on your computer to work with.
Use a blank database.
You must save an Access database before you start working with it.
Fields
__________ comprise the records.
Records
__________ comprise the tables.
Atomic Attribute
An attribute that cannot be divided into smaller independent attribute.
Single-Valued Attribute
An attribute that has only single value for an entity.
Key Attribute
An attribute that has unique value of each entity
Null Valued Attribute
An attribute which has not any value for an entity
attributes
An entity may have many ____________.
named, defined
Data objects must be ______ and _________ before they can be used unmistakably in a model of organizational data.
single category of data.
- Each value in a field represents a ______________________.
Text /ShortText., 255. Memo/Long text, 64,000. Number. Date/Time. Currency. AutoNumber. Yes/No. Hyperlink. Attachment. OLE Object.
10 Data Types o _______________________________________- Alphanumeric data. Use for text and for numbers that are not used in mathematical calculations. Use for names, addresses, and other relatively short pieces of text. It can store up to ______ characters. o ________________________________. Use for long pieces of text, such as notes and long descriptions. It can store up to ________characters. o _________- Numeric data. Use for numbers you want to use in mathematical calculations. If you are working with currency, use the currency type. o __________- is use for dates and times. o __________- is use for currency. It prevents rounding during calculation. o _______________- unique sequential numbers or random numbers automatically inserted when you create a record. Use to create a primary key. o ________ - logical data. It is use when only one of two values are valid. o _________- is used to store hyperlinks. o __________- is used to store attachments. o ______________ - is
Use one of the templates provided.
Access automatically creates forms, reports, and other objects that you can use. You can modify these objects to suit your needs.
subject
All of the data in a table should refer to the same _______.
Derived Attribute
An attribute that can be derived from another attribute
Composite Attribute
An attribute that can be divided into smaller independent attribute.
Multi-Valued Attribute
An attribute that can have multiple values for an entity.
Stored Attribute
An attribute that cannot be derived from another attribute
255
Default field size for the text type
same
Each field must be given a name and no two fields can have the _________ name.
tables, queries, forms, reports
In Access, _________ are used to store data, __________ to retrieve data, ________ to enter data, and __________ to display data.
One-to-Many relationships
It allows one record in one table and many records in another table.
Database
It can be one, stand-alone table that can contain many fields of information. This is the simplest, yet least powerful type of database and is often referred to as a *"flat"* database.
Table (Entity Type)
It contains or holds the data. It limits the types of data in fields and can assist in integrity and accuracy of data. Generally, they do not perform calculations and are simply data collectors for input or other means of acquiring data.
Input masks
It controls the value of a record and sets it in a specific format.
Datasheet
It displays the information stored in a table in columns and rows
Title Bar
It displays the name of the database on which you are currently working.
one-to-one relationship
It ensures that one record in one table has a (and only one) matching record in another table.
Macros
It gives you the ability to automate tasks. You can use it to add functionality to a form, report, or control.
Forms
It gives you the ability to choose the format and arrangement of fields. You can use it to enter, edit, and display data.
Record (values)
It is a ROW on a datasheet and is a set of values defined by fields.
Record
It is a collection of fields for an item you are tracking. For example, a __________ consists of all the fields for a person if you are tracking associates in a company. In addition, it is a single row which consists of multiple fields.
Table
It is a collection of related data about a specific topic (entity) that are organized in fields (column) and records (rows) on a datasheet.
Primary key
It is a field or combination of fields that uniquely identify each record in a table.
Microsoft Access
It is a powerful database software package or program that can be used to create and manage databases.
Tables
It is a set of columns and rows, with each column referred to as a field.
Field
It is the lowest level of data in a database. It consist of information about the item you are tracking.
Database File
It is the main file that encompasses the entire database.
Microsoft Office Button
It is used to create a new database, open and save a database, and many other tasks.
Ribbon
It is used to issue commands
Reports
It is used to organize or summarize your data so you can print it or view it onscreen. You often use these when you want to analyze your data or present your data to others.
Queries
It is used to to retrieve specific data from your database and to answer questions about your data.
Quick Access Toolbar
It provides access to commands you frequently use. By default, Save, Undo, and Redo appear on the ____________________________________.
Data Domain
It refers to all the valid values which a data element (column) may contain.
Views
These are different ways of looking at the same object.
Fields
These are the different characteristics (attributes) within a Table. Tables usually contain multiple of these. It is a COLUMN on a datasheet and defines the data type for a set of values in a table.
Attributes
They are characteristics of an entity
Entities
They are represented by means of their properties, called ATTRIBUTES.
Attribute (Fields)
They are the different characteristics within a Table.
Data types
They are the properties of each field. A field only has *ONE data type.*
Database Objects
They provide functionality and power to your database information. However, access is not appropriate for large databases, but is terrific for small and medium size databases with limited users.
ID
This column name is by default the primary key field
Double-click. Right click. tabs.
·_____________ an object to open the object. · ______________ an object to view a menu of options that you can use to open, rename or delete the object. · Objects that are open appear on _______. Right-click a tab to view a menu of options that you can use to save the object, close the object, or change the view.