Learn Microsoft Access Step by Step, Level 2 (50533)
Cours disponible en français ou en anglais - Training available in French or in English
Duration: 1 day
Objectives :
This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Access .
Course Details:
Les stagiaires seront à même d'effectuer les tâches suivantes :
Requirements:
Before attending this course, students must have:
Cours disponible en français ou en anglais - Training available in French or in English
Duration: 1 day
Objectives :
This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Access .
Course Details:
Les stagiaires seront à même d'effectuer les tâches suivantes :
- Restrict the type and amount of data entered into a field.
- Require that data entered in a field be in a certain format.
- Use validation rules to prohibit invalid data.
- Limit the options for entering information in a database.
- Create a list of possible values for a field from the entries in a field in a related table
- Work in Design view to modify a form.
- Customize forms by adding controls.
- Use subforms to enter data in more than one table
- Create queries to find records and create calculated fields.
- Summarize matched records.
- Have Access update and delete records
- Create reports to extract information from a database.
- Customize the appearance and contents of a report.
- Insert a subreport within a report and perform calculations in it.
Requirements:
Before attending this course, students must have:
- Basic computer knowledge.
- Basic file-management skills.