What is the best book to learn Access and to do this project?

[Me]

I have a list of 1400 students in Excel. I want to pick
out a student by scanning in the ID number barcode on an ID card for
admission into lunch. After I have done this I want to be able to
print out a list of all the students that have entered that lunch.

The students already have their ID cards with ID numbers on them and I
have pulled all of their ID numbers, names and lunch periods into
access from Excel

I have a barcode scanner that connects between the keyboard and PC and
I have it readiing the barcodes on the cards.

 

[Ken Snell [MVP]]

Most any book on ACCESS should give you the info for how to do what you want
to achieve. Your local bookstore (online or in person) will have numerous
books on ACCESS. Microsoft Office ACCESS 2003 Inside Out by John Viescas
(MVP) is a good one.

Essentially, what you'll want is a form that allows data entry into the
table where you're going to store this attendance information. This is a
good starting project for learning ACCESS.