ميكروسوفت أكسس

About Access Course

Microsoft Access is used for different kinds of data handling work. In any academic institution, Microsoft Access can be used to create and manage the data record of students. In any company, Microsoft Access can be used to create and manage the data record of employees. Or in any business, you can use Microsoft Access to create and manage the database sheet for your employees, inventory, goods, or products. Other than these you can use Microsoft Access for any kind of data handling work. You have to just create the fields in MS Access for different data records.

Access course is designed for people who are used to managing data in spreadsheets but wish to understand why and how a database will provide a better solution. The course covers the difference between spreadsheets and databases and takes students through the process of creating a database, from design through to data population. In the second part of the course, students learn the fundamentals of the SQL query language and gain a full understanding of how to write queries in Access for retrieving and updating data.

Access Course Objectives:

This course provides an introduction to the basic concepts of Microsoft Access. On completion of this course, the delegate will be able to use an existing Access Database effectively and be able to create and modify simple Tables, Queries, Forms and Reports. This course provides a foundation for the Access Level 2 course which is recommended for anyone planning to design and create any but the simplest database.

Access Course Designed for:

This course is suitable for delegates who wish to learn to use databases effectively and to create simple databases for single-user use. No previous knowledge of Access is assumed, but delegates should be familiar with using one or more of the other programs in the Microsoft Office suite.

Access Course Description:

The course covers the essential skills required to create and manage a simple database, and introduces the concepts of good database design. It deals with creating and using Tables and their Relationships, Queries, Forms and Reports and shows how these can be combined into a simple but effective application. It also discusses some of the issues involved with managing databases.

You'll learn in Access Course :

· All about databases and how they work.
· An understanding of how Access works to make even its complex inner workings seem simple.
· How to navigate Access.
· How to create tables, forms, reports, and queries.
· How to enter criteria into your data.
· How to form expressions and create functions.
· How to customize the appearance of forms and reports.
· How to use Access for home-record keeping or for a business And much, much more.