Access Basic (I)

Content
1.1 Starting Access
1.2 Opening an Existing Database
1.3 Moving Around in Access
1.4 Opening an Object in Datasheet View
1.5 Opening an Object in Design View
1.6 Switching Between Datasheet and Design View
1.7 Navigating in Datasheet View
1.8 Closing an Object

2.1 Creating a Database
2.2 Creating a Table
2.3 Adding Fields to Tables
2.4 Adding Records
2.5 Editing Records
2.6 Moving Fields
2.7 Deleting Records

3.1 Formatting a Table
3.2 Sorting Records in a Table
3.3 Finding Records in a Table
3.4 Applying a Filter to a Table
3.5 Removing a Filter
3.6 Establishing a Relationship
3.7 Enforcing Referential Integrity
3.8 Creating Subdatasheets
3.9 Importing Records from an External Source
3.10 Copying Records into a Table

4.1 Creating a Query Using the Simple Query Wizard
4.2 Specifying Criteria in a Query
4.3 Creating a Query in Design View
4.4 Creating a Calculated Field
4.5 Creating a Multiple-Table Query


5.1 Creating a Form Using AutoForm
5.2 Creating a Form Using the Form Wizard
5.3 Adding Controls to a Form
5.4 Modifying Control Properties
5.5 Resizing Controls on Forms
5.6 Creating a Form in Design View
5.7 Entering Records into a Form

6.1 Creating a Report Using AutoReport
6.2 Creating a Report Using the Report Wizard
6.3 Adding a Control to a Report
6.4 Creating a Report in Design View
6.5 Formatting a Report
6.6 Creating Calculated Controls

Learning Access Database with Northwind 2007 sample database (1)

Download Example: https://1drv.ms/u/s!ApI9pTaAYa6fiBOgkO4TQVE-bMBa

I. Basic Workflow

a) Startup/Login

When you open the Northwind 2007 sample first time you may see ‘Startup Screen’ or ‘Login Dialog’.

-You have to click ‘Enable Content’ and will see ‘Login Dialog’ form.

Next time, you open the Database, you will always see ‘Login Dialog’.

Q. How to control this event?

Ans: This is why the system has ‘AutoExec’ macro.

Let’s learn this ‘AutoExec’ macro.

1.       Go to Macro,

2.       Right Click ‘AutoExec’

3.       Select Design View and Click.

You see two If statements,

1.       IF not trust app THEN OPEN ‘Startup Screen’

2.       IF trust app THEN OPEN ‘Login Dialog’

When you click Login button in the ‘Login Dialog’ form, it will be closed and ‘Home’ form will appear.

To see this Embed Macro,

1.       Open ‘Login Dialog’ design view.

2.       Go to Login button properties, OnClick (Event) and click …

System uses the following logic:

1.       Check Combobox (DropDown list) of the Employee and

IF this is not empty

2.       Close the Login Dialog form and

3.       Open ‘Home’ form

IF there is no Employee name

-          Display Messagebox.