CCNC/CCNC Module 5/The database application/Adjusting the application settings
Changing the view
Working in Table View
In "Tables" view you can create a new table from nothing or use a wizard to prompt you design decisions. You can also create a view that allows you to put "filters" on existing tables.
Working in Forms View
In "Forms" view you can create forms for data entry and viewing. You can also use a wizard to guide you through the process of creating a form.
Working in Queries View
In "Queries" view you can create queries that filter data, join together tables and specify which fileds are to be displayed and specify the properties for sorting the data.
You can also use a wizard to guide you through the process of creating a query.
And if you feel comfortable using the Structured Query Language (SQL) you can create your queries by hand using only SQL syntax.
Working in Reports View
In "Reports" view you will be guided by a wizard to create new views or you can select existing views to edit, delete or run.
Test your knowledge