Course Description
What You'll Learn
- Create databases, tables, forms, and reports in Access 2010
- Plan, create, edit, and enter data into tables using appropriate data types
- Search your database using effective queries and filter records
- Import data from Excel and print tables
- Relate tables and apply referential integrity
- Navigate Access objects, ribbons, and the Help feature, and work with macros and modules
Key Takeaways
- This introductory course covers the basics of database creation and management in Access 2010.
- It teaches the daily tasks associated with any database, including creating databases, tables, forms, and reports.
- Learners practice filtering records and searching a database with effective queries.
- The course covers table planning, creation, editing, data entry, data types, and table templates.
- It addresses table design, importing from Excel, printing tables, relating tables, and referential integrity.
Frequently Asked Questions
What does this Access 2010 course cover?
It covers the basics of database creation and management, including creating databases, tables, forms, and reports, filtering records, and searching your database with effective queries.
Is this course suitable for beginners?
Yes. It is an introductory Access 2010 course that explores the basics of database creation and management.
What skills will I gain from this course?
You will gain skills in Access query languages, data access, database administration, database management, database programming, and Microsoft Access.
Does the course cover working with tables in detail?
Yes. It covers table components, planning tables, creating and editing tables, entering table data, data types, table templates, table design, importing from Excel, printing tables, relating tables, and referential integrity.
Does this course include queries and reports?
Yes. The lessons include queries, forms, and reports, along with macros and modules and searching for Access objects.
