Question about Microsoft SQL Server Standard Edition for PC

1 Answer

View how many tables can we use for creating view

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 17 Answers
Re: view

Views are essentially pre-written select statements, and select statements are limited to 256 tables.

There are a couple of other limits on views as well:

The number of columns in the view is limited to 1024.

Views can be nested (that is, a view selecting out of another view) 32 levels deep.

Posted on Jan 22, 2008

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

Having troube with my FOREIGN KEYs on two tables.

I suggest you visit this website you will get the solution, I tried and it worked.

Nov 25, 2013 | Business & Productivity Software

1 Answer

How to invoke a ms.access using parser

To parse a Text field that contains two words separated by a comma, follow these steps:
  1. Open any existing database.
  2. Create a table with the following structure: Table: Parse2Words
    Field Name: Empl
    Data Type: Text
  3. View the Parse2Words table in Datasheet view and type the following three records in the Empl field: Smith, John
    Callahan, Laura
    Fuller, Andrew
  4. Create the following query based on the Parse2Words table: Query: QueryTest
    Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1)
    Show: True
    Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1)
    Show: True

    NOTE: You can modify the QueryTest query to account for spaces between the two parts in the Empl field. For example, if the text in the Empl field is "Smith,John" without spaces, remove the -1 from the FirstName field expression.
  5. Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below: FirstName LastName
    John Smith
    Laura Callahan
    Andrew Fuller

Jan 08, 2011 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Creating tables

this is how to create a table

  1. Click where you want to insert a table.on you work sheet
  2. click On the Insert tab, in the Tables group, click Table,
  3. Replace the data in the template with the data that you want.i.e the number of rows and columns you want
that is it

Apr 28, 2010 | Microsoft Office 2003 Basic 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

Data From Table Auto Fill

You need to create 2 tables. Create one table with just the Center Number, County and Center fields, using the Center Number as the primary key, lets call this table Center. Then create the other table with all the other fields you need, lets just call it the Main table for now.
Then create a relationship between the Center table and the Main table using the Center Number for the relationship. The relationship should be a One-to-Many from the Main to teh Center table. When creating the form, you take the fields from both tables. When you input the Center Number, the County and Center should be automatically filled in.

Apr 08, 2009 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Creating a table in Ms-Access

Have you tried to name the table Tiny_tots? it might make it work. Sometimes programs are funny about letting you have spaces in the name.

Oct 04, 2008 | Microsoft Office Standard for PC

1 Answer

Access 2007 forms wizard

If you run a repair install of office 2003

Jun 04, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

How we can create Forms & queries in access

For forms, open a data table in view mode, while there locate the forms setup wizard. For your first try just answer the questions the best you can for the wizard. When there are no more questions to answer wizard will create a form for you. From what you learn doing that you may get enough hints to make a form from scratch. Just keep in mind you always build a form from the fields in a table.
Now for the Query, start out the same way and use the wizard. Query to most folks means ask a question and get an answer. In access query is a way to present sub sets of data or ways to modify data in the fields of your tables.

Jun 03, 2008 | Microsoft Business & Productivity Software

1 Answer

Hyperlink function in ms access

To Create a Hyperlink Field:

Display the table in Design view, create a new field to store the hyperlinks, click the new hyperlink field's Data Type box, click the list arrow, select Hyperlink, and save the table.
To Insert a Hyperlink:

Select the hyperlink field and then click the Insert Hyperlink button on the toolbar or select Insert , Hyperlink from the menu. Either select a file you want (use the Browse button to help you locate the file) or type a Web address for the hyperlink's destination and click OK.

To edit a Hyperlink: Right-click the hyperlink and select Hyperlink , Edit Hyperlink from the shortcut menu.

Is this enough?

Dec 21, 2007 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Excel Pivot view

Highlight the entire pivot table and name it as a range. Then in the formula, replace the reference to the table addresses with the range name. Then wherever you move the table (move, not cut and paste) it will automatically gather the right data. Thanks for rating FixYa!

Oct 19, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

Related Topics:

146 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

18258 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