2003 2nd edition microsoft office

Spiral Bound. We're sorry! We don't recognize your username or password. Please try again. The work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. You have successfully signed out and will be required to sign back in should you need to download more resources.

Out of print. Exploring Microsoft Office , Volume 1, 2nd Edition. Robert T. If You're an Educator Download instructor resources Additional order info. New to This Edition. End-of-chapter exercises —All end-of-chapter exercises for each application chapter have been refreshed. Student CD bound in each copy of the text provides student with easy access to the necessary data files they will need to complete their assignments.

Gaining Proficiency: Editing and Formatting 3. Graphs and Charts: Delivering a Message 4. Spreadsheets in Decision Making: What If? Information from the Database: Reports and Queries 4. Share a link to All Resources. Instructor Resources. Websites and online courses. Other Student Resources. Previous editions. Exploring Microsoft Office Volume 1.

Sign In We're sorry! Username Password Forgot your username or password? Sign Up Already have an access code? Access also integrates well with other Office packages, and data transfer between Access and the other Office components is relatively easy. In addition, against the other desktop databases, Access is both rich in features and powerful.

Lastly, Access can be used by almost any user. Beginners can learn to use the wizards and the easy-to-understand interface while developers can push it to its limits and do some extraordinary things with it.

It is an application for everyone created with a mixed user level in mind. This chapter discusses the basics of designing and creating an efficient and productive database using Access. To open Microsoft Access, perform any one of the following steps:. Whenever you start Microsoft Office Access , you will see the Getting Started task pane, which enables to access online help and content, open existing database, and create a new database. To create a new database, click Create a new file on the Getting Started task pane.

This displays the New File task pane which provides various options for creating a blank database, opening an existing database, or navigating to any database stored on your computer or on a network drive see Figure The New section in the New File task pane provides the following options:.

To create a new database, follow the steps given below:. Figure Note: Unlike other Microsoft Office applications, an Access database must be saved before one starts working on it.

To open an existing database, follow the steps given below:. Note: Access database can also be opened by double-clicking the Access file icon placed on the specified location. After finishing all the work in Access database, you may want to close the database and exit Access.

For this, perform any of the steps given below:. Note: The extension of an Access database is. When you are working in Access, a temporary file is created with. This file can be ignored as it disappears as soon as the database is saved and closed.

In addition, a user cannot proceed further if the selected database has not been saved. When an Access database is created or opened, the main screen of the program appears see Figure This main window has many different parts, which are described in detail below.

Title Bar: The bar across the top of the application window is the title bar. It displays the name of the application. Menu Bar: Below the title bar is the menu bar, which contains different drop-down menus that allow the user to perform different functions in Access.

Toolbar: Generally, one or more toolbar appears just below the menu bar. The toolbar contains command buttons that provide single-click entry to carry out many commonly performed tasks. By default, Database toolbar is displayed in the Access environment.

Additional toolbars like Query Design and Relationship toolbars can be added by right-clicking on the menu bar and selecting the Customize option from the pop-up menu. Status Bar: The bar at the bottom of the Access window is the status bar which displays information specific to the task you are currently performing. Database Window: In the middle of the Access desktop window is the Database window, the command centre of Access environment. The purpose of this window is to provide access to the objects in the database and allow the user to create new ones.

At the top of the Database window is a bar which displays the name of the active database. The left side of the Database window has Objects and Groups section containing the list of objects that Access supports. It provides direct access to every object in the database. The options under Objects section are used to create, edit, or view the seven main object types in the Access database such as tables, reports, queries, and so on. Under Groups section, one can create shortcuts to the Objects in the database.

Database Objects: An Access database consists of a collection of tables, queries, forms, reports, pages, macros, and modules which are used to manage and present the data. These components are also called database objects.

A table is a collection of data and is the first object that is added to the database. It contains rows and columns. The data entered in a row is called a record. In Access, a table stores the information. Before we input the information, we must first create tables. There are quite a few ways to create Access tables. However, tables can be mainly created in Design view or using the Table Wizard.

Creating a table in Design view is very common because it offers several benefits. Design view allows you to define the fields in the table before adding any data to the datasheet.

The table's Design view window is divided into two parts: a top pane for entering the field name, data type, and an optional description of the field, and a bottom pane for specifying field properties. To create a table in Design view, follow the steps given below:.

Setting Primary Key: A primary key is a field whose value uniquely identifies each record of the table. In other words, when a field is set as a primary key it ensures that no two records in a table can have the same value. While it is optional to set a primary key, it is a good practice to create one. Access Data Types: While creating a table, one must assign a data type for each field. The data type determines the type of values one can enter for a field in a table. Table The Table Wizard helps the user to organize data by providing sample fields that one can include in a table and it assigns a primary key to each record.

Later, if a change is required in the design of a table, one can modify it using the Design view. To create a table using the Table Wizard, follow the steps given below:.

Once the table is created, you may want to add some records to it. To add or modify or delete records, you need to open the table. To open a table, double-click the table name or select the table from table list and then click the Open button on the Database window. Note that by default a table opens in Datasheet view. Adding and Modifying Records: Records can be added to the table in Datasheet view by typing in the record beside the asterisk that marks the new record.

To enter data in a table, follow the steps given below:. Deleting Records: To delete record s from a table, follow the steps given below:. When you open an access database, you see a list of tables contained in that database.

In the previous section, you learnt how to add, modify, or delete records in tables. This section explains how you can move around in a table in Datasheet view. Use the right arrow key or press Tab or Enter to move between the fields in the table. To move back a field at a time, press the left arrow key or press the Shift and Tab keys at the same time. The up and down arrow keys can be used to move between records.