1Study Tips
124Multi-Valued Lookup Fields
2Steps:
125Creating:
3Key Concepts:
126Real-World Example of Lookup Setup Scenario:
4Create a Database from a Template
127Steps:
5Steps:
128Advantages:
6Benefits:
129Using Query Design View
7Limitations:
130Steps to Create a Select Query in Design View:
8Save a Database in a Specific Format
131Example:
9Formats:
132Using the Simple Query Wizard
10Saving in a different format:
133Steps to Use the Simple Query Wizard:
11Exporting Objects (e.g., reports) to PDF:
134Sort, Filter, and Group Data
12Create and Modify Relationships
135Steps to Sort Data:
13Types of Relationships:
136Example:
14Steps to Create Relationships:
137Common Operators:
15Best Practices:
138Example:
16Set Primary Keys and Foreign Keys Primary Keys
139Grouping Data
17Characteristics:
140Steps to Group Data:
18How to Set a Primary Key:
141Example:
19Composite Keys:
142Use Calculated Fields and Parameters
20Foreign Keys
143Creating Calculated Fields
21Purpose:
144Steps to Create a Calculated Field:
22Example:
145Example of a Simple Calculation:
23To Create a Foreign Key:
146Example with Date Calculations:
24Enforce Referential Integrity
147Using Parameters in Queries
25What It Does:
148Steps to Use Parameters:
26How to Enable:
149Example of a Parameter Query:
27Cascade Options:
150Combining Parameters with Calculated Fields:
28Use Cases:
151Advanced Calculated Fields Example Example:
29Potential Issues Without Referential Integrity:
152Steps to Create an Append Query:
30Printing Database Objects
153Example:
31Printing Tables and Queries
154Update Queries
32Printing Forms
155Steps to Create an Update Query:
33Printing Reports
156Example:
34Page Setup Options
157Delete Queries
35Exporting Data
158Steps to Create a Delete Query:
36Supported Export Formats:
159Example:
37How to Export Data
160Make-Table Queries
38Export to Excel
161Steps to Create a Make-Table Query:
39Export to PDF/XPS
162Example:
40Export to Text or CSV
163Common Aggregate Functions:
41Automation Tip:
164Using Aggregate Functions in Queries:
42Navigate Through Records and Objects
165Steps to Use Aggregate Functions:
43Navigating Records in Tables, Queries, and Forms
166Example:
44Navigation Buttons:
167Advanced Aggregate Example:
45Navigating Database Objects
168Types of Joins:
46Switching Between Open Objects
169Creating Joins in Queries:
47Filtering Navigation Pane
170Example of Inner Join:
48Compact and Repair a Database
171Example of Left Join:
49Why Compact and Repair?
172Using the Form Wizard
50Steps to Compact and Repair:
173Steps to Create a Form Using the Form Wizard:
51Set Auto Compact on Close:
174Using a Blank Form
52Caution:
175Steps to Create a Form Using a Blank Form:
53Repairing a Corrupted Database
176Adding Labels
54Symptoms of Corruption:
177Steps to Add a Label:
55How to Repair Manually:
178Label Properties:
56Backing Up a Database
179Adding Text Boxes
57Steps to Back Up:
180Steps to Add a Text Box:
58Automate Backups with Task Scheduler (Advanced):
181Text Box Properties:
59Best Practices for Database Maintenance
182Adding Combo Boxes
60Datasheet View
183Steps to Add a Combo Box:
61Creating a Table in Datasheet View:
184Combo Box Properties:
62Advantages:
185Adding Buttons
63Limitations:
186Steps to Add a Button:
64Design View
187Button Properties:
65Creating a Table in Design View:
1885.3 Format Forms
66Field Data Types (Access 2016):
189Applying Themes
67Example Field Setup:
190Steps to Apply a Theme:
68Create Tables from Templates and External Data
191Benefits of Using Themes:
69Create Tables from Templates
192Applying Conditional Formatting
70Create Tables from External Data
193Steps to Apply Conditional Formatting:
71Supported Sources:
194Benefits of Conditional Formatting:
72Steps to Import from Excel:
195Formatting Forms Using the Layout View
73Options Available:
1965.4 Set Form Properties
74Import Tips:
197Adjusting Default Views
75Hide, Freeze, and Reorder Fields
198Common Views for Forms:
76Hide Fields
199Setting the Default View for a Form:
77Steps:
200Setting Navigation Options
78To Unhide:
201Steps to Set Navigation Buttons:
79Use Cases:
202When to Use Navigation Buttons:
80Freeze Fields
203Adjusting Form Border and Control Behavior
81Steps:
204Form Border Style:
82Reorder Fields
205Setting Formβs Allow Additions, Deletions, and Edits
83Steps:
206Steps to Set Additions, Deletions, and Edits:
84Add and Delete Fields
207When to Use These Properties:
85Add Fields (Datasheet View)
208Setting Form's Modal and Pop-Up Properties
86Alternatively:
209Steps to Set Modal and Pop-Up Properties:
87Best Practices:
210Using the Report Wizard
88Add Fields (Design View)
211Steps to Create a Report Using the Report Wizard:
89Additional Options:
212Benefits of Using the Report Wizard:
90Delete Fields
213Using a Blank Report
91To Delete in Datasheet View:
214Steps to Create a Report Using a Blank Report:
92To Delete in Design View:
215Adding Grouping, Sorting, and Totals
93Additional Field Properties and Features
216Steps to Add Grouping and Sorting:
943.3 Create and Modify Fields
217Benefits of Grouping, Sorting, and Totals:
95Data Types Overview
218Inserting Images, Charts, and Page Numbers
96Common Data Types in Access 2016:
219Steps to Insert an Image:
97Choosing the Correct Data Type:
220Steps to Insert a Chart:
98Setting and Modifying Data Types
221Steps to Insert Page Numbers:
99In Datasheet View:
222Property Sheet.
100In Design View:
223Set Page Layout
101Field Properties
224Orientation.
102Common Field Properties:
225Apply Styles
103Use Input Masks and Default Values
226Set Page Footers and Headers
104Examples:
227Setting Basic Report Properties
105Creating an Input Mask:
228Advanced Report Properties
106Symbol Description
229Setting Validation Rules
107Default Values
230Setting Validation Text
108Examples:
231Validation Rule Best Practices
109Setting a Default Value:
232Field-Level Validation
110Best Practices:
233Record-Level Validation
111Additional Field Customizations Field Caption
234Best Practices for Field and Record-Level Validation
112Validation Rule & Text
235Input Masks
1133.4 Create Lookup Fields
236Default Values
114Using the Lookup Wizard
237Best Practices for Input Masks and Default Values
115From an Existing Table (Relational Lookup)
238Import Data from Excel
116Steps:
239Import Data from Text Files (CSV or TXT)
117Benefits:
240Import Data from Other Databases (ODBC, SQL Server, etc.)
118From a Static List
241Export Data to Excel
119Steps:
242Export Data to Text (CSV, TXT)
120Field Properties for Lookup Fields
243Export Data to PDF
121Property Description
244Export Data to Word
122Tips for Lookup Fields
245Linking to an External Database (SQL Server, Oracle, etc.)
123Modifying Lookup Fields
246Linking to Other External Data Sources (Excel, SharePoint, etc.)
