Houston Chronicle

How to Create a Searchable Database in Excel

For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...
Houston Chronicle

How to Import an Excel Spreadsheet Into Access With a Macro

If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true. Macros are small programs that execute commands you specify. Write ...
TechRepublic

Use a command button to import Excel data to an Access table

Use a command button to import Excel data to an Access table Your email has been sent While Access 2003 and 2002 include a wizard for importing data from an Excel file into an Access table, you may ...
TechRepublic

Use SQL to quickly create a new table from existing records in Access

Use SQL to quickly create a new table from existing records in Access Your email has been sent SQL lets you use one command to quickly create a new table containing a subset of records from a larger ...
JournalofAccountancy

Creating a data-entry form in Excel

Q. I spend a substantial amount of time entering data into Excel. Do you have any suggestions on ways to make this faster and/or more efficient? A. One of the best data-entry tools to use in Excel is ...