Access 2016 Intermediate

Table of Contents

ABOUT OFFICEPRO – WE CHANGE LIVES! ...............................................................I

WHAT TO EXPECT FROM OFFICEPRO?...................................................................II

TABLE OF CONTENTS...........................................................................................III

LESSON 1 -

SETTING FIELD PROPERTIES ............................................................1 Using Field Properties...............................................................................................2 Limiting Field Size .....................................................................................................3 Setting Number Formats ..........................................................................................6 Setting Date/Time Formats ......................................................................................9 Setting Yes/No Formats..........................................................................................11 Setting Default Values ............................................................................................14 Setting Validation Rules..........................................................................................15 Creating an Input Mask - Wizard............................................................................18 Creating an Input Mask Manually ..........................................................................20 Creating a Custom Input Mask ...............................................................................22 Typing a Lookup List ...............................................................................................27 Modifying Lookup Properties .................................................................................30 Exercise...................................................................................................................33 MODIFYING TABLES .....................................................................35 Inserting a Column into a Table..............................................................................36 Changing a Column Name ......................................................................................37 Deleting a Column ..................................................................................................39 Inserting a Lookup Column.....................................................................................40 Inserting a Hyperlink Column .................................................................................44 Creating a Many-to-Many Relationship .................................................................45 Exercise...................................................................................................................49 USING OPERATORS IN QUERIES ....................................................51 Using Comparison Operators .................................................................................52 Using an And Condition ..........................................................................................54 Using an Or Condition ............................................................................................57 Using the Between And Operator ..........................................................................59

LESSON 2 -

LESSON 3 -

OFFICEPRO, Inc.

Page iii