Microsoft Access Basics Certificate for Gabriel Chamera
Add to LinkedIn
Certificate ID:
518313
Authentication Code:
1bd91
Certified Person Name:
Gabriel Chamera
Trainer Name:
Sławomir Broda
Duration Days:
3
Duration Hours:
21
Course Name:
Microsoft Access Basics
Course Date:
23 November 2016 09:00 to 24 November 2016 17:00
Course Outline:
Database Fundamentals
- Analysis of the current system
- Define database items
- Normalization
- Relations between the elements
- Naming standards
- Create a database
- Methods for creating arrays (Design View, Wizard, Inputting Data)
- Data types
- Field properties
Records and operations records
- Adding and editing a record
- setting the record
- Search record
- Copying tables
Create a relational database
- Keys
- Relations tables
- Dependencies
Queries
- Create queries
- Using the Query Wizard
- Operations on the results of the query
- criteria query
- Calculations and operators in queries
Forms and controls
- Types of controls
- Using AutoForm
- Using the wizard forms (Form Wizard)
- Properties of controls and forms
- Printing forms.
- Create a subform (Subform)
- Headers and footers
Reports
- Create reports.
- Using AutoReport
- Using the Report Wizard (Report Wizard)
- Sections
- Properties reports
Additional tools for forms and reports
- AutoFormat
- Special Effects
- Open a form at runtime database
- Adding graphics, spell check
- Switchboards
Exporting, importing and linking data
Security
- Passwords
- Database encryption
- Security Wizard
Backups
Course Name Eng:
Access - Data Base Designing