Are you prepared to take the test for the database module? If you can do all of the
following in a direct and efficient manner, you should do well:
- Open an existing database
- Create a new database
- Create a table (Assign field names, choose field types) You should be able to create a
table with and without a primary key.
- Add a field to a table
- Delete a field from a table
- Switch between the different table views (design view, datasheet view)
- Know what each view is optimized for (design view is for creating and modifying the
table structure, and datasheet view is for entering, modifying and viewing records)
- Add/change/delete records in a table
- Find records with certain field values
- Know when an electronic database is part of the solution to a problem. For example, if
the problem is "how to keep track of monthly expenses" a database probably isn't
necessary. If the problem is "how do to keep track of a vinyl LP record
collection" a database is probably part of the solution.
- Given a problem description that requires a database solution decide what tables need to
be created. For each table decide what fields, field names, and field types are required.
- Sort records in datasheet view
- Filter records by selection and by form
- Create and modify a form
- Use a form for data entry
- Create and run a query (with and without selection criteria)
- Create and modify a report. You should be able to create a report with the source
records coming from a table or query.