SQL Server Tables

You can view and manage SQL Server tables from the Tables node of the Database Window in your Access Project. Figure 9.11 is an example of a SQL Server table opened from within Access.

From looking at the data in Figure 9.11, you would not know that it physically resides in a SQL Server database. This screen looks very similar to the other screens you have seen before with local Access tables. Now, if you open a SQL Server table in design view, a screen similar to the one shown in Figure 9.12 appears.

The table designer is a bit different from the one you have worked with before. Notice how some additional columns for Length and Allow Nulls have been added. SQL Server also has some data types other than the standard Access tables.

J authors : Table

au id

au Iname

au fname

phone

address

a

+

172-32-1176

White

Johnson

408 496-7223

10932 Bigge Rd Msnlc

1

213-4(5-8915

Green

Marjorie

415 986-7020

309 63rd St #4 Qakla

=

+

238-S5-7766

Carson

Cheryl

415 548-7723

589 Darwin Ln Berke

+

26741-2394

Q'Leary

Michael

408 286-2428

22 Cleveland Av San J

+

274-80-9391

Straight

Dean

415 834-2919

5420 College A\ Oakla

*

341-22-1782

Smith

Meander

913 843-0462

10 MissiSisippi [ Lavvie

+

409-58-7008

Bennet

Abraham

415 658-9932

6223 Bateman i Berke

+

427-17-2315

Dull

Ann

415 836-7128

3410 Blonde St F'alo

+

472-27-2349

Gringlesby

Burt

707 938-6445

PO Box 792 Coveh

+

486-29-1786

Locksley

Charlene

415 585-4620

18 Broadway A\ San F

v

Record: H | 1

i LLJLMJIiĆ¢) M J of 23

r<T"" i i>i

Figure 9.11

J] authors: Table

Column Name

Data Type

Length

Allow Nulls

Description a

au_id

id (vardiar)

11

9

aujname

varchar

40

au_fname

varchar

20

phone

char

12

address

varchar

40

city

varchar

20

v1

state

char

2

%

zip

char

5

contract

bit

1

0

<

JLI

Lookup

Columns

Default Value

Lookup

Formula

Collation Format

Input Mask

^database defaults

0 0

Post a comment