Access 2010 Basic

Microsoft Access 2010 Basic course details

Target student

Students will get the most out of this course if their goal is to become proficient in creating database
tables, queries, forms, and reports, and in sorting and filtering data in Microsoft Access 2010.
The target student for this course should be comfortable using a personal computer and Microsoft Windows.

After completing this course, students will know how to:

• Organize data efficiently by using a database management system; start Access 2010,
  open Access 2010 databases, and identify components of the Access window; and use
  the Help feature.
• Plan and create a database; use Datasheet view and Design view; create, modify,
  and work in tables; and set the primary key for a table.
• Modify a table’s design; use the Attachment data type; find and replace values;
  and sort, filter, and delete records.
• Set field properties; create input masks; and set validation rules.
• Create queries, and sort and filter the results; modify queries; and perform
  operations in queries.
• Create, modify, and work with forms; and use them to sort and filter records.
• Create, modify, and print reports; and add summary fields to a report.

Microsoft Access 2010, a component of the Microsoft Office suite, is a database management program: an application that stores and organizes data and makes data retrieval efficient. A database is an organized collection of data, or information. An example of a simple database is a phone book that contains the names, phone numbers, and addresses of individuals and businesses. queries, reports, forms, filters, sort, table, datasheet, records, database, primary key, queries, reports, forms, filters, sort, table, datasheet, records, database, primary key Microsoft Access 2010, a component of the Microsoft Office suite, is a database management program: an application that stores and organizes data and makes data retrieval efficient. A database is an organized collection of data, or information.