Little skill is needed to create a basic Microsoft Access database. Beginners often find Access useful when organizing a DVD collection, recipes, contact information or financial data. Most basic features are self-explanatory when you begin working with them. Each of the main components provides you with a wizard to help in the creation process.
Video of the Day
Create the database by opening any version of Microsoft Access. Click "File" > "New." Enter a name for your database and select a location for the database to be stored. Once created, the database window will appear, which allows you to create and manage all components of the database, such as tables, queries, forms and reports.
Tables and Queries
Tables and queries are required for any successful database. Tables store all data and records. Each record is stored on a separate row. Click on "Tables" in the database window to create a new table. Wizard Mode will assist you with the creation process. Design View gives you more control over the type of field, such as data type, format and default value. Either use queries or open the newly created table to enter data.Create queries by clicking "Queries" in the database window. Queries are your data manipulation tools. You can add, remove, edit and sort any and all data within any existing tables. Queries can also be used to create tables. Use either Wizard Mode or Design View to create your query. Beginners may find Wizard Mode easiest, especially to set up a base query that you can later edit in Design View.
Forms and Reports
Forms often run queries. Forms are the graphical side of your Access database. Click "Forms" to manage and create forms. Both forms and reports can be created through Wizard Mode or Design View. Wizard Mode is normally used to create a template for your form. Design View is then used to change the arrangement of items. Click the wand icon on the toolbox while in Design View to start a wizard each time you draw an object on your form.Print, email and store static reports of your data at any time by creating reports. Reports are generated from tables and queries. Queries allow you to filter which records appear on your report. Buttons on a form often run a report. However, you can run reports or queries at any point by double-clicking them while in the appropriate section in the database window.
Keep your personal information safe by securing your database. Under "Tools" > "Security," you can add a password to your database. You can also manage which users can access your database. In addition, see "Tools" > "Startup" to manage which items appear when a user starts your database. This includes menus and toolbars, which can help prevent unauthorized edits to your database.