Getting Started
- Why use a database?
- What does a database consist of?
- Starting Access
- Opening and closing a database
- Opening and closing a table
- Viewing a table
- Editing and deleting data in a record
- Adding data in a table
- Deleting a record from a table
- Finding data
Basic Query
- What is a query?
- Opening and closing a query
- Designing a query
- Switching between design and datasheet
- Creating a query
- Adding and removing a table from a query
- Adding or deleting a field in a query
- Saving a query
Sorting in a Query
- Sorting data with visible fields
- Moving the fields in a query
- Adding all fields in a query
- Deleting all fields in a query
- Sorting data with hidden columns
- Quick sort
|
Query with Single Criteria
- Selecting the records in a query
- What is a value?
- Clearing a single criteria
- Using logical criteria
- Using wildcards in criteria
- Searching for no value
- Using criteria with hidden columns
- Quick filter
Reports
- Creating a report using a wizard
- Identifying sections and controls
- The toolbox/toolbar
- Selecting controls/sections
- Changing font/alignment
- Sizing a control /section
Forms
- Creating a form using a wizard
- Identifying sections and controls
- The toolbox/toolbar
- Selecting controls/sections
- Changing font/alignment
- Using Forms to enter data and filter
|