A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Project



 
 
Thread Tools Display Modes
  #1  
Old November 18th, 2008, 11:36 PM posted to microsoft.public.access.tablesdbdesign
traveler72
external usenet poster
 
Posts: 2
Default Access Project

Im stumped on this access project. I need to get this project started for
school. I need some guidance on where to begin and what to do for each step.
Can anyone give me some guidance. The following description of the
project is as follows:

You are an event planner for Special Events Plus. You are frequently asked
by your clients to provide a listing of restaurants in the area that might be
of interest to event participants. Until now, you have kept this information
in an Excel workbook, but you decide that you want to move the data to an
Access database. Currently, you track the type of restaurant (fast food,
ethnic, vegetarian, Italian, etc.), street address, telephone number, opening
and closing times for each day, approximate cost per guest for meals, and
approximate distance from your office. You would like to add a way to track
any special or unique features a restaurant may have.

Design and create an Access database to meet these needs. Create the
necessary tables with the necessary fields. Establish the appropriate
relationships between the tables. Enter at least five sample records in each
table. Prepare a sample report you could provide from your database to a
client.

Determine at least five questions clients might ask that you could answer
with your restaurant database. Design, build, and save five queries that
could answer your questions. At least two of the queries must involve more
than one table.

Design, build, and save at least two additional reports that might be of
value to your clients and to you.

-Thanks for the help
--
traveler72
  #2  
Old November 19th, 2008, 12:18 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Access Project

On Tue, 18 Nov 2008 15:36:00 -0800, traveler72 wrote:

Im stumped on this access project. I need to get this project started for
school. I need some guidance on where to begin and what to do for each step.


This really sounds like you have a class assignment and want somebody else to
do it for you. Sorry, these groups don't work like that. I would hope that
your class materials would provide the guidance that you're asking for.

For some additional resources, see

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
--

John W. Vinson [MVP]
  #3  
Old November 19th, 2008, 08:39 AM posted to microsoft.public.access.tablesdbdesign
traveler72
external usenet poster
 
Posts: 2
Default Access Project

Your assumptions are wrong, but your guidance might help. How else would
someone understand how to point me in the right direction without posting
what type of problem I was dealing with. Thanks for the help though.
--
traveler72


"John W. Vinson" wrote:

On Tue, 18 Nov 2008 15:36:00 -0800, traveler72 wrote:

Im stumped on this access project. I need to get this project started for
school. I need some guidance on where to begin and what to do for each step.


This really sounds like you have a class assignment and want somebody else to
do it for you. Sorry, these groups don't work like that. I would hope that
your class materials would provide the guidance that you're asking for.

For some additional resources, see

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
--

John W. Vinson [MVP]

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.