Child ID Access

Here we create an Access label report from scratch

Duration : 0:3:46

(more…)

Learn how to put two text strings together into one query field using STRING CONCATENATION with this tutorial. Go to www.599CD.com/Access/YouTube for more free tutorials.

Duration : 0:5:0

(more…)

In this tutorial, I’ll show you how to take a table of people and relate it back upon itself. This technique is very useful for show a head-of-household and then all of the family members under him, OR even a geneaology database where you have people with mothers and fathers linked to the same types of records. This is part ONE of two.

Duration : 0:8:28

(more…)

A detailed demonstration of Workflow Builder for Microsoft Access, which allows you to automate processes without any VB coding.

Duration : 0:9:35

(more…)

Id like to create a database using microsoft access, in order to enter daily sales of multiple locations. Also have it it be able to calculate the sales by entering the the opening figure and the closing figure, to get a gross. then have it figure out tax/overrings.

Try these two Sites since I doubt anyone has time to walk you thru all the steps:

http://www.acrobatplanet.com/non-fictions-ebook/download-free-ebooks-pdf-microsoft-access-2003-tutorial.html

http://bookshared.com/2009/04/beginning-access-2007-vba.html

How to use Microsoft Access ( part 7 of 13 ) Importing Tables

Duration : 0:3:51

(more…)

Ok I have little experience with Microsoft Access and I need it as a school homework.
Please I don’t want it complicated and without queries cause I don’t even know what queries mean.
and if there is a kind of a guide on how to do it or even a picture on how it should look like.

You should decide on how it should look, not anyone else.

Write down what you think you need.

Do you need Customers for the restaurant? If so, make a table for customers. You will also need to work out what type of attributes (fields) the customers should have. Like name.

If you have customers, do they make bookings? If so, make a bookings table. This should include the promary key from customers so a customer can make a booking.

Do you want the customers to be able to make a booking for a table and/or a certain time. If so, you would have that information as well in the bookings table.

You may also need a tables table so you can say how many tables are available, and how many can sit at a table.

It could go on and on. You need to decide what to put in there. You can either make it large, or just small. It is totally up to you.

Without seeing what you are supposed to do for the homework, if it is clearly documented, then it is hard to say. If it is just to make a resraurant database, perhaps you could go to a local restaurant and explain what you are doing and ask what type of information they get.

Then with that type of information, you should be able to work out what tables and attributes (fields) you need or want.

As for a guide on how to build a database, access comes with help, so it should give you the information that you need. They are also wizards that allow you to make a database easier (or so it seems).

Good luck.

Microsoft Access Scheduled Tasks Of Data Imports or Exports

Duration : 0:2:51

(more…)

I need to change a couple of items from my list box in Microsoft Access. I don’t know where to start.

Here is a good place to start ….

http://www.bcschools.net/staff/AccessHelp.htm

Hope this helps.

Hi everyone. I’m new using Microsoft Access and I was hoping for some help. I’m doing an assignment that basically includes the tables for product, and suppliers for a motorbike company.

I’m supposed to suggest some new tables so I decided on suggesting one for employees with all their information, and one for customers. How do I know if these new tables should be linked with existing tables(suppliers, products) and how do I do it?

any help would be GREATLY appreciated. Thanks.

First, linking tables should be done utilizing the query part of Access. You can do this by selecting your tables in query/design mode. You link link them by using a common field. For example, if John, your salesman sold 2 monitors to Smith and Associates, your customer, you can link them by having John’s salesman Number with Smith and Associates customer number as part of the order. Then when you query it with the relationship, it will pull the order and give you all of Johns information with all the information from Smith and Assoc. You can then also track all the orders each of them made. Your relationship should be nuneric, kind of like a serial number for all. This can easily be done by designating your primary key on each of the tables as an autonumber in each table. I hope this helps.