Why Choose Microsoft Access?
Is Microsoft Access right for you? Here are several reasons why I often recommend Access to my clients.
top of page
Search
Kimberlee Martin
- Sep 21, 2023
- 4 min
One Table or Two? Or Three? Four??
Not sure if you need one table or two in Microsoft Access? Here's a guide.
10 views0 comments
Kimberlee Martin
- Sep 5, 2023
- 4 min
Do I need a subform on my Access form?
When to use a subforms in a Microsoft Access database
14 views0 comments
Kimberlee Martin
- May 5, 2023
- 3 min
Port Access Data to SQL Server
Porting Microsoft Access tables to SQL Server
13 views0 comments
Kimberlee Martin
- Mar 29, 2023
- 5 min
Connection Properties
Use properties of Excel connections to gain access to real-time data points in your database.
31 views0 comments
Kimberlee Martin
- Mar 13, 2023
- 7 min
Access Database Corruption
Dealing with the "database is in an inconsistent state" error message, and other symptoms of Microsoft Access corruption.
18 views0 comments
Kimberlee Martin
- Mar 8, 2023
- 4 min
Connecting Data Sources in Excel
Using VLOOKUP data from Access and SQL Server databases
19 views0 comments
Kimberlee Martin
- Feb 20, 2023
- 4 min
Connections: Linking Access to Access
In recent blogs, I've been discussing the various ways you can connect data between Microsoft products. So far, I've covered Access,...
17 views0 comments
Kimberlee Martin
- Jan 20, 2023
- 4 min
Connections: Bringing SQL Server data into Excel
Add a link to SQL server data to your Excel worksheet.
20 views0 comments
Kimberlee Martin
- Jan 17, 2023
- 6 min
Connections: Bringing SQL Server data into Access
Linking to data in SQL Server from a Microsoft Access database
22 views0 comments
Kimberlee Martin
- Jan 9, 2023
- 4 min
Connections: Bringing Access Data into Excel
Creating links to Microsoft Access data in your Excel worksheet.
27 views0 comments
Kimberlee Martin
- Jan 5, 2023
- 6 min
Connections: Bringing Excel Data into Access
Create a Microsoft Access table that is linked to an Excel file.
20 views0 comments
Kimberlee Martin
- Dec 28, 2022
- 5 min
Connections: Importing CSV Data from your Software Package into Excel
Use Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.
17 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...
18 views0 comments
Kimberlee Martin
- Dec 16, 2022
- 4 min
Double Trouble
Today we’ll be looking at preventing duplicate values from being entered into your Excel sheet. This is the final entry in a series that...
15 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
14 views0 comments
Kimberlee Martin
- Dec 2, 2022
- 4 min
Validating Numeric Fields in Excel
Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
21 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.
13 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.
21 views0 comments
Kimberlee Martin
- Nov 18, 2022
- 9 min
Validation Harness in Excel VBA
Adding a Visual Basic structure to your Excel file for validating data.
14 views0 comments
CATEGORY
ARCHIVE
bottom of page