Question

any1 good with ms.access.....?

Answer 1

@agdgdgdgwngo @NeThWa @calmchessplayer

Answer 2

yes tell me mr.Goutham

Answer 3

then What kind of help from the Ms-Access.

Answer 4

for example take an acces database for a library........where people can borrow many books nd return books in turn like all the books may not be returned @ the same time

Answer 5

So.......how would u keep track of thr books yet to be returned nd books returned and dates @ which books are returned

Answer 6

I don't Under stand your question
whether it is related to any database table or not

Answer 7

yup it is.....how do you design a db with those features.......................

Answer 8

first to create a data base for your requirements
and the command is
CREATE DATABASE <DATABASE NAME>
in that
Create a table for the requirements of the books.

Answer 9

is that SQL?
i m done with tables........like i created one for Students,one borrows nd 1 for submits.....how to get the track of the books yet to be returned by a specific student......

Answer 10

Using Sub queries of SQL to get your answer
or using join statements....

Answer 11

i donno SQL...

Answer 12

give me detail your query a i will sent back to you

Answer 13

In access there is a Query wizard and Query Design buttons in Create Section.

Answer 14

yup i tried them but in vain.............

Answer 15

the first table has some id nd name of the student nd the second has books borrowed by a student nd the number...any number of a books can be borrowed nd the third table has books returned nd dates on whic books are returned nd the number retrned......

Answer 16

NOw i need to get the number of books yet to be returned in a table how do i get that......look up wizrd dint help......

Answer 17

first click on the Query design and opens a dialog box opens
in that dialog box click the close button and drag the mouse in Query Design
and then right click and select " SQL Design View".
Click on it. It will opens a command of 'SELECT *'
then write your query what you need.

Answer 18

ok i will explain you tomorrow ..

Answer 19

bye