Question about Microsoft Office Standard for PC

1 Answer

Creating a report

I have a database which shows students list, with marks and pass %. I want to create a report based on this on another sheet. Whenever I update the source file, I need automatic updation in the destination file

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points


    An expert that gotĀ 5 achievements.


    An expert who has achieved Level 3.


    An expert that hasĀ over 500 points.

  • Master
  • 461 Answers
Re: Creating a report

I assume you are using excel? to get the new sheet auto update try this formula =sheet1!C5 into the new cell in new sheet (eg. sheet2) whenever you update sheet one cell C5 it will automatically appear in new sheet...

Posted on Aug 29, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

N student details and sort the stures as per total marks ,by creating a structure to store the roll number,name,marks1,marks2,marks3

You need to create a database with six fields: Roll Number, Name, Marks1, Marks 2, Marks 3 and MarksT (sum of marks1+2+3)

Sort database on MarksT in decending order.

Easily one in Excel - other programs will be similar

Mar 09, 2015 | The Business & Productivity Software

2 Answers

Creating a new database using an MDF file

An MDF file isn't a backup file isn't the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks and then Attach Database.
When you do this you will get an error about the log file missing. This shouldn't matter as SQL Server will simply create a new log file for you.
This will only work if the SQL Server was stopped when you copied the MDF file from the old SQL Server. If you copied the file while the SQL Server was running this file probably will not attach either and you will need to get a valid backup of the database.
Download help tool for sql database - SQL Server Restore Toolbox.
You can read up more on SQL Server here.

Nov 16, 2014 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Application and example of relationship in access


After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

Having met the criteria above, follow these steps for creating relationships between tables.
  1. In the database window view, at the top, click on Tools ---> Relationships
  2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
  3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
  4. Select Enforce Referential Integrity
    • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
    • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
  5. Click Create and Save the Relationship

Apr 09, 2009 | Microsoft Business & Productivity Software

1 Answer

Favorite list on the screen

Internet Explorer favorites are used to save links to sites that you want to visit again. Creating a list of favorites allows you to visit those sites with a single click, rather than having to type the site's URL each time you want to visit it.
arrow.jpgCreating Favorites
  1. Open the site you want to mark as a favorite
  2. From the toolbar, click ADD TO FAVORITESnew-fave.gif» select Add to Favorites...
    The Add a Favorite dialog box appears.

  3. OPTIONAL: In the Name text box, type a new name
    NOTE: Favorites are listed alphabetically by the first word of the name.
  4. OPTIONAL: To place this favorite in an existing folder, in the Create in pull-down list, select the desired folder
    To create a new folder for this favorite
    1. Click NEW FOLDER
      The Create a Folder dialog box appears.
    2. In the Folder Name text box, type a name for the new folder
    3. To create this folder within another folder, in the Create in pull-down list, select the desired folder
    4. Click CREATE
  5. Click ADD
    The site is saved in the Favorites Center list.

Apr 02, 2009 | Microsoft Office Standard 2007: Windows

4 Answers

How get sql data backup

there is facility in enterprise manager to take back of database!

Feb 04, 2009 | Keystone Active Server Pages (ASP)/Visual...

1 Answer

I have Microsoft 2007...where can I make a database for labels?

Go to tools and goto the print labels and start a new label. It will ask you to creat one or merge from a data base and at that point you can create your own. Save it and then you will use Data merge to merge it back into the document.

I ask you to do it this way, since you will ultimately use it in this capacity.

Dec 21, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

After installing DB2 query is not executing

could you check whether you are connected to the database, where you are trying to create table,

check the database list, then connect to the database you want then execute the table creation ddl,
if no db found then create a database then proceed.

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

I installed DB2 in my laptop . then i go to all programs->DBCOPY1(default)-> command line tools -> command editor then write down query to create a table but i cant build it it is showing CREATE TABLE...


Before you create a table you need to:-

1. create a database
2. create a username and password or use the admin generated userid
3. connect to the database

you can then create a table and use the database

Please post if you do not know how to do this and i'll give you some links

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

How to create database in

you can create static data base in Excel works heet and link each cell to another sheet.
or you can create a dynamic data base in access. you need a MS access book. there are lots link you need to understand in order to have a working data base.

Nov 28, 2008 | Microsoft Business & Productivity Software

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

91 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides