A Thorough Tutorial That Helps One Make A Mean Database

Oct 24, 2006

Hello all!

I have been searching online for the past couple of days for a thorough tutorial that aids the user to make his/her own detailed database based on example data (that does not necessarily have to be adhered to) supplied as the tutorial progresses.

As a student participating in an advanced computing class, I feel that this would benefit me as I can do as the steps ask and see how certain things are done. I am not a complete Access mug... I have a basic knowledge of the fundamentals, but stumbling accross an in-depth tutorial that details all of the standard features (tables, queries, forms etc) along with possibly some example modules would be excellent and beneficial.

All I have found so far is various snippets - "SQL basics" and "Macros: what they do and how to implement them" for example - these miss the bigger picture I am looking for. Surely a step-by-step tutorial on "Designing and working a fully-featured database from the gound up" is not that rare!

Thanks in advance for any help. :)

View Replies


ADVERTISEMENT

Customer Database Tutorial

Jul 5, 2006

Hi

I am new to Access and would like to learn by taking on small projects.

Does any body know any good tutorials for beginners that could show how to start a database for a list of customers or something similar?

I have looked at the ones that can be created with the Wizards but obviously this doesn't help you understand the mechanics.

I would like to learn the 'nuts and bolts' so that I can expand the database and create new ones the more advanced I become.

Any good suggestions would be appreciated.

Thanks

View 2 Replies View Related

Looking For Good Tutorial On Feeding A Site With A Database.

Oct 25, 2004

I am very new to ASP and Access. I need to learn how to create a database full of images and text to feed dozens of webpages for a new site I am doing. I have googled many times and can't really find what I am looking for. I've come across ADO several times. Is this similar to what I am looking for? Thanks.

View 5 Replies View Related

Create A Tutorial That Tracks Progress For A Specialized Access Database

Apr 13, 2007

We are working on an access2000 database that will incorporate various "tutorial" or "training" elements in the db on how to use the db (mostly links to outside PDF files, etc.); the training elements guide users on how to do various data entry tasks, report generation, etc.

Is there a way, in Access, to track which "step" of the procedure a user is on? For instance, if they make it through Exercises 1-5, is there a way we can add some sort of indicator that lets them know, when they come back to it a week later, that they left off on Exercise 6? I have seen this done in various software tutorial packages, but I'm not sure how it is accomplished?

Any suggestions?

View 1 Replies View Related

Need Helps..

Oct 31, 2007

Hello everyone .. help me please..I am really new in Access.
Currently, i create one query; there i use " AS " keyword for example: Month(date) as month. Later, i wanna create another query which is to update some values of the month. When trying to execute the update code for the month, i always get the error message: month field not updatable. I wonder what's wrong with that. If is not updatable, could you give me some solutions?

Thanks in advance

View 4 Replies View Related

Delete Helps.Thanks

Jun 22, 2006

Hi all,

Dim vAns As Variant

vAns = MsgBox("Are you sure you want to delete this record?", vbQuestion + vbYesNo, "Delete")
If vAns = vbYes Then
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

I'm trying to create a delete function. First, it prompt me whether i want
to delete this record
vAns = MsgBox("Are you sure you want to delete this record?", vbQuestion + vbYesNo, "Delete")

However, after i click 'Yes". Another prompt will pop up and ask me whether i want to delete this record. This prompt is not this prompt vAns = MsgBox("Are you sure you want to delete this record?", vbQuestion + vbYesNo, "Delete")

I think it is access built-in prompt. my qn is that is there any way to prevent the 2nd prompt from being pop up?

Thank you

View 2 Replies View Related

Helps! Access 2003

Apr 27, 2006

I cannot implement search function for my database through List Box Wizard
; it doesn't have option that "Find a record on my form based on the value I selected in my List Box".......

Who can tell me why......

If i don't use this wizard, is there any way that i can implement search function??

Thank you!!

View 12 Replies View Related

Helps! Cannot Implement Search Using Combo Box

Apr 27, 2006

Who can tell me why I don't have following option in the Combo Box Wizard?
"FIND A RECORD ON MY FORM BASED ON THE VALUE I SELECTED IN MY
COMBO BOX"

I am appreciate!

View 2 Replies View Related

Need Helps On Query Retrieve Range Of Dates

Apr 18, 2007

4/11/2007 1:01:28 AM
4/12/2007 2:02:52 AM
4/13/2007 4:21:30 AM
4/14/2007 2:22:21 AM
4/15/2007 3:34:53 AM
4/16/2007 4:02:37 AM
4/17/2007 5:03:15 AM
4/18/2007 7:17:34 AM

I need some helps
I have a table with date + time, how can I query so that it retrieve a 7 days range from today and go back ti 7 days

i though this should work (it works if the the table has date only no time)
Between Date() And DateAdd("d",-7,Date())

thanks

View 2 Replies View Related

SQL Tutorial

Oct 20, 2006

Hi,

I am trying to learn how to use SQL. Can ayone please tell me where to download/view a comprehensive and easy to use tutorial?

Thank you very much.

Gareth

View 1 Replies View Related

VBA For Access Tutorial

Jun 4, 2005

Does anyone knows a good VBA for Access tutorial or documentation i can download so i learn how to write the Event Procedures in MS Access?

Thank you for your help.

View 1 Replies View Related

Need A Good Tutorial

Jan 26, 2006

I have been selected to do a project by my department head. It involves programming an Access database to do various things. It has to have forms and all that good stuff. I'm trying to get the higher powers to get a web server for me to do this as a web application, but I may need to fall back on the Access idea. So I need a good tutorial on programming in an Access environment. I know it uses VB and I am pretty decent when it comes to programming with that language. What I need help with is how to do certain things like close a form using an onclick event or to print a report. There's a lot I need to be able to relearn so if anyone can point me in the right direction I would appreciate it much. I'm doing this for a Commander in the US Navy...(several ranks above me )...so I need to be able to pull this off!!

Thanks much,

JMH

View 1 Replies View Related

Access Tutorial With Exercises

Sep 21, 2005

Hi All

I have just spent 30-40 minutes reading through this forum. So many solutions. Excellent. http://www.access-programmers.co.uk/forums/images/icons/icon7.gif
Smile I am just starting Access and I want to find a course where there are exercises which will take me to a reasonably proficient level.

If anyone has done come across a book CD or online that they would recommend then I’d be most appreciative.

All the Best
Jacky Kenna

View 1 Replies View Related

Looking For A Chart Creating Tutorial...

Apr 17, 2007

Anyone know a good site w/ help creating charts in Access 2k? I have a few queries id like to display as charts but just playing w/ the chart feature is getting more confusing by the minute. Any tutorial would be great. TIA!

View 1 Replies View Related

Access Tutorial Videos

Nov 11, 2007

Sorry, couldn't let the world go without these instructional videos. It's not much, but it's a good place for beginners to start:

Access Instructional Videos

This might be a good sticky

View 11 Replies View Related

Expression Builder Tutorial Or FAQ?

Oct 13, 2006

Now I have been working for a few months with ACCESS but one thing that keeps giving me trouble and that is the "Expression Builder". I look at the Microsoft Help and it is not good in explaining this part of ACCESS. I have Access books and they are not good with explaining this aspect of Acess. Is there anyone with a good source to point me in the direction to learning the Expression Builder better then I know now?

View 1 Replies View Related

Recommend A Tutorial To Print Records Please?

Mar 8, 2007

Hi,
I'm using Access 2000.
I currently use a form to enter my customer details. As soon as the info is entered I need to send out a "thank you for joining" letter, but I can't figure out how to print out a single field, it prints them all.

Ideally I'd like to have a button on the form so I can print it out on a template.

Can anyone recommend a good tutorial on how to do this, or offer any advice please?

Any help would be greatly appreciated!

Many thanks

View 7 Replies View Related

Screen Scraper - Help Finding Example Or Tutorial Please.

Jun 10, 2007

New member here. I've searched this forum and the internet but came up dry and sure could use some guidance.

There are plenty of references to being able to use Access 2003 VBA to open a separate program (in this case it will be Internet Explorer 6.0) and scrape data from the window, importing it into a table. But all of the references only mention that it can be done, not how to do it. Apparently, it is such a common thing that pretty much everyone except me already knows how to do it.

Can anyone please point me toward a tutorial that walks step-by-step through the process of using VBA to open IE and extract data? If there isn't an online tutorial, maybe someone has an example I could use to figure it out.

Any and all help is appareciated.

Thanks,

DiverGuy

View 14 Replies View Related

Online Tutorial For Form Design?

Jun 4, 2005

I am new to Access and not a sophisticated user of computers. I've been given the task of redesigning some forms on an existing data base. I understand how to put the new fields I'm adding into the table associated with the forms I'm working on, but I've having a hard time actually moving stuff around the screen and getting it lined up.

Is there an online tutorial or reference I can go to that will teach me the layout basics?

View 1 Replies View Related

QBF (Query By Form) Advice/tutorial/example Appreciated!

Jul 7, 2006

Hi,

I have some basic VBA and ADO recordset exposure, and would like to create a form, that:

- allows a user to search 4-5 fields (client & business name based information)
- return options of records to view that match that data
- allow user to make a selection, which then provides another form with full details of that client's record(about 20 fields)

Can anyone provide an example or perhaps guidance on a good tutorial, that will take me through this process gently (and help me understand the process)!

Regards and thanks

Mack

View 1 Replies View Related

Beginner-Tutorial For Retail/inventory Table(s) Set Up

May 5, 2007

Access Guru's:

I am a beginner at best with Access. (I'm using Access 2003) I have a small in home business as a second job making silk flower arrangements. I am now to the point that I need to track my inventory, quantity used, COGS, etc. Most of my arrangements are in gift shops on consignment.

In lieu of buying Quickbooks Manufacturing ($$$), I want to start tracking everything with Access so I can at least get some nice reports at tax time.

The problem I am having is I cannot translate the tutorials that Microsoft supplies to this application, they only cover setting up basic tables. (ie: in a retail/inventory application - do I set up 1 table, 1 table & subtable, 2 tables????)

I set up a table so far with 4 basic inventory fields:
Item description (record includes: flower, vase, foam, etc) / Color / Qty on Hand / Cost. Then (on the same table) finished goods fields of: Qty Used / Arrangement # / Qty Left / Sold for. While trying to figure out how I am going to track how much each arrangement cost, I'm not sure this set up will work.

I probably went into too much detail for my question, but I wanted to give some kind of background. Is there a CD/Book/Tutorial that specifically guides one through setting up a retail/inventory table?

Sorry so wordy.

Catherine

View 1 Replies View Related

Best Way To Make Database Web-accessible?

Dec 28, 2005

It's an Access 2003 database which I want authenticated web users to be able to write new records to.

I don't think a Data Access Page is the right way to do this, is it? If something else, e.g. ASP could someone possibly point me in the right direction with steps 1, 2 and 3 :D

View 1 Replies View Related

Password Protecting A Form - Microsoft Tutorial Error

Jul 22, 2005

I was using this form tutorial to password protect my administrative tools. When I went to run it I received this:

"User defined type not defined" and the line Dim rs As DAO.Recordset was highlighted.

I have little experience with VB and I was wondering if someone here had any idea if it was their code that was wrong, or if it was something I did...

View 7 Replies View Related

Securing The Database So Only Admin Can Make Changes.

Feb 7, 2006

I've been fiddling around with the Tools>>Security settings but I can't seem to find a way where only I can make changes to the database and the users can't just use the switchboard. If you are regular user you don't need password but if you are admin you do.

How do I do that?

View 1 Replies View Related

How Can I Make The Database Take Data From Another Column?

May 20, 2007

I have 5 columns in ms access. They are as follows:

date_from, date_to, season_price, normal_price, actual_price.

However, I want to check if the sysdate is greater than date_from and less

than date_to then the value in the actual_price should be taken from the

season price for that record else the value should be taken from normal_price.

So, i would like to know how can do this? do i need to use visual basic?

I have no idea about visual basic. So, would like the complete way to do it.

Thanks

View 1 Replies View Related

How To Make A Database Form Open

Oct 19, 2011

I have built a database and setup my Queeries and Reports and setup my securities. What I want to do is make the Form open from a short cut. I can create the short cut with the security privilages but after the proper name and password is entered I want it to open straight into the Form. How do I get my database to do this?

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved