Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources]

Alison Balter

نسخه متنی -صفحه : 544/ 539
نمايش فراداده

[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]

UCase function

UID keyword

unbound controls

Unbound Object Frame tool

unbound object frames

reports 2nd

unbound OLE objects

UNC

Hyperlink Address control property

hyperlink field type

UNC addresses

tables

Hyperlink field type 2nd 3rd

UNCs (universal naming conventions)

underlying recordsets

synchronizing forms with 2nd

underscore (_)

line continuation character

VBA

Undo event

forms

undoing actions

unhiding

tables

Relationships window

Unicode

Unicode Compression property (fields)

uniform resource locators [See creating

graphical QBE 2nd

sorting results

unique identifiers (tables)

Unique Records property

queries 2nd

Unique Values property

queries 2nd 3rd

Universal Naming Convention [See universal naming conventions (UNCs)

Unload event

forms 2nd

Unregister function

ActiveX controls

Unset Database Password dialog box

Update All command (Briefcase menu)

Update Data permission

Update method

Update queries 2nd

creating 2nd

Update Selection command (Briefcase menu)

UPDATE statement

SQL 2nd

Updated event

controls

updates

distributing

recordsets

batch updates 2nd

updating

dynasets

fields

multitable queries

query results 2nd

records

queries

Recordset objects

consistent compared to inconsistent 2nd

recordsets

single records 2nd

updating links (external data) 2nd 3rd 4th 5th 6th 7th

UpDown control 2nd

UpDown object

events 2nd

properties

upsizing

issues 2nd 3rd 4th

AutoNumber fields

case-sensitivity

default values 2nd

indexes 2nd

properties

relationships

reserved words

security

table/field names 2nd

tables 2nd

validation rules

VBA

preparation

wizards

drawbacks

Upsizing Wizard

URLs

(Universal Naming Convention)

Hyperlink Address control property

hyperlink field type

tables

Hyperlink field type 2nd 3rd

Use Access Special Keys option

user accounts

User and Group Accounts dialog box 2nd 3rd

User and Group Permissions dialog box 2nd 3rd

user groups

permissions

assigning

user interface

compacting databases 2nd 3rd

importing external data 2nd

linking external data 2nd 3rd 4th 5th 6th

User object

Data Access Object model

user rights

database permissions

implicit

modifying 2nd 3rd 4th

objects

user-defined errors

creating 2nd

user-defined routines

creating in class modules

creating in code modules 2nd

user-defined types 2nd 3rd 4th 5th 6th

declaring

Type variables

creating

retrieving data

storing form data 2nd

user-level security 2nd

Administrative User

adding to Admins group

assigning a password to

creating 2nd 3rd

removing from Admins group 2nd

databases

opening

implementing 2nd 3rd

logging on as system administrator 2nd

passwords

changing for Admin User 2nd

Security Wizard, running 2nd 3rd 4th 5th

users/groups

assigning rights 2nd 3rd 4th

creating 2nd 3rd 4th 5th

workgroups

creating 2nd 3rd 4th 5th 6th 7th

User-Level Security Wizard

UserCommitSync setting (Windows registry)

UseRemoteProvider property

data access pages

UserForm 2nd

users

adding 2nd

SQL 2nd

assigning rights

user-level security 2nd 3rd 4th

assigning to groups 2nd

creating

user-level security 2nd 3rd 4th 5th

groups

adding, SQL 2nd

members, testing for 2nd

removing, SQL 2nd

listing all users 2nd

passwords

assigning 2nd

clearing

ensuring users have passwords 2nd

listing users without passwords 2nd

prohibiting from creating objects 2nd

removing 2nd

from groups 2nd

removing, SQL 2nd

security information, printing 2nd

SQL

administration 2nd 3rd 4th 5th 6th

Users collection

Append method 2nd

Users group

usr object-naming prefix

USysRegInfo table

structure 2nd

USysRegInfo tables

importing

utilities

Compact