Fortunately for Microsoft Access Developers and Consultants, MS Access allows you edit the SQL behind the queries. Although SQL isn't particularly difficult language to learn as it has easy to remember syntax, for a new user it is best to rely on the Wizards provided by Microsoft Access. However, for advanced users or developers/consultants the wish to get into the nitty gritty can occur often as it allows some more direct control or fine tuning.
To access (pun intended) SQL View, you simply click the "View" button, and instead of choosing "Design View', you'd select "SQL View", its that simple. Queries are extremely important and powerful whether you use the Wizards or edit the SQL directly, they enable you to display information from multiple tables as well as single tables. They form the basis of forms and reports, and without them databases would be essentially useless for obtaining any real relevant data from. In the end, databases are serious business for Database Developers and Consultants whether they use Microsoft Access or another type of DBMS, and queries form an important cornerstone.
To access (pun intended) SQL View, you simply click the "View" button, and instead of choosing "Design View', you'd select "SQL View", its that simple. Queries are extremely important and powerful whether you use the Wizards or edit the SQL directly, they enable you to display information from multiple tables as well as single tables. They form the basis of forms and reports, and without them databases would be essentially useless for obtaining any real relevant data from. In the end, databases are serious business for Database Developers and Consultants whether they use Microsoft Access or another type of DBMS, and queries form an important cornerstone.