MS Access Table and Queries Series 1

MS Access Table and Queries Series 1

• This course is talking about MS ACCESS TABLES and QUERIES in detail. Program is for those students who want to learn ms access and take their knowledge to new heights.

• What are the Tables- Their use, how to design them.

• Why we use the Tables- Import and Export the data from external sources like text file, excel file, csv files and other sources like ms access itself.

• Use of saving import and export steps 

• Validation and rules concept while designing the Tables - in depth discussion

• Select query with so many different examples including the SQL statement of same

• Update - Delete- Append- cross tab- Make Table - update - drop query - all action and select queries are discussed with examples

• Use of operators like in , not in, <>, wild characters (*,?) , between,> ,< signs

• How to use query wizard to find out unmatched records or duplicate records .

• How to use Group option in queries.

• Use of Sub- queries.

• Project discussion in the end so that what we have learn can be easily understood .How it works in real life.

• I am available for any type of query or doubt if you have. All the best.

Know Tables and Queries

Url: View Details

What you will learn

• You will be able to store the information in access tables
• you will know the tables and different types of queries as well. Basically this course will easy your work when you deal with millions of rows.
• Complex information can be retrieved using select queries and data can be manages very well using action queries like update,append,delete, cross tab etc.

Rating: 4.55

Level: All Levels

Duration: 9.5 hours

Instructor: ajay parmar