Access 2007 Tutorial 5.4. Inserting into multiple fields using a Combo box and NotInList Event
You can work along with this file:
database-with-forms.accdb
Code can be found at the end of the post.
In this video:
- On Not In List event
- Variables & Constants
- msgbox()
- if-else statement
- Arrays
- Split()
- DoCMD.RunSQL
- UBound()
- Remaining Issues
When I teach my Access course, I often get students who feel that entering information into the database should be easier than it is, even with forms. Well, we can make it easier, but it usually requires some programming to do some work on behalf of the user. The more work we do, the less work the user has to do.
Excel 2007 Tutorial 4.1. Pie, Column, and Line Charts
In this video, Excel 2007 Tutorial 4.1. Pie, Column, and Line Charts
- Pie Charts
- Data Labels & Leader Lines
- Chart Titles & Styles
- Column Charts
- Clustered vs. Stacked Charts
- Line Charts
- Select Data
- Format Axis
- Insert Shapes
You can work along with this file:
charts.xls
The data in this video was sourced from Netcraft.com and Wikipedia.org.
Excel 2007 Tutorial 3.2. Absolute and Mixed Cell References
In this video, Excel 2007 Tutorial 3.2. Absolute and Mixed Cell References
- Relative Cell References
- Absolute Cell References
- Mixed Cell References
Work along with this file:
references.xls
Excel 2007 Tutorial 3.1. Using Functions
In this video, Excel 2007 Tutorial 3.1. Using Functions
- Autosum Icon
- Sum, Average, Count, Max, Min
- Abs, Now Functions
- Insert Function Icon
- Pmt Function
- Order of Operations
- Using Functions inside Functions
Excel 2007 Tutorial 2.1. Formatting Spreadsheets
In this video, Excel 2007 Tutorial 2.1. Formatting Spreadsheets:
- Text vs. Numbers
- Currency vs. Accounting Format
- Resizing and Merging Cells
- Conditional Formatting
- Clear Formatting
File used in this video: textbooks.xls
Excel 2007 Tutorial 1.1. Calculating your GPA
In this video, Excel 2007 Tutorial 1.1. Calculating your GPA:
- Introduction to Excel
- Formulas
- Functions
- Copy and Pasting Formulas
- Fill Handle
- Manipulating Worksheets
File used in this video: gpa.xls