Need the experts on microsux access please.

I open my program an it loads, gives me a grey screen, no menu options but says ready at the bottom. I'm doin this while drivin cause I've never messed wit it before an wanted to play round wit it, cain't see the screen well cause of the sun.

Is this normal? Have I a problem wit my program? If it is normal, what do I do now?? lol

I loaded it agin an this time I have a menu an the like, I spose it was jes havin a moment er the like.

.
.
YOU MUST CREATE a database file first..."filename.mdb" File|NEW|Database,etc

Inside this file is all your tables, queries, reports, macro, VBA Code, etc.

Then you have to create table(s)....

Inside the tables are all your field names and data-types...i.e. name, age, ssn, whatever, etc...

After you have created your table layout...you can input data....almost just like Excel...row by row.

After you have some table(s)...you can run querys on the data, create forms for fancy data input, reports for printing, etc.


BUT the absolute first thing you MUST do is create a database file then a table...


If you want I can send you a test db or something similar.....


Forget forms, querys, macros, reports, etc...until later...just focus on creating tables for now...

:faint:

:agree:

I was just going to say that............ B)

Just saw this thread. I have been working with a company that basically demanded (against my exhortations) that I use Access to build the database they want. Then they said they weren't even going to buy a license for it, that I need to build a front-end in Excel. I shoulda thrown up my hands right then and there and walked out.

I'm not a huge fan of Access, but it's a decent database system for small applications. It does work, but it uses it's own version of SQL, has problems with some relationships, and generally is not as good as MS SQL Server.

Well.. the more I look at it, the more I realize jes how far behind in all of this I am.... this week has sucked, an I'm to tired to even wanna fool wit it, it's been enough jes tryin to keep it on the sunny side up an between the lines lately.

My advice - learn Access from someone. I've got two mentors on Access, 30 years computer experience and a BS in computer science that included two semesters of DB design. Access is still a completely different animal.

Take a class or find a mentor. I'm not a good one at this point. When this job is done, I'm taking Access off my resume. I don't want to work with it anymore.