S07.Access2010 - Access 2010 Microsoft Access 2010 is a...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Access® 2010 is a database application that is ideal for gathering and understanding data that’s been collected on just about anything – from customers and employees, to inventory, services, and events. Access 2010 Skills > Access 2010 In this section: Overview of Databases Database Tables Datasheets and Forms Queries and Reports
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Access is Microsoft’s relational database management program. It’s designed to help users create databases – collections of data – for later retrieval, manipulation, and reporting of that data to support problem-solving and decision making activities. To use a database, though, you don’t have to be its creator. In fact, most of the time we aren’t even aware that we are using a database when we search for something online, ask a store clerk to check the status of an out-of-stock item, use library resources to find books, or buy an airline ticket. Overview of Databases Skills > Access 2010 > Overview of Databases In this section: Database Management Tools and Features Effective Database Management Database Uses Creating and Saving Databases
Background image of page 2
Spreadsheet Tools and Features Skills > Access 2010 > Overview of Databases > Spreadsheet Tools and Features Access 2010 helps users collect and manage data for easy retrieval and use. Using Access you can collect, retrieve and edit data and create reports summarizing your data. The Navigation pane is on the left. It lists all database objects, such as tables, queries, forms and reports. You open an object by double-clicking it in the Navigation pane. The data in a database are organized in tables. Within a table, each row, or record, contains data related to a person, place, item, event or idea. In this table, each record contains data about a particular person. The columns in a table are called fields. Each record contains data from each of the fields.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Spreadsheet Tools and Features Skills > Access 2010 > Overview of Databases > Spreadsheet Tools and Features A query is a question we ask to extract an answer from the data stored in the database. Forms are templates used to enter, maintain and print records in a database. Forms make it easy to enter data into the various tables in a database. The last type of object is a report, which is a formatted printout or display summarizing the data.
Background image of page 4
Spreadsheet Tools and Features Skills > Access 2010 > Overview of Databases > Spreadsheet Tools and Features
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Effective Database Management Skills > Access 2010 > Overview of Databases > Effective Database Management The rows in a database table are called records. Each record contains data relating to a single entity. The columns in a database table are called fields. Each field holds a
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/27/2011 for the course BCIS 1301 taught by Professor Connor during the Spring '11 term at Lone Star College System.

Page1 / 35

S07.Access2010 - Access 2010 Microsoft Access 2010 is a...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online