Need some help in ACCESS

[trjones87]

its been so long since ive used this program Im a little lost



I have an excel spreadsheet I imported into acc, its just a spread sheet with computer names, locations, organization, units, etc
I want to create a switchboard with the options "add computer" and "search for computer(s)"
The "add computer" needs to be able just to add an entry into the table
The "search for computer(s)" needs to be able to query the table by different field searches.

Any help or just pointing me towards some good help online would be greatly appreciated

[Casey]

Access' help in the application is typically pretty good.

What you're wanting to do is create a form, that has buttons that fires either forms or runs queries where you can edit the information or insert new records. The Search button would be a query against your table(s) that filters for the keyword you specify.

So, you need Tables (spreadsheet imported), queries (create data or search for data) and possibly forms for editing the information, depending upon how you want to do it.

Hope this helps.