How To Create a New Database in Access 2007
Before we begin to create a new database, we will first look at some related terms
Database Terms
Table
A table is a collection of related information about a topic arranged in Rows and columns. Information about an item is displayed in Rows. Columns contain the same relative type of information of each item.
The table has a header Row which can be called field, this tells you what data is contained in the columns such as first names, surnames etc.
Query
A Query is a method you use to extract information in a database.
The result you get will be based on the conditions you set.
Record set
A record set is a table that displays groups of records from a base table or as a query result.
Form
A form is provides you with an easy way to enter and view information on your database. Forms only displays one record at a time.
Report
A report helps you to summarize document information from your database
Macro is a quick way of performing all known actions into one.
How to Create a New Database
You can create a new database from scratch or you can create a database from the database wizard.
Create New Database
How to create a new database from scratch:
- Click the Microsoft Office Button
- Click New
- Click the New Blank Database icon
- Type in a name for the database
Click Create
How to create New Database with Templates
To create a new database from the database templates:
- Click the Microsoft Office Button
- Click New
- Choose the type of database you wish to create
- Type in the name for the database
- Click Create
