Index L

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

L (input mask) placeholder 
Label button (Toolbox) 
Label Wizard  2nd  3rd  4th  5th 
labels
    adding
        to forms  2nd  3rd  4th 
        to tab control pages  2nd 
    DAP labels 
        aligning text 
        alignment, setting 
        as hyperlinks  2nd 
        as record navigation controls  2nd 
        color, changing 
        editing  2nd 
        font attributes, setting 
        moving  2nd 
        moving to captions  2nd  3rd  4th  5th 
        record navigation control, changing  2nd  3rd 
    formatting text  2nd  3rd  4th  5th  6th 
    graph labels
        font size, changing  2nd  3rd 
        reversing 
    mailing labels
        creating  2nd  3rd  4th  5th 
        editing  2nd  3rd  4th  5th  6th  7th 
    moving 
    VBA  2nd 
Last function 
Layout Wizard
    tabular pages, creating  2nd  3rd 
LCase function 
Left function 
left outer joins  2nd  [See also outer joins]3rd  4th 
Len function 
Length property
    Table Design window 
less than (<) operator 
less than or equal to (<=) operator 
Leszynski Naming Conventions
    for Access 
libraries  2nd 
    missing libraries, troubleshooting 
licensing
    john add entries 
    MSDE 
    Software Assurance
        and Licensing terms 
    SQL Server  2nd 
lifetime of VBA variables  2nd 
Like operator  2nd  3rd 
LIKE operator (T-SQL)  2nd 
Line button (Toolbox) 
line graphs  2nd 
    adding to reports  2nd  3rd  4th 
    changing graph type  2nd  3rd  4th 
    creating
        from crosstab queries  2nd  3rd  4th  5th  6th  7th  8th  9th 
        with Chart Wizard  2nd  3rd  4th  5th  6th  7th  8th 
    modifying design  2nd  3rd  4th  5th 
    query data source
        Chart Wizard  2nd  3rd  4th  5th 
        crosstab queries  2nd  3rd 
line spacing
    reports  2nd  3rd 
line-item sources 
Line/Border button
    Datasheet Formatting toolbar 
Link Child Fields property
    Table Properties window 
Link dialog box  2nd  3rd  4th 
Link Master Fields property
    Table Properties window 
Link Sharepoint Team
    Services Wizard  2nd  3rd 
Link Spreadsheet Wizard  2nd  3rd 
Link Table Wizard  2nd 
    Jet databases, linking to OLE DB providers  2nd  3rd  4th 
    SQL Server databases, linking to local MSDE  2nd  3rd  4th  5th 
Link Tables dialog box  2nd  3rd 
linked graphs  2nd 
    assigning crosstab queries  2nd 
    designing crosstab queries  2nd  3rd 
    linking to records  2nd  3rd  4th  5th 
linked servers  2nd 
    Jet databases, linking to OLE DB providers  2nd  3rd  4th 
    SQL Server databases, linking to local MSDE  2nd  3rd  4th  5th 
Linked Table Manager  2nd  3rd  4th 
Linked Table Manager command 
Linked Table Wizard  2nd 
linking  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    images
        to OLE Object fields  2nd  3rd 
    PivotCharts  2nd 
        cloning linked forms/subforms  2nd  3rd 
        persisting linked properties  2nd  3rd 
        setting linked properties  2nd  3rd  4th  5th  6th  7th 
    spreadsheet files  2nd  3rd 
    subreport data to reports  2nd  3rd  4th  5th  6th 
    tables  [See also joining tables]
        four-part names 
        Oracle tables 
        Outlook folders  2nd  3rd  4th  5th 
        to WSS lists  2nd  3rd 
        WSS lists to  2nd  3rd  4th 
linking tables 
    converting field data types  2nd  3rd 
    Exchange folders  2nd  3rd  4th  5th 
    external ISAM tables  2nd  3rd  4th  5th  6th  7th 
    images, adding  2nd  3rd  4th  5th 
    multiuser applications  [See multiuser applications]
    relinking with Linked Table Manager  2nd  3rd 
    using Linked Table Manager 
    versus importing tables  2nd  3rd 
    Visual FoxPro tables  2nd  3rd  4th  5th  6th  7th 
List Box button (Toolbox) 
List Box Wizard  2nd  3rd  4th 
list boxes  2nd  3rd 
    adding
        Combo Box Wizard  2nd  3rd  4th  5th  6th  7th 
        to tab control pages  2nd 
    advantages  2nd  3rd 
    creating
        record-selection boxes  2nd  3rd  4th  5th  6th 
        static-value boxes  2nd  3rd  4th 
    in DSAs
        adding to forms  2nd  3rd  4th 
        drilling down from  2nd  3rd  4th  5th  6th  7th 
        john sb decision-support applications 
        selecting items  2nd  3rd  4th  5th  6th  7th  8th  9th 
    john verify pgs (combo boxes) 
    populating  2nd  3rd  4th  5th  6th 
        with XML data  2nd  3rd  4th  5th 
    versus combo boxes  2nd 
ListCount property 
literal string values
    enclosing in SQL 
literals  2nd  3rd  4th 
live Web reports  2nd  3rd 
    exporting 
    exporting as XML  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th 
    troubleshooting 
Load from Query button 
local scope 
LockType property
    Recordset object  2nd  3rd 
logical operators  2nd  3rd  4th 
logins, adding with OSQL  2nd  3rd  4th  5th  6th 
LogonID folder 
Long data type 
Long Integer data type  2nd 
    converting to other data types  2nd 
    relationships  2nd 
lookup combo boxes
    creating  2nd  3rd  4th  5th  6th  7th 
lookup fields  2nd  3rd  [See also subdatasheets]
    adding
        to reports  2nd  3rd  4th  5th 
    browse updating 
    fixed-value lists  2nd  3rd  4th 
    foreign-key lists  2nd  3rd  4th  5th  6th  7th 
    in tables saved as pages 
    properties, Table Design view 
lookup lists
    adding  2nd  3rd 
lookup operations  2nd  3rd 
Lookup page, Table Design view 
Lookup Wizard 
    fixed-value lists, adding  2nd  3rd  4th 
    foreign-key lists, adding  2nd  3rd  4th  5th  6th 
looping 
    Do Until...Loop statement  2nd  3rd 
    Do While...Loop statement  2nd  3rd 
    ensuring loop execution  2nd 
    For...Next statement  2nd  3rd 
    While...Wend loop 
loosely coupled Web services  2nd 
Lotus 1-2-3
    importing Lotus spreadsheet files  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th 
LTrim function