Login

MS Access Tables and Queries for Beginner

Get 92% Discount | CPD Accredited | Affordable Pricing | No Hidden Charges | 24/7 Tutor Support | Instant Access
4.8
9 Reviews

stds29 Students

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49. FIND OUT MORE

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This MS Access Tables and Queries for Beginner has been specially designed to help learners gain a good command of MS Access Tables and Queries, providing them with a solid foundation of knowledge to become a qualified professional.

Through this MS Access Tables and Queries for Beginner, you will gain both practical and theoretical understanding of MS Access Tables and Queries that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.

Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals. 

Curriculum

  • play Tour of the screen
    play 00:11:00
  • play Using Design view to create and edit tables
    play 00:45:00
  • play Using the lookup wizard
    play 00:09:00
  • play Importing data from Other Data Sources into Access
    play 00:18:00
  • play Linking Tables from Other data Sources into Access
    play 00:10:00
  • play Exporting data from Access to other data types
    play 00:03:00
  • play Creating and Managing Table Relationships
    play 00:10:00
  • play Database Tools
    play 00:05:00
  • play Sort and Filter a Table
    play 00:06:00
  • play Basic Queries
    play 00:22:00
  • play Prompting the user for the criteria
    play 00:05:00
  • play Creating Calculated Fields in a Query
    play 00:10:00
  • play Creating Totals Queries
    play 00:08:00
  • play Multiple table Queries
    play 00:12:00
  • play Viewing the SQL code for an Access Query
    play 00:06:00
  • play Using the Query Wizards
    play 00:09:00
  • play Creating Subqueries
    play 00:03:00
  • play Creating Make Table, Append, Update and Delete Queries
    play 00:19:00
  • play Displaying a certain number of records
    play 00:01:00
top