Skip to content
Archive of posts filed under the Uncategorized category.

Call me now!

How to Move Your Business to Cloud Computing Make your workflow easier and more efficient with web-based computing.

Check out this well-written article on ‘cloud computing’ to learn of more tools and improvements made every day. MS Office may be the de facto workplace standard, but many options exist to allow users freedom and flexibility.

19 March – first plantings into garden

We dried out several raised beds and rows by covering them with plastic about 10 days ago.  Definitely made a difference, as all were quite workable by today.
Transplanted-planted 8 day old (3 inches high) peas along the fence again.  Also trans-planted tiny chard, beets, salad lettuces, some cabbage, etc.  Planted spinach seeds and onion sets, [...]

Access 2007 Intermediate – Files

usafc141b

Lesson 1

Import

as-Flower Pot Customers.txt

 

as-Flower Pot.xlsx

 

ca-Customers.xlsx

 

ca-Orders.xlsx

 

ca-Products.xlsx

 

ca-Suppliers.xlsx

 

ct-Rich Homestead.accdb

 

sb-Valley Hospital Nurse Schedule.accdb

 

TechCache Rel.accdb

 

Utility Bill.pdf

 

Lesson 2

 

as-First Perk Queries.accdb

 

ca-Scents To You Inc.accdb

 

ct-TC Queries.accdb

 

sb-Valley Hospital Nurse Queries.accdb

 

TechCache Queries.accdb

 

Lesson 3

 

as-Lagniappe Cruises Forms.accdb

Art    

as-Lagniappe Cruises Logo.gif

 

ca-Big Screen Movie Rentals.accdb

Art

ca-Movie.GIF

 

ct-First Perk Forms.accdb

Art

ct-First Perk.gif

 

ct-The Flower Pot Forms.accdb

Art

ct-The Flower Pot.gif

Art

sb-Staff Logo.bmp

 

sb-Valley Hospital Forms.accdb

Art

sb-Valley Hospital Logo.jpg

Art

TC Logo.jpg

 

Lesson 4

 

TechCache Reports.accdb

 

sb-Lagniappe Cruises Reports.accdb

Calculated queries

BUS108

 

chap3_ho1-3_realestate.accdb

 
 

 
 

 

ComboBox selects record

Private Sub Combo20_AfterUpdate()With Me.RecordsetClone        .FindFirst “[CustNumber] = ” & Str(Nz(Screen.ActiveControl, 0))        If .NoMatch Then            MsgBox “Sorry, no such record!”        Else            Me.Bookmark = .Bookmark        End If    End With    Me.LastName.SetFocusEnd Sub
Private Sub Combo20_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub Combo20_GotFocus()Me.Combo20.DropdownEnd Sub
Private Sub Form_Open(Cancel As Integer)    Me.Combo20.SetFocus    Me.Combo20.DropdownEnd Sub

Excel file – Sample data for Introduction to Access 2007

Camper Names Import Data.xlsx

 
Use this data to explore Appending and Importing data into Access.

Why Excel alone cannot satisfy every business need.

Skate shop wisdom « Smurf on Spreadsheets

CompuFiciency FREE eBook

By all means, click the link below to receive your personal FREE PDF file with TOC, internal and external hyperlinks, and a wealth of FREE CompuFiciency information.

CompuFiciency Training.pdf

CompuFiciency Training.pdf

Reclaim your desk – mount the monitor

If you really want to maximize efficiency in the office environment, there are a few no-brainer steps you need to take.  Besides a cordless keyboard and mouse, and double-monitors (the obvious choice being flat-screen monitors), the next improvement is to mount your monitors above the desk surface.
Most all newer flat-screen monitors come with industry-standard bracket [...]