A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how to create a customised table layout???



 
 
Thread Tools Display Modes
  #1  
Old September 4th, 2005, 05:19 AM
Abhishek
external usenet poster
 
Posts: n/a
Default how to create a customised table layout???

I want to create a different table layout using ms access.apart from the
layouts present, is it not possible for me to create a customised layout of
my wish
  #2  
Old September 4th, 2005, 06:21 AM
Steve Schapel
external usenet poster
 
Posts: n/a
Default

Abhishek,

Can you say what specifically you want to do but can't?

User interface options and data manipulation options are relatively
limited for tables. That is because tables are generally used for
background data storage, and not normally for human consumption in
production usage. Forms are for data entry/editing/viewing, so perhaps
you will be able to do what you want with a form if you can't do it with
a table?

--
Steve Schapel, Microsoft Access MVP

Abhishek wrote:
I want to create a different table layout using ms access.apart from the
layouts present, is it not possible for me to create a customised layout of
my wish

  #3  
Old September 4th, 2005, 06:37 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Sat, 3 Sep 2005 21:19:02 -0700, "Abhishek"
wrote:

I want to create a different table layout using ms access.apart from the
layouts present, is it not possible for me to create a customised layout of
my wish


If by "layout" you mean a display (perhaps editable, perhaps not) of
the data in your table, the proper tool is a Form.

Table datasheets are not designed for data display or editing. They're
very limited in their capabilities.

Forms, on the other hand, are EXTREMELY flexible and can be used to
"lay out" the data in your table (or tables) in a vast variety of
ways.


John W. Vinson[MVP]
  #4  
Old September 8th, 2005, 05:31 AM
Vincent Johns
external usenet poster
 
Posts: n/a
Default

John Vinson wrote:

On Sat, 3 Sep 2005 21:19:02 -0700, "Abhishek"
wrote:


I want to create a different table layout using ms access.apart from the
layouts present, is it not possible for me to create a customised layout of
my wish



If by "layout" you mean a display (perhaps editable, perhaps not) of
the data in your table, the proper tool is a Form.

Table datasheets are not designed for data display or editing. They're
very limited in their capabilities.

Forms, on the other hand, are EXTREMELY flexible and can be used to
"lay out" the data in your table (or tables) in a vast variety of
ways.

John W. Vinson[MVP]


Although I agree that forms are more flexible than tables for data
entry, I don't always find them to be the best solution. For example,
if I will be making entries to a table only a limited number of times,
constructing a Form may take more effort than it's worth, at least
initially. I can always add a nice Form later. The Form Wizard will
give you a Form, but there won't be anything extremely flexible about
the results -- you'll have to do some tweaking to get the flexibility.

What I frequently do, and I often do this even if I'm going to set up a
Form later, is to define a "Lookup" query for each field that might be
not very intuitive, including all foreign keys matching Autonumber fields.

For example, suppose I have an [Employees] Table with fields
[EmployeeID], [FirstName], and [LastName], among others. To link to it
from another Table, I define a [Q_LookupEmployeeID] query, with just two
fields, as:

SELECT Employees.EmployeeID, [LastName] & ", " & [FirstName] AS Name
FROM Employees;

Then I add to each new related table an [EmployeeID] field of type
Number and set its Lookup property as follows:

Display Control: List Box
Row Source: Q_LookupEmployeeID
Bound Column: 1
Column Count: 2
Column Heads: No
Column Widths: 0;1

(You don't need to type this stuff more than once; to add the same field
to other tables, just copy the field's row in Design View and paste it
into the other table's Design View.)

Then I can start populating my new Table right away without having to
deal with ugly numeric keys. Instead of typing in employee number 3382,
I select (or begin typing) "Gates, Bill". This behavior migrates easily
to Queries, Forms, and Reports, and it's quick and easy to set up.
(Queries and Forms can be displayed in Datasheet View, too.) And
Datasheet View has the advantage over most Forms of being more compact
-- you can see more fields and records at one time, usually.

===

Another quick-and-dirty approach to data entry is to use an Excel
worksheet to populate the table -- Excel has a number of data-entry
shortcuts built in that you don't get in Access datasheets -- and then
import the finished table from Excel into Access. I frequently do this.

===

As another option, you might choose to *maintain* your table in Excel,
and just link to it in Access. This would be useful if you need to do
lots of arithmetic (or charts, PivotTables, or optimizations), or if you
have to re-filter your data frequently, as I think Excel's "AutoFilter"
facility is much easier to use than Access filters. But it requires you
to maintain two separate files for your data, which can be a nuisance.

-- Vincent Johns
Please feel free to quote anything I say here.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a table of unique records from two or more tables Rubble Running & Setting Up Queries 5 June 23rd, 2005 12:05 PM
Mixed up with Relationships..help! KrazyRed New Users 3 January 26th, 2005 06:03 AM
Manual line break spaces on TOC or Table of tables Eric Page Layout 9 October 29th, 2004 04:42 PM
Here's a shocker Mike Labosh General Discussion 2 October 26th, 2004 05:04 PM
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. HDW Database Design 3 October 16th, 2004 03:42 AM


All times are GMT +1. The time now is 08:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.