Database Design

Bringing A 300+ Column Excel File Into Access

Someone asked an interesting question about Excel and Access, so I decided to transcribe it here. “I have an excel file with 300+ columns. I would to split and export them to access as two table and join them. Could you please help me with this.” Thanks in advance, Ma…. Here was my response: “Hi […]

Continue Reading

Field Inspection App In MS Access

Today, we will consider how to track field inspections, by building a framework for a field inspection app in MS Access. This sample application is just a framework, and just shares some potential ideas. You can customize it and put your own “spice” on it. Here’s what it will look like when we’re done: First […]

Continue Reading

Converting A Excel Spreadsheet To Access Database

While I was scouring the Upwork gigs, one caught my eye, they left an Excel spreadsheet example and so I decide it was good enough to try and recreate it in Access database format. I just couldn’t pass up the challenge on this one. So I figured I wanted to share the journey with you […]

Continue Reading

MS Access Stock Control Database Pt1

I am in the process of converting an Excel spreadsheet into an MS Access database. One of the first questions I asked was, “Are you doing this manually” and “How”. The reason is simple, I don’t want to try and figure out a new way of processing for them. If they are already used to […]

Continue Reading

How To Set Up Relational Database

I had a suggestion from a reader named “Dennis” after trying to gather information for a new database book. He responded: Erik, My suggestion is this: Make an easy tutorial to set up a database with tools on how to setup tables, link tables, how to set up keys on tables. Most tutorials tell users […]

Continue Reading

Database Access From Anywhere

How can you develop a database you can access anywhere? How can I develop a worldwide platform for my database? You can get register your domain with Godaddy and then host your domain with someone like HostGator. Here is a link to use to HostGator (get started with a penny!): HostGator Build your webforms in […]

Continue Reading

Database Design – Video 8

In this part of the video series you’ll learn the following: Database Design in Access building tables in Access field properties field datatypes relating tables in Access << Free Access Programming tutorial Video 7 Microsoft Access Form Design – Video 9>>

Continue Reading




 

Call Erik Now