The goal of the training is to introduce the participants to issues concerning databases in Access and develop skills in the efficient software use in everyday work.
During the course the participants will learn how to create tables, queries and forms.
Tables determine database structure, forms make it easier to insert whole records to the database, queries allow to analyze data sets whereas reports help in publication and presenting data set analysis.
Knowing the database structure in Access will allow fast large data set analysis.
The training is delivered as a computer workshop.
The participants of the training will receive training materials which are necessary to gain skills in Access usage. The training materials consist of:
- Script prepared by AkKom Computer Academy specialists in which the theoretical and practical aspects of Access are discussed
- Specially-prepared set of exercises in Access, which is a necessary supplement to the script.
What is more, the participants of the training are offered free-of-charge consultations with our trainer via e-mail or phone - up to 3 months after completing the training.
Introduction to databases
- Basic terms
- MS Access specification
- Windows in MS Access
- Database objects
Menu and toolbars
- Menu functions
- Toolbar control
- Software help
Work in existing databases
- Adding records to the database
- Record selection
- Table adjusting ( column width, row height ) blocking and hiding columns
- Copying, deleting and data re-locating
- Using basic and sub-forms for data entry
- Searching for records, filtering, sorting
- Creating address labels and mail merge
Tables
- Rules of table naming
- Table wizard usage
- Field defining
- Table project modifications
- Field properties
- Opening, copying, saving, name changing and table deletion
- Table data sheet - Inserting and modifying data
- Sorting data
- Basic keys usage
Queries
- Queries usage
- Query wizard
- Creating and modifying simple queries
Forms
- Basic information on forms
- Form wizard
- Creating simple forms
- Opening, copying, saving and form deletion
- Selected form properties
- Printing
Reports
- Report usage
- Report wizard
- Creating simple reports
- Opening, copying, saving and report deletion
- Report printing
Zapisz się na interesujący Cię termin szkolenia
There are currently no training dates
