Filteringįiltering data means limiting how much information you see it by particular criteria such as only information for services of a particular type. Formattingįormatting refers to specifying appearance by setting color, size, font, and other properties. Each field has a data type which defines if the data will be text, numbers, a date, or something else. FieldĪ field describes a particular piece of information in a table. The process of planning, and the result of the plan. CriteriaĬriteria is the rule or rules for filtering data. They are excellent choices to use for Primary Keys. AutoNumberĪutoNumbers get new values automatically and are numbers normally hidden from users. To automate a process with Access is to implement the logic to do a routine task such as close a form or store the date and time that a record was edited. Use macros and modules (containing subs and functions) to automate an application. Use a report to print or view information on the screen with formatting, sorting, and grouping. Use a form to enter information into tables with ability to format and automate. Use a query to show and edit, sort and filter, data from one or more tables. Use a relationship to define how two tables connect to each other. Tables are lists of structured information Relationship In Access, this will often mean a table, query, form, or report. ![]() Welcome to Access Application Terminology Access DatabaseĪn Access Database is a container for other objects such as:Īn Access database is used to organize and manage information.
0 Comments
Leave a Reply. |