asemisldkfj
the law is no protection
anyone familiar with this? I am hating it right now and it does not seem very intuitive, but that could be due to my lack of familiarity with a lot of the terminology (reports, forms, etc.) or capabilities of it.
I also want to write a pretty lengthy query (selecting a lot [10-15] of specific columns) and there doesn't seem to be any way to write the SQL for this other than memorizing or copying and pasting all the columns I want. I guess I could try the query wizard, I just wish I could write it myself with a little help.
I also thought that making a report rather than a query would maybe give me a little more powerful interface or allow me to do neat things with the data, but it just seems like overkill for what I want.
i'm about to get an access book for a database class, i'll check into it :]
i think you can import sql
I totally forgot about this.
Anyway it's really easy to do. What are you trying to do with it exactly though besides make a big query?
Queries:
You can create queries a number of ways, the most basic and simple ones can be done quickly with the "Query Wizard" by selecting the relevant fields, or you can use "Query Design" for a visual method of assembling queries from the fields with the tables, lastly you can create an empty query and do it all through the SQL view in the home tab under the views drop-down.
You can make lengthy queries easily though by just selecting them either in the Query Wizard, or Query Design, and selecting whatever you want from the tables.
Forms are for creating an easy way to enter data into the database, for a specific purpose. This would be useful if you had for example a screen for entering your daily nutrition information, or any combination of entries that make up your database. This would be analogous to forms on a website that accept user input to be inserted into a database.
Reports are typically an output type of thing where it just nicely reports the data in a friendly format, based on queries. They are slightly dynamic as well, as you can enter which record to skip to in whatever kind of report you want to generate.
I can send you over some basic databases with some forms and queries to look at if you'd like.