About this lesson
An introduction to Microsoft Access.
Download this lesson’s exercise file.Services_01_Welcome to Access.accdb
Welcome to Access
An Access Database is a container for other objects such as:
- Tables & Relationships
An Access database is used to organize and manage information.
A thing. In Access, this will often mean a table, query, form, or report.
Use a table to store data. Tables are lists of structured information
Use a relationship to define how two tables connect to each other.
Use a query to show and edit, sort and filter, data from one or more tables.
Use a form to enter information into tables with ability to format and automate.
Use a report to print or view information on the screen with formatting, sorting, and grouping.
Macros and Modules
Use macros and modules (containing subs and functions) to automate an application.
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.
AutoNumbers get new values automatically and are numbers normally hidden from users. They are excellent choices to use for Primary Keys.
Criteria is the rule or rules for filtering data.
The process of planning, and the result of the plan.
A field describes a particular piece of information in a table. Each field has a data type which defines if the data will be text, numbers, a date, or something else.
Formatting refers to specifying appearance by setting color, size, font, and other properties.
Filtering data means limiting how much information you see it by particular criteria such as only information for services of a particular type.
Grouping means breaking your data at logical places, such as when the year of a date changes, usually to calculate subtotals and other statistics.
The Navigation Pane is an area that enables you to view and manage objects in your database.
The collection of information about an object describing things such as appearance and behavior.
The Primary Key of a table is a field, or combination of fields, that is unique on every record.
A row of information in a table is called a record.
The Record Selector is a box to the left of the record where you can click to select a record.
Sorting is ordering information in a particular way, such as alphabetically or numerically.
An organized design.
Lesson notes are only available for subscribers.