BCA II ACCESS UNIT 1 TEST
--REVIEW FOR PROJECTS 1, 2, 3 AND INTEGRATION

• Create a database
• Create tables and forms
• Update data
• Format datasheet view
• Create a report
• Create a simple query
• Create a simple query using wildcards
• Create a query, sorting and changing captions
• Create a query limiting the results to top 3 results
• Set join properties
• Create calculated fields
• Create statistics--grouped
• Create an append query that appends a query in another database
• Create an delete query
• Add a field to a table
• Set referential integrity
• Compact a database
• Import a spreadsheet to access
• Export a table to excel
• Export data to word
• Export a report as a .pdf