Suitable for: Anyone needing to learn how to use an Access Database to enter, manage and run reports on large amounts of data. Objectives: Acquire the essential skills to open and interrogate an existing database. Develop awareness of the importance of planning and database design prior to creating and saving a new database.
Understand Data Types and employ methods to ensure easy, accurate and efficient data entry. Create and enter data using tables and forms. Use queries to interrogate and extract data. Produce reports for presentation purposes. to enter, manage and run reports on large amounts of data. In this tutorial, you will learn the essential skills needed to use a database including entering data into forms and tables, running queries to search data and producing meaningful reports. Course Content: Overview of databases and introduction to tables, forms, queries and reports Managing database objects Creating, naming and saving a Database and related objects Understanding data types Data validation rules Creating tables Entering data using tables (and forms) and understasnding the appropriate use and advantages of each Creating and modifying forms Working with tables and forms Creating a simple query Query design options Queries with multi-criteria Creating and running other types of queries Creating, modifying and printing reports Summary and roundup of key points |