top of page
Search
Kimberlee Martin
- Mar 13
- 7 min
Access Database Corruption
Dealing with the "database is in an inconsistent state" error message, and other symptoms of Microsoft Access corruption.
6 views0 comments
Kimberlee Martin
- Jan 17
- 6 min
Connections: Bringing SQL Server data into Access
Linking to data in SQL Server from a Microsoft Access database
13 views0 comments
Kimberlee Martin
- Jan 11
- 4 min
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
6 views0 comments
Kimberlee Martin
- Jan 9
- 4 min
Connections: Bringing Access Data into Excel
Creating links to Microsoft Access data in your Excel worksheet.
17 views0 comments
Kimberlee Martin
- Jan 5
- 6 min
Connections: Bringing Excel Data into Access
Create a Microsoft Access table that is linked to an Excel file.
12 views0 comments
Kimberlee Martin
- Dec 22, 2022
- 3 min
Using Access to Clean Excel Data, Part 5
I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that...
8 views0 comments
Kimberlee Martin
- Dec 12, 2022
- 6 min
Using Access to Clean Excel Data, Part 4
Use MS Access to find duplicates in your Excel data
7 views0 comments
Kimberlee Martin
- Dec 1, 2022
- 5 min
Using Access to Clean Excel Data, Part 3
Use MS Access to clean numeric fields that contain text.
10 views0 comments
Kimberlee Martin
- Nov 21, 2022
- 6 min
Using Access to Clean Excel Data, Part 2
Use MS Access to clean phone numbers in your Excel data.
15 views0 comments
Kimberlee Martin
- Nov 14, 2022
- 5 min
Using Access to Clean Excel Data, Part 1
Excel data can be messy. Use MS Access features to clean it up.
20 views0 comments
Kimberlee Martin
- Nov 4, 2022
- 7 min
Appending Excel Data to an Access Table
Use an append query to add Excel data to an Access table
11 views0 comments
Kimberlee Martin
- Oct 25, 2022
- 6 min
Connections: Importing Excel Data into Access
Tips for making your Excel data import smoothly into Access
22 views0 comments
Kimberlee Martin
- Apr 18, 2017
- 3 min
Option Explicit
If you’ve ever written VBA code in Excel, Access, or any of the other products in the Microsoft Office suite, you may already be familiar...
19 views0 comments
Kimberlee Martin
- Jan 20, 2017
- 4 min
Protecting Data on an Access Form
Microsoft Access allows you to quickly create forms for viewing and editing your data. One issue you may have run into with forms is that...
37 views0 comments
Kimberlee Martin
- Nov 30, 2016
- 4 min
Access or Excel?
Excel or Access? Microsoft has lots of great tools, and in most cases, it’s pretty clear which you need to use. If you need to write a...
20 views0 comments
CATEGORY
ARCHIVE
bottom of page