When Importing
1. Remembering to click on the IMPORT links, not export!
2. Remember that a CSV is a TEXT file
3. Click “First row contains column headings” in the import wizard
4. Remember to CHECK and select the correct data types!
5. Select a field as the primary key IF it is described as UNIQUE, otherwise select “No Primary key”
6. Check your table in DESIGN view after the import and fix any remaining formatting errors
When making queries
1. SAVE AND CLOSE the query before doing a calculation
2. Remember the query criteria is written “show only the fields…”
in the exam question
When making reports
1. Remember to select the
query in the report wizard, step 1
2. Remember to select landscape/portrait
and any sort options
3. To get rid of # symbols, resize the fields in design
view
4. Use CTRL as a shortcut to highlight two boxes at once
5. USE
LABELS FOR YOUR NAME!!
1. Remembering to click on the IMPORT links, not export!
2. Remember that a CSV is a TEXT file
3. Click “First row contains column headings” in the import wizard
4. Remember to CHECK and select the correct data types!
5. Select a field as the primary key IF it is described as UNIQUE, otherwise select “No Primary key”
6. Check your table in DESIGN view after the import and fix any remaining formatting errors
When making queries
1. SAVE AND CLOSE the query before doing a calculation
2. Remember the query criteria is written “show only the fields…”
in the exam question
When making reports
1. Remember to select the
query in the report wizard, step 1
2. Remember to select landscape/portrait
and any sort options
3. To get rid of # symbols, resize the fields in design
view
4. Use CTRL as a shortcut to highlight two boxes at once
5. USE
LABELS FOR YOUR NAME!!