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

Info icon This 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
Image of page 1

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

View Full Document Right 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
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.
Image of page 3

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

View Full Document Right 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.
Image of page 4
Spreadsheet Tools and Features Skills > Access 2010 > Overview of Databases > Spreadsheet Tools and Features
Image of page 5

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

View Full Document Right 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 different kind of data.
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern