Booking Enquiry
Microsoft Access 2010 - Level 1
Overview
After an introduction to database concepts, Access environment and help systems, students will learn how to design and create databases. They will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules.
Who Should Attend?
This course is intended for individuals who would like to become proficient in creating database tables,queries, forms, and reports, and in sorting and filtering data in Access.
Course Outcome
On completion of this course, students will be able to:
- Organize data efficiently by using a database management system
- Plan and create a database
- Modify a table's design
- Set field properties
- Create queries and sort and filter the results,
_ Create, modify and work with forms, as well as create, modify and print reports.
Course Content:
Lesson 1:Getting started
- Database concepts
- Exploring the Access environment
- Getting help
Lesson 2: Databases and tables
- Planning and designing databases
- Exploring tables
- Creating tables
Lesson 3: Fields and records
- Changing the design of a table
- Finding and editing records
- Organizing records
Lesson 4: Data entry rules
- Setting field properties
- Working with input masks
- Setting validation rules
Lesson 5: Basic queries
- Creating and using queries
- Modifying query results and queries
- Performing operations in queries
Lesson 6: Using forms
- Creating forms
- Using Design view
- Sorting and filtering records
Lesson 7: Working with reports
- Creating reports
- Modifying and printing reports
What happens next?
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
© 2024 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy
