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

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    MVP:

    An expert that gotĀ 5 achievements.

    Master:

    An expert who has achieved Level 3.

    Sergeant:

    An expert that hasĀ over 500 points.

  • Master
  • 461 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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 Computers & Internet

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.
http://www.sqlserver.restoretools.com/
You can read up more on SQL Server here.
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/498-creating-a-new-database-using-an-mdf-file?_=1416149856104/

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

1 Answer

How to print database in vb


To Print a Database you would require to create a Report. There were many ways of creating reports in Visual Basic 6.0. Hereby I am giving you an example of Data Report.
Printing a Data Report
Printing a data report can be accomplished in one of two ways. The user can click the Print button that appears on the data report in Print Preview mode (using the Show method), or you can programmatically enable printing using the PrintReport method. If an error occurs during printing, trap it in the Error event.
Choosing to Display a Print Dialog Box
When printing a report programmatically, you have two choices: to print by displaying the Print dialog box, or by printing without displaying the dialog box.
To display the Print dialog box
  1. Add a CommandButton to a Form.
  2. In the button's Click event, place the following code.
DataReport1.PrintReport True The Print dialog box allows the user to select a printer, print to file, select a range of pages to print, and specify the number of copies to print.
Note Printers must be installed on the computer in order to present a choice of printers.

Printing Without a Dialog Box
In some cases, you may wish to print the report without user intervention. The PrintReport method also gives you the option of selecting a range of pages to print, either all, or a specified range.
To print without displaying the dialog box
  1. Add a CommandButton to a Form.
  2. In the button's Click event, place the following code:
DataReport1.PrintReport False
Or, to specify a range of pages to print, use the code below:
DataReport1.PrintReport False, rptRangeFromTo, 1, 2

Mar 11, 2014 | Microsoft Visual Basic 6.0 for PC

1 Answer

How to create crystal report in asp.net with vb script code


You can open the Crystal Report (should be installed with Visual Studio first) after you designed your database, then you have to connect the Crystal Report to the right database (the one which you store financial information in your case), then you can create your report easily by putting the desired variables and designs. Then you have to call for that report with a code within visual basic.

Apr 15, 2009 | Computers & Internet

1 Answer

Application and example of relationship in access


Relationships

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.)
    relationshipdrag.jpg
  4. Select Enforce Referential Integrity
    refintegrity.jpg
    • 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 Computers & Internet

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

How to create database in m.s.office


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 Computers & Internet

2 Answers

Sony NWZ-B105 - Creating Database problem


hola amigos esto es bueno un besito muuua*

Aug 23, 2008 | Sony NWZ-B103FBLK MP3 Player

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

99 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2679 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...