First step to design Database?

We currently have corporate level Oracle DB server in corporate headquarter. And corporate level decided us (Business Analysts) to limit our accessing DB, because of the burden of data transaction.

Therefore, we decided to make a small MS Access DB into network drive, download monthly some parts of Oracle DB, and all business analysts can share the small sized Access DB.

Now, my concerning is how to design the small DB which all department analyst can share with. Because all analysts from different department usually select different column in different tables from the huge Oracle DB, the success of my Access DB design comes from everybody’s satisfaction.

I wonder if DB specialist in this group can provide me the guide line/ steps/ awareness before design the DB. What is the first step to design DB? Are there any tools to help DB design?

Sponsored Links:

Related Topics

Database Design and Implementation
In this tutorial you will learn how to design data model and implement it in MS access database. MS Access tutorial step by step explain you how to create database tables using create table script and manually. You will learn how to write sql queries to insert data into database, how to search and display data etc.

How to Create and Design Multiple Relational Tables in Microsoft Access
This quick and easy tutorial (Part 2) will teach you how to create multiple related tables as part of a relational database design in Microsoft Access. It will provide you with simple step-by-step instructions, including screenshots, for even a beginner.

Access 2007: Thinking about Database Design
The first step in creating a database is to think about why you need it -- what is its purpose? Once you know that, you can begin designing your own database. Ask yourself questions like: What kinds of information will it store? How will I have to break that information down, so it can be stored in my database? How will I use the data once it's in there?

Screen Form Creation
Microsoft Access Screen Form Creation - Step By Step Design & Creation of User Friendly Database Forms.

Odd Form Behaviour
I have made a form in my database that is a list form.

It is a sort of wizard form, as you click next the list changes to a different row source this is all working fine.

I made a few changes to it for the next step of the wizard closed the form and then opened using the button from the other form that activates it and it is locking the database up and I have to use task manager to crash out.

Not too dissuaded by this I re-opened the database put a stop on code to step through and code steps through fine until same thing happens.


So I reopen and try opening the wizard form in design view. Works fine in design view. Switch to form view works fine.


Switch to layout view, and then to form view. Works fine.

Close wizard form.

Try and open direct from the list and the database stops responding

removing security from not my own database
chaps I have a database which was not designed by me but I have passwords etc (the designer left it to me to manage). I wish to remove all security so that I may trnsfer the database between computers. if I simply copy the database from the computer it was started on (as was the security) I cannot open it on my own laptop.

please help with step by step info alt is there a security file which I can bring across with the database. the confusion may have something to do with the workgroup the creator made. I dunno

Normalization for creating batch process records
I am just getting started creation a new database for batch process production records that will be filled completed in the field real time. I had started out creating a table that had fields for each step of the process. Such as:
[Batch number]
[Equipment] (lookup)
[Process] (lookup)
[Step 1 start time]
[Step 1 comments]
[Step 2 Start time]
[Step 2 comments]
[Step 3 start time]
[Step 3 comments]

I have seperate tables for listing equipment, Processes and standard times for each step of the process.

I realize that another way of doing it would be to create another table with a list of the process steps and then my table would look somethink like this.

[Batch number]
[Equipment] (Lookup)
[Process] (lookup)
[Step] (Lookup)
[Start time]

The problem is, I want a form (batchsheet) that already has all of the steps listed for the data entry person and simply a blank for them to enter what time they completed each step. I dont want the client to have to select a [step

Database Design - Table Structure
In this Microsoft Access Tutorial, we are going to discuss good database design as it relates to table structure. Good database design is a many faceted beast, and later on in the tutorials, we will be talking about interface design, naming conventions, and other areas relevant to database design, but to start with, the structure of your tables is the foundation upon which you will build the rest of your database, so it is important to get this part right.

Converting a Spreadsheet to a Database
Do you have an unwieldy Microsoft Excel spreadsheet that you'd like to convert to an Access database? This illustrated tutorial walks you through the process, step-by-step.

Database design tutorial
If you are going to create your own database it is good to stick to the rules of database design, because they will ensure the long term integrity and maintainability of your data. This tutorial teaches you what databases are and how to design a database that conforms to the rules of relational database design.

Access TS database?
and I apologize if this is not in the right forum to start. I just got my hands on 2007 access, and I am currently creating a database. I was hopeing it would be easier to use since I am very familiar with excel, but I have discover access really is another type of animal.

Heres the concept:
I need to create a trouble shooting database that has customer go step by step through a process.

example: unplug your cable modem from electricity. Is this done?
example answer if (yes) proceeds to new trouble shooting question.
Example answer if (no) unplug the electrical cable from the wall to the modem. is this done?

So the whole premise ios easy to understand step by step question based on yes and no answer. If you answer yes it takes you to another question or solution, if you answer no it will potentially do the same thing

Understanding Relational Database Design
This tutorial show you how to plan and design a database from the ground up. For practical examples, it uses the database design of the Northwind Traders sample database included in Microsoft Access 2002.

Adding New Record to access database
I am confident with vb6. Could anyone give me a step by step on how to add a new record to access database using I am able to open and close connection to the database. I havelooked at several sites but they are not comprehensive for a .net newbie and are concentrating on viewing rather than adding new data to the database.

Microsoft Access Table Design
Access Relational Table Design is the most important phase of a relational database. A professional table design will result in a database that will hold more data, last longer and support more concurrent users than a database with an inefficient table design. Whether you are creating a simple database or a complex database - a professional relational table design doesn't take much more time and will result in a resilient database. To use SQL table queries to their fullest extent you will need properly normalized Access table design.

Access 2007: Basic Workshop
Learn how to create a complete new basic database following this step-by-step guide. This article covers the basic process of starting Office Access 2007 and creating a database, either by using a template or by creating your own tables, forms, reports, and other database objects. It also details a few techniques that you can use to get information into your new database.

Objectives: Learn to use MailMerge Step 1 - Create Form Letter, Step 2A - Select Data Source, Step 2B - Insert Merge Fields, Step 3 - Merge

step and step proccess
I have a problem. I need the database when has the various reference with different process.
When I click in button the data base run the database and find the next process for the same reference

Use parameters to ask for input when running a query
To make a query ask for criteria when you run it, create a parameter query. This allows you to use the same query over and over without having to constantly open it in Design view to edit the criteria. Before getting into the step-by-step process below, it’s helpful to understand these terms...

MS Access - Creating and Working with a Database
Stop typing lists of information in Microsoft Word or Excel! In this tutorial, you will learn how to create databases that can store names, addresses, and any other type of information that you can think of. You will be pleasantly surprised to find that creating a database isn't all that difficult. Microsoft Access even comes with a Database Wizard that takes you step by step through the process of creating a database.

Create an Adobe PDF File From an Access 2007 Database
Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up an Access database, step-by-step.