Append | To add on to the end of an object; for example, to add records to the end of an existing table. |
AutoNumber Data type | A data type the describes a unique sequential or random number assigned by Access as each record is entered and that is useful for data that has no distinct field that can be considered unique. |
Best Fit | An Access commmand that adjusts the width of a column to accommodate the column's longest entry. |
Blank desktop Database | A database that has no data and has no database tools- you must create the data and the tools as you need them. |
Caption | A property setting that displays a name for a field in a table, query, form, or report other than that listed as the field name. |
Common Field | A field in one or more tables that stores the same data. |
Currency Data Type | An Access data type that describes monetary values and numeric data that can be used in mathematical calculations involving data with one to four decimal places. |
Data | Facts about people, events, things, or ideas. |
Data Source | The table or tables from which a form, query, or report retrieves its data. |
Data Type | The characteristic that defines the kind of data that can be entered into a field, such as numbers, text, or dates. |
Database | An organized collection of facts about people, events, things, or ideas related to a specific topic or purpose. |
Database Management System (DBMS) | Database software that controls how related collections of data are stored, organized, retrieved, and secured; also known as a DBMS. |
Database Template | A preformatted database designed for a specific purpose. |
Datasheet View | The Access view that displays data organized in columns and rows similar to an Excel worksheet. |
Design View | An Access view that displays the detailed structure of a query, form, or report; for forms and reports, may be the view in which some tasks must be performed, and only the controls, and not the data, display in this view. |
Destination Table | The table to which you import or append data. |
Field | A single piece of information that is stored in every record and formatted as a column in a database table. |
Field Properties | Characteristics of a field that control how the field displays and how data can be entered in the field. |
First Principle of Good Database Design | A principle of good database design stating that data is organized in tables so that there is no redundant data. |
Flat Database | A simple database file that is not related or linked to any other collection of data. |
Form | An Access object you can use to enter new records into a table, edit or delete existing records in a table, or display existing records. |
Form View | The Access tool that creates a form with a single mouse click, which includes all of the fields from the underlying data source. |
Import | The process of coying data from another file, such as a Word table or an Excel workbook, into a separate file, such as an Access database. |
Information | Data that is organized in a useful manner. |
Layout View | The Access view in which you can make changes to a form or report while the object is running - the data from the underlying data source displays. |
Link | A connection to data in another file. |
Multiple-Items Form | A form that enables you to display or enter multiple records in a table. |
Navigation Area | An area at the bottom of the Access window that indicates the number of records in the table and contains controls with which you can navigate among the records. |
Navigation Pane | An area of the Access window that displays and organizes the names of the objects in a database; from here, you open objects for use. |
Normalization | The process of applying design rules and principles to ensure that your database performs as expected. |
Object Window | An area of the Access window that displays open objects, such as tables, forms, queries, or reports; by default, each object displays on its own tab. |
Objects | The basic parts of a database that you create to store your data and to work with your data; for example, tables, forms ,queries, and reports. |
Populate | The action of filling a database table with records. |
Primary Key | The field that uniquely identifies a record in a table; for example, a Student ID number at a college. |
Query | A database object that retrieves specific data from one or more database objects- either tables or other queries- and then, in a single datasheet, displays only the data you specify. |
Record | All of the categories of data pertaining to one person, place, thing, event, or idea, and which is formatted as a row in a database table. |
Record Selector Bar | The bar at the left edge of a record when it is displayed in a form, and which is used to select an entire record. |
Record Selector Box | The small box at the left of the record in Datasheet view that, when clicked, selects the entire record. |
Redundant | In a database, information that is repeated in a manner that indicates poor database design. |
Relational Database | A sophisticated type of database that has multiple collections of data within the file that are related to one another. |
Report | A database object that summarizes the fields and records from a table or query in a easy-to-read format suitable for printing. |
Run | The process in which Access searches the records in the table included in the query design, finds the records that match the specified criteria, and then diplays the records in a datasheet; only the fields that have been included niter query design displays. |
Second Principle of Good Database Design | A principle stating that appropriate database techniques are used to ensure the accuracy of data entered into a table. |
Select Query | A type of Access query that retrieves data from one or more tables or queries, displaying the selected data in the datasheet; also know as a simple select query. |
Simple Select Query | Another name for a select query. |
Single-Record Form | A form that enables you to display or enter one record at a time in a table. |
Source File | When importing a file, refers to the file being imported. |
Structure | In Access, the underlying design of table, including field names, data types, descriptions, and field properties. |
Table | The database objects that stores data organized in an arrangement of columns and rows, and which is the foundation of an Access database. |
Tables and Related Views | An arrangement in the Navigation Pane that groups object by the table to which they are related. |
Truncated | Refers to data that is cut off or shortened. |
Wizard | A feature in Microsoft Office that walks you step by step through a process. |
Custom web app | a database that you can publish and share with others over the Internet |
DBMS | an acronym for database management system |
Export | the process of copying data from one file into another file, such as an Access table into an Excel spreadsheet |
Number data type | an Access data type that describes numbers that might be used in calculations |
Object tab | in the object window, a tab that identifies the object and which enables you to make the open object active |
Property Sheet | a list of characteristics-- properties-- for fields or controls on a form or report in which you can make precise changes to each property associated with the field or control |
Secure environment | a system that uses controlled servers to ensure the security and privacy of email, to control the storage and use of information and to protect against the loss of cofidential data |
Server | a computer that provides services on a network such as an email server or a file server |
SharePoint | a Microsoft application used for setting up websites to share and manage documents |
Short Text data type | an Access data type that describes text, a combination of text and numbers, or numbers that are not used in calculations, such as a Postal Code |
What can be used to display the structure of a table in Microsoft Access?
In the Navigation Pane, right-click the table that you want to explore, and then click Design View on the shortcut menu. As needed, note the name of each table field and the data type assigned to each field. The data type assigned to a field can limit the size and type of data that users can enter in a field.
Which view of a form gives a detailed structure of the form in MS Access?
Design view Design view gives you a more detailed view of the structure of the form. You can see the Header, Detail, and Footer sections for the form. You cannot see the underlying data while you are making design changes; however, there are certain tasks you can perform more easily in Design view than in Layout view.
What are the views in a table in Access?
The two most important views are: Datasheet View allows you to enter information into your database. It is in a table format similar to Excel. Design View allows you to setup and edit the fields of your database.
What is query Design view in Access?
Query Design View displays table schemes, along with their relationships, and allows the user to select columns to return (projection) and specify criteria for the returned data (selection).