Archive for the Database Design Category


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 […]

Read More...

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 […]

Read More...

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 […]

Read More...

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>> Sign up for 10 FREE VBA videos that will help you do your job […]

Read More...