| AB | |
| To include on to the end of one object; because that example, to include records come the end of an existing table. You are watching: Data that is organized in a useful manner is: | |
| AutoNumber Data type | A data kind the explains a distinct sequential or arbitrarily number assigned by access as each document is entered and also that is valuable for data that has actually no distinct field that deserve to be considered unique. |
| Best Fit | An accessibility commmand that adjusts the width of a pillar to accommodate the column's longest entry. |
| Blank desktop computer Database | A database that has actually no data and also has no database tools- friend must produce the data and also the devices as you need them. |
| Caption | A property setting that screens a name for a field in a table, query, form, or report other than that detailed as the ar name. |
| Common Field | A field in one or an ext tables the stores the same data. |
| Currency Data Type | An access data kind that defines monetary values and also numeric data that deserve to be provided in math calculations including data through one to four decimal places. |
| Data | Facts about people, events, things, or ideas. |
| Data Source | The table or tables indigenous which a form, query, or report retrieves its data. |
| Data Type | The characteristic that specifies the kind of data that have the right to be entered into a field, such as numbers, text, or dates. |
| Database | An organized collection that facts around people, events, things, or principles related come a particular topic or purpose. |
| Database monitoring System (DBMS) | Database software application that controls exactly how related collections of data space stored, organized, retrieved, and also secured; additionally known as a DBMS. |
| Database Template | A preformatted database designed because that a details purpose. |
| Datasheet View | The accessibility view that display screens data arranged in columns and also rows similar to an Excel worksheet. |
| Design View | An accessibility view that displays the in-depth structure that a query, form, or report; because that forms and reports, might be the check out in i m sorry some work must it is in performed, and only the controls, and also not the data, screen in this view. |
| Destination Table | The table to which you import or append data. |
| Field | A solitary piece of info that is save in every record and also formatted as a pillar in a database table. |
| Field Properties | Characteristics the a ar that manage how the field displays and also how data have the right to be gotten in in the field. |
| First principle of great Database Design | A rule of an excellent database style stating the data is arranged in tables so the there is no redundant data. |
| Flat Database | A simple database record that is not associated or linked to any type of other arsenal of data. |
| Form | An access object you deserve to use come enter brand-new records into a table, modify or delete existing documents in a table, or display screen existing records. |
| Form View | The accessibility tool that creates a kind with a single mouse click, which includes every one of the fields from the underlying data source. |
| Import | The procedure of coying data from another file, such together a native table or one Excel workbook, right into a different file, such together an accessibility database. |
| Information | Data that is arranged in a beneficial manner. |
| Layout View | The accessibility view in which you can make transforms to a form or report while the thing is to run - the data from the underlying data source displays. |
| Link | A link to data in another file. |
| Multiple-Items Form | A type that permits you to display or enter multiple documents in a table. |
| Navigation Area | An area in ~ the bottom the the Access home window that suggests the number of records in the table and contains controls through which you can navigate amongst the records. |
| Navigation Pane | An area of the Access home window that displays and organizes the name of the objects in a database; native here, you open up objects for use. |
| Normalization | The procedure of using design rules and also principles come ensure that your database performs together expected. |
| Object Window | An area of the Access home window that screens open objects, such together tables, forms, queries, or reports; by default, every object display screens on its own tab. |
| Objects | The simple parts the a database the you produce to store your data and also to job-related with your data; because that example, tables, creates ,queries, and reports. |
| Populate | The activity of pour it until it is full a database table v records. |
| Primary Key | The ar that unique identifies a record in a table; because that example, a student ID number at a college. |
| Query | A database object the retrieves details data from one or much more database objects- one of two people tables or other queries- and also then, in a solitary datasheet, screens only the data you specify. |
| Record | All the the category 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 leaf of a record as soon as it is presented in a form, and which is used to select an entire record. |
| Record Selector Box | The little box in ~ the left the the document in Datasheet see that, when clicked, selects the whole record. |
| Redundant | In a database, details that is repetitive in a manner the indicates poor database design. |
| Relational Database | A sophisticated kind of database that has actually multiple collections of data in ~ the document that are regarded one another. |
| Report | A database object that summarizes the fields and also records native a table or questions in a easy-to-read format perfect for printing. |
| Run | The procedure in which accessibility searches the records in the table included in the query design, find the records that enhance the stated criteria, and then diplays the records in a datasheet; only the fields that have actually been had niter query style displays. |
| Second rule of an excellent Database Design | A principle stating that proper database approaches are used to for sure the accuracy of data gotten in into a table. |
| Select Query | A type of accessibility query that retrieves data indigenous one or more tables or queries, displaying the selected data in the datasheet; likewise know as a simple select query. |
| Simple pick Query | Another surname for a choose query. |
| Single-Record Form | A form that allows you to screen or enter one document 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 arranged in an arrangement of columns and also rows, and also which is the structure of an access database. |
| Tables and Related Views | An setup in the navigating Pane that groups object by the table come which they space related. |
| Truncated | Refers to data the is cut off or shortened. See more: How Much Is A 48 Star Flag Worth, 48 Star Flag |
| Wizard | A feature in Microsoft Office that walks you step by action through a process. |
| Custom internet app | a database the you deserve to publish and also share through others over the Internet |
| DBMS | an acronym because that database administration system |
| Export | the process of copy data native one paper into one more file, such as an accessibility table right into an Excel spreadsheet |
| Number data type | an accessibility data kind that explains numbers that could be provided in calculations |
| Object tab | in the object window, a tab the identifies the object and which allows you to do the open up object active |
| Property Sheet | a list of characteristics-- properties-- for fields or controls on a type or report in i beg your pardon you deserve to make precise changes to every property linked with the ar or control |
| Secure environment | a mechanism that uses controlled servers to ensure the security and also privacy of email, to regulate the storage and use that information and to protect versus the loss of cofidential data |
| Server | a computer system that gives services ~ above a network together as an email server or a paper server |
| SharePoint | a Microsoft application used for setup up websites come share and also manage documents |
| Short message data type | an accessibility data form that describes text, a combination of text and also numbers, or number that space not offered in calculations, such together a Postal Code |
 |