Wednesday, March 24, 2010

Visual Basic :Write Record to File

Thursday, March 4, 2010

Using Icon Sets in Excel

To create a table that displays a colored object rather than a value follow these steps:
  1. Create a table.
  2. If your table will be a yes or no then use either a zero or one as the value.
  3. Select all values (zeros and ones).
  4. Click on Conditional Formatting in the Home tab.
  5. Move your cursor over Icon Sets and then select an Icon type.
  6. To have only the icon displayed, click on Conditional Formatting in the Home tab
  7. Click on Manage Rules.
  8. Click on Edit Rules
  9. Select the Show Icon Only check box in the lower right of the form.
Watch this video to see how it's done.

Monday, March 1, 2010

QuickBooks: Using Account Numbers

By default on QuickBooks the account numbers option is disabled. You may have been saying, "help, I can't enter the account number." If you are an effective bookkeeper or accountant you need to label your accounts by number.
Here is how to turn on this option.

First, on the menu strip go to the Edit tab and select Preferences.Next, click on the Accounting tab in the right pane. Select the Company Preferences tab in the center pane. Check the Use account numbers check box.
Finally, you can enter an account number for each account.

SQL Server 2005: Windows Authentication Mode

There are two authentication modes in SQL Server 2005 one is Mixed mode that allows all users from differing Operating Systems to gain access by requiring a user name and password, separate from those given to gain network access. Windows Authentication mode allows only Windows based Operating Systems to gain access. It is claimed to be much more secure because users in this case would not need a separate user name and password from their network credentials and they would not have the opportunity to write their credentials on a sticking note that they keep under their keyboard.

According to Susan Sales Harkins and Mike Gunderloy article SQL Server: Design for security from the start,
published by TechRepublic, recommend using Windows Autehntication mode when possible.
They state that, "Windows Authentication is integrated with the Windows security system, which provides more
features than SQL Server Authentication and is generally easier to use, more efficient, and more secure"
(2003, Harkins & Gunderloy)

Works Cited:
S. Harkins & M. Gunderloy. (2003). SQL Server: Design for security from the start. TechRepublic. Retrieved on March 01, 2010 from http://articles.techrepublic.com.com/5100-10878_11-5035150.html