Help Creating And Designing An ACCESS Database!!!
Sep 1, 2005
Hi guys, i need help with a sample database, and wondered if anyone could tell me the entities and how to calculate the prices etc. If anyone could attempt starting the database off for me it would be appreciated too!!
Here is the spec!!!
You are required to produce and document a design that meets the requirements of the McDuffs Burgers scenario:
The corporate office of McDuffs Burgers has asked you to design a database to help track its restaurants and managers. The database is to help the management show the total annual sales of each restaurant and the performance of each manager, as measured by the totals annual sales of all restaurants for that particular manager. Each restaurant is supervised by a single manager, but a manager is also responsible for several restaurants. The company stores typical personnel data (name, salary, and so on.) for each manager as well as basic data for each restaurant such as the telephone and address of each restaurant, its size in square metres, and total annual sales for the last fiscal year. The company would also like objective ways to measure the performance of a manager such as the total revenue for which they are responsible, the average annual revenue per restaurant, the average annual revenue per square foot, etc.
The database should also track the orders that are placed by individual restaurants to the corporate office for various food supplies. Each order is associated with a specific restaurant, and of course, a single restaurant will place multiple orders during the course of a year. The company uses a standard set of product numbers, product descriptions, and associated prices that applies to all restaurants. Each order can specify several products, and a single product may appear in several orders. The database should be capable of computing the total cost for each order.
Deliverables
1. Entity definition for each entity.
2. Entity Relationship Diagram, which must show entities, relationships and membership.
3. Relationship definition for each relationship.
4. Relations (This must include for each relation the primary and foreign keys).
5. Data Dictionary.
Furthermore:
You are required to implement the design (produced in the first part of the assessment - McDuffs Burgers - Database Design), by designing and creating queries, forms, reports and any supporting code. Revisions may be made to the design in the implementation process.
You should note the management of McDuffs Burgers has little experience of database systems and wish to be advised on the information the system can produce.
They require example reports demonstrating the capabilities of the system to:
- Aid the day to day operation of the business.
- Provide appropriate management information.
You must also implement an appropriate user interface to the database easy to use.
View Replies
ADVERTISEMENT
Nov 1, 2005
Hello,
Hoping some one could assist me? I am busy designing a database which I am going to put in access.
I have designed the tables and am now not sure how to link them. I was given an excell spreadsheet with headings and am now trying to make this into a database. Example : I was given Co-ordinator Name - Which I now split up into:
Co_First_Name
Co-Last_Name
Co_Initials
Co_Area_Code
Co_Tel_Number
Co_Mobile
Co_Email
Now there other fields like this , for example Regional Manager Name - which I have split up as above into a seperate table.
These fields all relate back to one Code - Called District
There are also a fields which needs to show the a fee required the fee paid and fee outstanding/balance .
The rest of the information required I can create check boxes for , I hope!
Anyway my question is how do a relate all these different tables together?
This is my mental block. And the check box tha information - is it stored a another table? I hope I am explaining my self correctly and I hope some one can make sense of my question
View 4 Replies
View Related
Aug 19, 2005
Could someone please give me some help with designing a database in access.
I know excel really well, and took a class on access, and have tried a few times to get started with access but always to no avail.
I have a company that installs real estate signs
1. we have about 200-300 agents (which represent about 10-15 offices)
2. 3 things can happen to 1 sign -
-1. installed the first time (charge)
-2. have a sold sign, for sale sign, or flyer box put on(charge)
-3. Finally removed(free, no charge)
-4. the date would have to be tracked on all of these occurences
3. We have about 10 products or things that can be put or hung on a sign.
I can set up the offices and the agents, and link them just fine. I can set up the products and do the work detail. The problem I have and cannot figure out is trying to bill or invoice this. Some agents are billed individually and some agents don't get billed, there office gets billed as a whole. Could someone please offer some insight on how maybe to go about this from the beginning.
Thanks for any help
Josh
View 3 Replies
View Related
Jul 17, 2007
Hi
I've been asked by someone at work to design a "no brainer" gui for an access database but I am a complete newbie with regards to this - sure I can do simple queries to filter the information I what in design view but this is something else.
How can I design a gui that can be clicked on or is executed when the mdb icon is clicked that will allow people to access from a drop down box the area they need information about and then have to option to either have the information exported to excell or in a summary report to be printed off. Should I use the form wizard or the report wizard - though none of them seem to do what I want.
I've set up the database from the excell spreadsheets they gave me containing activity figures per operational region. The regions are listed in the first column and I wanted a drop down box to list them.
We have 6,000 entries on the database. These cover 8 regions with some regions containing maybe 500+ entries. As mentioned the regions are listed in column one of the database.
When I select the regions column in a drop down box instead of getting just one entry per region, I get every single entry for example 500 for region 1, 200 for region 2 etc. In other words it is reading the rows not grouping them according to region which is what I want
How do I group them so Access only includes one entry per region on the drop down box and what is the best way to design the gui to give the results I am after?
Thanks
Andrew
View 3 Replies
View Related
Oct 1, 2004
Good day,
I am in the process of creating a database in Access.
I need some advice on designing the table structure.
I have 10,000 products.
There are 40 product types.
Some fields are the same for all products. (I.E. description, price).
Some fields are unique to the product type.
I am thinking this:
1. Have a table called products with all 10,000 products including description, price, producttypeID and productID.
2. Have a table with producttypeID and ProducttypeDescription.
3. Have 40 tables with ProductID and fields that are unique to that category of product.
Is this the right way to go about it?
Thanks in advance.
View 3 Replies
View Related
Feb 14, 2012
I want to design a database for an educational instution environment. My problem is knowing what tables to create and how to link them. I know for example that an instructor can teach more than 1 course and a course can be taught by more than 1 Instructor. This makes it a many to many relationship which is not remommended. I know that there has to be another table to bridge these 2 tables. I want to know what is a suitable name for this 3rd table and what example fields it should contain besides the the Keys form table 1 and 2?
Now here is the over all problem:some instructors teaches more than 1 subjectsome subjects are taught by more than 1 Instructorsome Classes are taught by more than 1 instructorsome instructors teach more than1 classSome classes do more than 1 subjectSome subjects are done by more than 1 ClassSome classes are done at more than 1 locationThis is what is needed:
To be able to enter student grades and attendances by classThe marks sheet should be entered in a subform displaying the full student names list for a particular class at a time.
2. To be able to display the marks and attendance of students as a class list.
View 1 Replies
View Related
Feb 2, 2006
As a basic user of Access I believe I have identified a use for the program for the purposes of a reporting task which I am charged with at the moment. We undertake the weekly tracking of proposals, which involves in brief, the action required for the bigger proposals, the teams involved in writing the proposals and follow up information as well as registration of wins and losses etc.
At the moment we use Excel but I am finding it extremely labour intensive with entries having to be removed and captured by only one person on a weekly basis and when you are talking about 40 to 50 new proposals registered nationally in a week and about 100 updates on existing jobs it becomes a perpetual case of chasing your tail.
Am I right in thinking that if we were to design a simple, effective database with a form design that all our research directors could use with ease, and we could merely run reports off each week that this would not produce a far quicker reaction time when it comes to pooling international resources but also far more effective reporting system with which to produce our management summaries?
I am aware that this will probably require quite a bit of consultation on design but before I go shouting the merits of Access to any of my superiors I wanted to make sure I could be confident of Access's capabilities first?
Can anyone advise? point me in the right direction?
Many thanks!
Lisa H.:confused:
View 2 Replies
View Related
Dec 16, 2005
I want to make my Intro of Database. When I open it. Just like you open NorthWind(Sample) database.
How to Remove the Title WIndow of Form.With all sides just like in NorthWind.
also removed the Record Navigation (|< < 1 > >| >*). I saw every option in Form Properties but didnt find.
Please Let me help in this Regard.
My second Question If I only want to remove Record Navigation only.But Title window displays.
May be from first question I can also get my answer.
Thankful in this regard.
View 5 Replies
View Related
Oct 25, 2014
I have to design 2 databases base on some data that was given by my instructor but I feel like I'm missing something on both specially the 2nd database. I have attached my work so far as well as the instructions and the existing data..
View 2 Replies
View Related
Nov 18, 2007
I am student, in high school, and I have to make a stock database, for ITGS, so as to receive my IB diploma.
I have created forms so as to enter stock information, and customer information, but I have no idea, as to how to connect them, so as to create an order summery and invoice. I started by creating 2 tables, one for the books, and one for the customers. I then made 2 other tables, one being an order table, and the other the linking table between the order and the books (see relation.jpg). I created a form so as to input information, but I can’t seem to get it to work, (see form.jpg)
Ideally, I would like the end-user, to select the customer's name, from a drop down list, and then for the rest of the customer information to update automatically, then, for the end-user to select a date, and finally the end-user to select books from the stock. Once the end-user has finalized the selection, they would ideally press a button, which would automatically print out an order summary/invoice (Maybe a report?)And that would also automatically reduce the quantity of the books in stock by one.
I have no idea as to how to do this and I would really need someone’s help, seeing as I have less than a week to hand this in by (The deadline is Monday 16th November 2007)
Here are the images
form.jpg - http://img30.picoodle.com/img/img30/5/11/18/f_formm_78d6ea7.jpg
relation.jpg -
http://img03.picoodle.com/img/img03/5/11/18/f_relationm_6280f62.jpg
Thanking you in advanced
CJ M
View 1 Replies
View Related
Dec 6, 2013
I am attempting to normalize an existing database. I've created the table structures necessary and now I'm designing a query that will update the new field in my primary table: "LabelBaseProduct" with the primary key from my new table: "tblBaseProduct" where the old field from my primary table: "tblLabels.BaseProduct" equals the description field from my new table: "tblBaseProduct.BaseProductDesc".
A visual of my tables:
tblLabels (Main table)
- LabelID
- BaseProduct (old field with text data)
- LabelBaseProduct (new field, needs to be updated with PK from tblBaseProduct)
tblBaseProduct (new table)
- BaseProductID (PK and FK to tblLabels)
- BaseProductDesc (Field that should be matched to tblLabels.BaseProduct)
I tried to design a query using design view of the query design and this is what I have:
Code:
UPDATE tblLabels, tblBaseProduct
SET tblLabels.LabelBaseProduct = [baseProductID]
WHERE (((tblLabels.BaseProduct)=[tblBaseProduct].[BaseProductDesc]));
When I attemted to run the query it told me that it was going to updated over a million records. I only have just short of 2k records in my database.
View 4 Replies
View Related
Apr 25, 2006
Hello everyone!
I heard from a number of people that this is the place to come for Microsoft Access related help.
So here is my question and I hope someone can help me understand access a little bit better.
I am trying to create a database for a job I am doing. THere are 700+ convenience stores that we (4 inspectors) inspect every three months.
We have been told to do an ADA compliance survey when we visit these stores.
The ADA checklist that we have is about 78 questions and my manager wants me to create an ADA database for this information.
So I am in need of help on how to create a database that allows me to input the answers of this ADA checklist for each store inspected.
I then would like to be able to pull all that information into a report that I could say of the 700+ stores, 50% passed all questions, 25% passed only questions 1-??, etc. etc.
I can upload the two files: The ADA checklist and our Store list if anyone would like to help me out!
Thanks Much!
View 9 Replies
View Related
Dec 7, 2007
I have MSAccess 2003 running on WindowsXP. I have multiple users sharing a single database. When more than one user opens the same database, a copy of the database is being created?? I don't know if this is a standard trait of Acccess or something else. Any explinations would be helpfull.
Thanks
Bob
View 2 Replies
View Related
May 17, 2005
I'm not too hot at creating a database in Access, so I was wondering if there was anyone out their prepared to help me construct one.
This database is designed to search for property from various locations and from various price ranges, you can also pick the type of property, the amount of bedrooms and have the result in descending or ascending order.
For location just use: Location 1, Location 2, Location 3, and Any
Price Ranges use: 30,000, 50,000, 70,000, 90,000, and 110,000
Type of property please use: houses, flats, and bungalows
Bedrooms use: 1, 2, 3, 4 or 5+
Fill in any data you wish, I think this needs to have a query setup?
Thanks for your help
Chris Green
View 3 Replies
View Related
Aug 30, 2015
I am new to Access and somewhat OK with Excel.I am working at a government institution, agriculture sector. We have field staff of ~150 doing different field ranges ~350. Some officers are assign to more than one field BUT no field is assign to more than one officer. (these fields belongs to different Districts, number of fields in each district is not the same)
we have four different programs namely new cultivation program (NPP), productivity improvement of existing lands (PIP), farmer capacity building (HRM) and post harvest handling (PHP). Each program has its activities lets say NPP1, NPP2, PIP1, PIP2,PIP3 etc. for an example NPP1 is land inspection, NPP2 is donating planting materials. these activities are predefined and sequential. (planting materials can not be donate without land inspection)
Officers send their progress to progress monitoring unit monthly which includes progress of each program and each activity progress for that month. My objective is to track, analyse, visualize officers progress.
These are the questions I have,As I am OK with Excel and NOT good with Access do you think I should use access for this due to any special advantage only access can give me.can I visualize data with Access?
View 2 Replies
View Related
Aug 10, 2007
Greetings. I have the following problem:
I have a list of about 200 crops on a column, and for each crop I have 6 information (income, amount of land, season, etc.) in the following 6 columns. I have this information for about 100 households in 6 villages.
I am now starting to put these info in the computer, and it is an enourmous task. I thought that one way to do it is design a form in Access, and have one file per village. I then want to analyse the data at the household level for each village, and also analyse the data at the village level (after calculating village averages).
I want to recreate the form I used to interview farmers in Access, but I can't figure out how to make Access automatelly have 7 columns in form view (the first with the name of the crop, the next 6 with the information: income, etc.). The idea is to reproduce as closely as possible the form I used to interview the farmers, so as to facilitate the data-entry.
Does anybody know how to let Access automatically sort all the fields into 7 columns? Of course I can design the form manually (putting each field individually in its right place), but then I have 7 x200 fields to move, and it would take a huge amount of time. I can't believe that Access can't do this automatically, but I can't figure out how.
I then plan to transfer the info for analysis to SPSS. Does anybody foresee a problem?
Do I make sense? If anybody can help, I would be very grateful. This is actually very urgent, because I am going to pay somebody to do it, but I have to tell her how to do it over the week-end. Thank you very much!!
View 3 Replies
View Related
Dec 18, 2007
I am not sure where to post this question. I remember finding a forum just for Microsoft Access 2007 questions, but I couldn't find it again... Indifferent
Anyway, I have created a database, and have been testing it with my application. I have some data in this database. I was wondering if there was a way in Microsoft Access 2007 to create an empty copy of the database for release. In other words, I would like to create a copy of the database with all of the tables and columns, but without the data (rows) that I had entered as part of using my testing database...
Does anyone know if I can do this?
If anyone knows where this Access 2007 forum is, or resources that might answer my question, please let me know, as I would greatly appreciate that.
Thanks Again,
View 1 Replies
View Related
Feb 5, 2014
i am busy with creating a access storage database and need to calculate the number of days a vehicle is in storage, i have a [date in] field and a [date out] field. i need to calculate if [date out] is empty to use today otherwise [date out] - [date in]
View 5 Replies
View Related
Feb 22, 2015
I have attached the excel document in a zip file. Excel documents are not an authorized file type. This is going to be used for volunteers to input the shift and day they would like to work. I want to start by requiring volunteers to contact me and I will add them to the list of possible volunteers and I will give them a unique identification number.
When they contact me I will require all the information that is currently in the excel document (first, last, supervisor, ph number) I will then add them to a list of possible volunteers.
Then I would like a form they can access via sharepoint for volunteering what shift they can work. On this form it will have a box to input their unique id number and then select a shift from a dropbox (that has not been filled and auto populates). This will add them to the schedule.
Then I need a way to pull a report that shows all the volunteers and does not include their ID numbers.
As you can see the supplied document is full for March. I also have a second sheet that is blank for April.
I imagine there will be tables for
Volunteers (no duplicates in this list)
Supervisors (1 supervisor can be over multiple Volunteers)
Dates/Shifts (there are 2 shifts per day, there are 2 slots per shift)
View 6 Replies
View Related
Aug 17, 2014
I am a newbie at Access. I have uploaded an Access 2013 file and an Excel 2013 file to show what I am trying to do.
(I also incorrectly uploaded this question under QUERIES - since marked there as 'Solved")
The Access tables that I have created are meant to mirror the individual fields on the Excel spreadsheet.
On the Excel spreadsheet, I would enter data in the rows as the data becomes available.
The Access file contains the excel fields as tables. Some of the table fields consist of only one field and others have many fields.
I have created Primary Keys in all the tables. But I don't understand the process well at this point in time.
I need to know how to create proper relationships, and then, to create a query or a form to enter new data as it becomes available so that I can keep adding rows of data (query to enter and update data) and subsequently run queries to analyze the data
Need to create the correct relationships and a query that lets me update all the data for new cases, as an individual row (like on an excel spreadsheet) .
View 1 Replies
View Related
Jun 13, 2013
Why Access (2010) database is creating backup copy by itself?
View 2 Replies
View Related
May 23, 2014
I am using an Access 2003 database to create a Word report that contains Graphs. We have since moved to Office 2010, and now the vba code will not select the graph and populate the data, i presume this is because the data is no longer in a datasheet but Excel itself.
View 2 Replies
View Related
Jun 3, 2013
I am trying to create an access db to monitor my expenses for my new Snack house.
I have created a "Main" table which will be holding all the daily expenses entries one the fields is called "Type" in which i formatted as combo box with the following values (vegetables , butchery , bakery).
Another field is called "Item" which should list the items based on the Type selection.
Knowing i have a second table in which i stored all types and their corresponding items , how can i force the filed "item" in table Main to simply display the ones i need based on the "Type" input.
View 1 Replies
View Related
Nov 4, 2014
I read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.
Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.
I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?
View 2 Replies
View Related
May 20, 2015
I am creating a database for creating quotations. The quotation number is generated using the date, for example the first quote today would be quote number "05202015-1" because it is the first one today. The next quote today would be quote number "05202015-2" and so on. Is there a way to make access automatically generate these quote numbers based on the date?
View 3 Replies
View Related
Nov 29, 2006
Hi all,
Excuse me for being new here...but i need some advice on a database im working on. Im currently in a school trying to develop a database that records my students' participation in some arts activities.
What we need is a database that could capture the number of participants that actually went for a particular event (sounds easy rite? - :rolleyes: ).
To break it down:
1. The EVENTS are broke up into 3 categories : Exposure, Experience & Excursion.
2. Each EVENT consists of the number of PARTICIPANTS that is divided into Students, Teachers, Parents and Alumni.
3. Lastly, the PARTICIPANTS are further seperated into different interest groups such as Band, Choir, Drama Club etc....
It is quite overwhelming for me as im not that experienced in using Access..so i'll be glad if someone could help to advice me on how i should design the tables and their relationships.
Thank you.
Cheers! :D
View 1 Replies
View Related