Brief Introduction
Learn the basics of building an Access database with well-built tables, queries, forms, and reports.Description
This course is an introduction to Microsoft Access 2013. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2013 Intermediate course.
Requirements
- Requirements
- Basic computer skills.
Knowledge
- Become familiar with various database components, concepts, and terminology.
- Become familiar with the Access user interface.
- Understand relational databases.
- Create and join tables.
- Understand field data types.
- Edit and modify tables.
- Filter and sort table data.
- Create simple queries.
- Work with criteria, wildcards and keywords.
- Perform multi-table queries.
- Design and create reports.
- Modify reports.
- Create labels.
- Create forms.
- Design and modify forms.
- Work with bound and unbound controls.