| TermDefinition Common Field A field in one or more tables that stores the same data. Data Facts about people, events, things, or ideas. Database An organized collection of facts about people, events, things, or ideas related to a specific topic.; an organized collection of data Field A single piece of information that is stored in every record and represented by a column in a table. First Principle of Good Database Design eliminate redundant data; A principle stating that data is organized in tables so that there is no redundant data. Flat Database A simple data base file that is not related or linked to any other collection of data. Information Data that is organized in a useful manner. Navigation Pane The window area that organizes the data base objects and from which you open objects. Normalization The process of applying design rules and principles to ensure that a data base performs as expected. Object Window The window area that displays each open object on its own tab. Objects The basic parts of a database; for example tables, queries, forms, and reports. Populate The action of filling a data base with records. Record A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea. Second Principle of Good Database Design Employ techniques to ensure accuracy; A principle stating that techniques are used to ensure the accuracy of data entered into a table. Table The database object that stores the data and is the foundation of an access database. File A collection of information stored under a single name. Folder A container where files can be stored. Window A rectangular area on the computer screen. Desktop Opening screen in Windows that simulates a work area. Footer Displays at the bottom of each page of the document. Header Displays at the top of each page of the document Zoom Increase or decrease the viewing area Portrait Orientation Paper is taller than it is wide. Landscape Orientation Paper is wider than it is tall. File Tab Displays Backstage view Group Related commands on the ribbon. Window Control Buttons Minimize, Restore Down, Close Quick Access Toolbar Buttons to perform frequently used commands Ribbon Task-oriented tabs Fill the inside color of an object Option Button Allows the user to make one choice from two or more options. Gallery Office feature that displays a list of potential results. Screen Tip Displays useful information about mouse actions. Gradient fill one color fades into another. Point 1/72 of an inch Font styles Bold, italic, underline toggle button turns a feature on and off format painter allows for the copying of the formatting of a selected text clipboard temporary storage area that holds items that have been cut or copied command an instruction to a computer program scroll bar displays in a window that has information not visable point move the mouse pointer over something click press the left mouse button scroll box the box within a scroll bar pt. abbreviation for point when referring to font size font set of characters with the same design and shape sans serif font a font design with no lines or extensions on the ends of characters serif font a font design that includes lines or extensions on the ends of characters theme pre-designed set of colors, fonts, lines, and fills Query used to ask a question select query used to create subsets of data that you can use to answer specified questions data source table or tables from which you select fields for a query run finds and displays the records that match criteria in a query wizard walks you step by step through a process relational database multiple collections of data are related to one another DBMS microsoft access, for example database template a pre-formated database designed for specific purposes Form View a way to view the records in a form, but not change the form's layout or design Layout view a way to make changes to a form or to a report while seeing the data design view a way to view a table's structure datasheet view a way to view all the records in a table Access provides six database objects that, when combined, help you take full advantage of your data. Learn the role that each object plays. Show TablesAccess organizes your information into tables: lists of rows and columns reminiscent of an accountant’s pad or a spreadsheet. Each table stores information about a specific subject, so most databases include more than one table.  Each row in the table is called a record, and each column is called a field. A record contains all the specific information for a particular entity, such as a customer or an order. A field is a single item of information about that entity. In the Products table, for instance, each row or record would hold information about one product. Each column or field holds some type of information about that product, such as its name or price. If you aren’t already familiar with them, learn the basics of databases. QueriesIn a well-designed database, the data that you want to present through a form or report is usually located in multiple tables. You use a query to pull that information from various tables and to assemble it for display in a form or report. A query can be a request for data results from your database, or it can be used to perform an action on the data, or it might be both. Use queries to get answers to simple questions, perform calculations using data, combine data from different tables, and add, change, or delete data from a database. There are many types of queries, but the two basic types are: Major query types Use Select To retrieve data from a table or make calculations. Action Add, change, or delete data. Each task has a specific type of action query. Action queries are not available in Access web apps. FormsForms are like display cases in stores—they make it easier to view or get to the database items you want. Similar to paper forms, Access forms are objects through which you or other users can add, edit, or display the data stored in your Access desktop database. It’s important to design your form with use in mind. For example, if it’s for multiple users, a well-designed form helps to make data entry accurate, fast, and efficient. ReportsReports offer a way to view, format, and summarize information from your Access database. For example, create a simple report of phone numbers for all your contacts or a summary report on the total sales across different regions and time periods. Reports are handy when you want to present the information in your database to:
MacrosA macro is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls. For example, if you add a command button to a form and associate the button's OnClick event to a macro, it then performs a command each time the button is clicked. Access provides a design environment to help you create macros. Essentially, you use a simplified programming language to build a list of actions to perform. Some actions require additional information, like which field to display fill in. The design environment makes it easier to create macros, as you select from lists of actions and fill in information. Macros are used to automate a series of actions, make changes to data in a database, and more. Through the Design view, macros provide a subset of the commands that are available in Visual Basic for Applications (VBA). Most people find it easier to build a macro to add functionality to forms, reports, and controls than to write VBA code, but you can always convert the macros to VBA from within the Design view. Suppose that you want to open a report directly from one of your data entry forms. Add a button to your form and then create a macro that opens the report. The macro can either be a standalone macro (a separate object in the database), which is then bound to the OnClick event of the button, or the macro can be embedded directly into the OnClick event of the button itself. Either way, when you click the button, the macro runs and opens the report. ModulesModules are VBA code that you write to automate tasks in your application and to perform higher end functions. You write modules in the VBA programming language. A module is a collection of declarations, statements, and procedures that are stored together as a unit. What is a single piece of information in a table called?Keys. Fields that are part of a table relationship are called keys. A key usually consists of one field, but may consist of more than one field.
Is a single piece of information that is stored in every record?Glossary. What type of database is a collection of data that is not related to any other collection of data?A non-relational database is a database that does not use the tabular schema of rows and columns found in most traditional database systems. Instead, non-relational databases use a storage model that is optimized for the specific requirements of the type of data being stored.
What is a field in one or more tables that stores the same data?Common field. A field in one or more tables that stores the same data. Objects. The basic parts of a database; for example tables, forms, queries, and reports.
|
